the information in log: 23 options symbolgen mlogic mprint; 24 %let patients=002 003 004; 25 %let j=2; 26 %let shortID=%qscan(%superQ(Patients),&j.);*the patient ID of the jth patient from the Patients list; SYMBOLGEN: Macro variable J resolves to 2 27 filename wear "/data/work/sasusers/jxs004/GingerYang/ReAct/data/original data from ReAct/Actigraph 27 ! New/&shortID./&shortID. scoring with sleep.xlsx"; SYMBOLGEN: Macro variable SHORTID resolves to 003 SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. SYMBOLGEN: Macro variable SHORTID resolves to 003 SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. 28 PROC IMPORT OUT=wear&shortID. DATAFILE=wear DBMS=xlsx REPLACE; SHEET="Daily"; GETNAMES=YES;RUN; SYMBOLGEN: Macro variable SHORTID resolves to 003 SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: The SAS System stopped processing this step because of errors. NOTE: Line generated by the macro variable "SHORTID". 28 wear003 ___ 22 ___ 200 ERROR 22-322: Syntax error, expecting one of the following: ;, (, DATAFILE, DATATABLE, DBMS, DEBUG, FILE, OUT, REPLACE, TABLE, _DEBUG_. ERROR 200-322: The symbol is not recognized and will be ignored.
... View more