Hello So, I need to perform the proc mixed test, using data imported from excel. The data table is correct, but when performing the analysis in sas, the mentioned error appears. The log is described below....
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
61
62
63 PROC IMPORT DATAFILE="/folders/myshortcuts/pasta_sas_university/CONSUMODENDE.XLSX"
64 OUT=WORK.MYEXCEL
65 DBMS=XLSX
66 REPLACE;
NOTE: The previous statement has been deleted.
67 GETNAMES=YES
68 RUN;
___
22
202
ERROR 22-322: Expecting ;.
ERROR 202-322: The option or parameter is not recognized and will be ignored.
69
70 /** Print the results. **/
71
NOTE: The import data set has 128 observations and 14 variables.
NOTE: WORK.MYEXCEL data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.04 seconds
cpu time 0.04 seconds
72 PROC PRINT DATA=WORK.MYEXCEL; RUn;
NOTE: There were 128 observations read from the data set WORK.MYEXCEL.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.62 seconds
cpu time 0.63 seconds
73
NOTE: PROCEDURE MIXED used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
ERROR: Variable MOg in list does not match type prescribed for this list.
NOTE: The SAS System stopped processing this step because of errors.
74 PROC MIXED DATA=WORK.MYEXCEL;
75 CLASS Per Trat Anim;
76 MODEL MOg = trat;
77 RUN;
78
79
80 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
93
... View more