Hi Experts, How to find maximum length variable name    ... View more

Is it possible to use SAS for annotating the CRF(case report form in Clinical Trials) ? If so, please assist on how to do it? Looking forward to your response. Thanks In advance ... View more

Dear All,        I am quite a new user using SAS software. Please give me some suggestion base on the scenario below:    1. I have time series data for almost 2 years, which records the date and the amount of money that earn daily but in this case user record the data only weekdays (data for sat and sun is empty).  2. Base on the data i have, i try to identified, include dummy variables,  estimate and got the satisfied model to do forecasting. This also include the cosscorr pamarameter. 3. However, when i try to run forecasting  by using    proc arima data=data ; identify var=money crosscorr=(Monday Tuesday Thursday Friday ); estimate input=(Monday Tuesday Thursday Friday ) p= (0) (21) q= (1) (0); forecast lead=30 interval=day id=date out=results; run;   i got an error "The value for option LEAD= has been reduced to 0." and the results that i got is generate only for the trained variable. The lead forecasting is not generate for me. I am not sure the forecast syntax is working with my data struture or not.    Please feel free to leave some comments on this or please share some ideas how can i solve this issue.    Regards, santisouk  ... View more

Hello, I would like to ask for a clarification. If anyone could help me, I will be very much obliged. I have an experiment with five treatments (diets fed to animals in different parks), the response score was measured everyday, for 35 days. response variable is ordinal with three levels: 0 no effect, 1 mild effect, 2 high effect.   I have tried the following approach proc glimmix data=score method=?; class diet score; model score = diet / link=cumlogit dist=multinomial; random time / sub=park type=ar(1);   I have tried several 'method=' but would like advice which would best apply.   Also, in this paper with a similar approach, authors calculate the probability of score HIGH, which I would also like to apply here. Authors state the following formula but I'm not aware how to obtain the logit values in my case: p = exp(logit)/(1 + exp(logit)) https://www.mdpi.com/2076-2615/13/21/3350   Any ideas appreciated. ... View more

Hi there,   Hello, I'm new here and would like to apologise if my question seems a little illogical. I am looking for a tool for our company in the area of factory planning, with which unstructured Excel data must be converted into a structured, predefined form. I am analysing whether the raw data (machine, process and product information) of our customers can be converted into a structured format by an AI. This is necessary in order to be able to read in the data with the in-house software (VBA code is currently still being written for this). The target formatting is therefore known (import excel). However, the raw Excel data is different in every new project. The reorganisation affects, among other things, the arrangement of rows and columns, but also the generation of formulas.   Is there a way to solve this problem with SAS?   Many thanky in advance. Best regards     ... View more