I am reading in a set of data sets that share a naming convention, but each subsequent data set name has a suffix that is incremented by 1--i.e., tx1, tx2, . . . tx28. Three of the 28 data sets have a variable that is num, when in the rest of the data sets this variable is char. I am trying to make the type consistent before appending these data sets; however, I am getting a SPOOL error.
%macro vartype;
%do i=1 %to 28;
data tx2&i;
set tx&i.;
CASE_CAUSE_NBR2 = trim(left(put(CASE_CAUSE_NBR, 9.);
run;
%end;
%mend vartype;
%vartype;
When I comment out the line that generates the new variable, the code runs successfully; however, when I include it, that's when the error arises . . .
MLOGIC(VARTYPE): %DO loop index variable I is now 28; loop will iterate again. SYMBOLGEN: Macro variable I resolves to 28 MPRINT(VARTYPE): data tx228; SYMBOLGEN: Macro variable I resolves to 28 22: LINE and COLUMN cannot be determined. NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred. ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, ), *, **, +, ',', -, /, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOT, NOTIN, OR, ^, ^=, |, ||, ~, ~=. 76: LINE and COLUMN cannot be determined. NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred. ERROR 76-322: Syntax error, statement will be ignored. MPRINT(VARTYPE): set tx28; MPRINT(VARTYPE): CASE_CAUSE_NBR2 = trim(left(put(CASE_CAUSE_NBR, 9.); MPRINT(VARTYPE): run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.TX228 may be incomplete. When this step was stopped there were 0 observations and 66 variables. WARNING: Data set WORK.TX228 was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds
Any ideas?
... View more
