thanks for your help. i learnt SAS for a week and trying to work on a assignment . I am a newbie. I tweaked a little bit but now I get a different error pasted below. %MACRO CHGFMT (i=); %DO i=1 %TO 13; j=i-1; DATA SNOUT&i_CHAR; set SNOUT&i; RANK&i_Ch = strip(put(rank&i,3.)); RANK&j_Ch = strip(put(rank&j,3.)); DROP rank&i; DROP rank&j; RENAME rank&i =RANK&i_CH; RENAME rank&j =RANK&j_CH; RUN; PROC PRINT DATA=SNOUT&i_CHAR; RUN; PROC CONTENTS DATA=SNOUT&i_CHAR; RUN; %END; %MEND; %CHGFMT; i get syntax error after executing and the log doesn't give me a clear pic. Can anyone please help me Thanks ERROR: Expected close parenthesis after macro function invocation not found. NOTE: Variable rank is uninitialized. NOTE: Variable rank12 is uninitialized. WARNING: The variable rank in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable rank12 in the DROP, KEEP, or RENAME list has never been referenced. NOTE: There were 0 observations read from the data set WORK.SNOUT. NOTE: The data set WORK.SNOUTCH has 0 observations and 8 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.01 seconds
... View more