the data set name is two_clean. I have column names like 201808 201901 201908 202001 column Name 201808 201901 201908 202001 Row 1 _1_5_4_P _1_5_4_P _1_5_4_P _1_5_4_P Here is my code: %MACRO pairs(pair1, pair2, pair3, pair4); DATA year&pair1; SET two_clean; WHERE %tslit(&pair2) NE ''; IF &pair2 NE '' AND &pair3='' THEN &pair3="Did not return"; KEEP ID &pair2 &pair3; RUN; %mend pairs; %pairs(1,&term3,&term2,&term3); Error Message:- SYMBOLGEN: Macro variable PAIR2 resolves to 202208 SYMBOLGEN: Macro variable PAIR3 resolves to 202301 SYMBOLGEN: Macro variable PAIR3 resolves to 202301 NOTE: Line generated by the macro variable "PAIR3". 53 202301 ______ 180 MPRINT(PAIRS): IF 202208 NE '' AND 202301='' THEN 202301="Did not return"; SYMBOLGEN: Macro variable PAIR2 resolves to 202208 SYMBOLGEN: Macro variable PAIR3 resolves to 202301 NOTE 138-205: Line generated by the macro variable "PAIR2". 53 202208 ______ 22 ERROR 180-322: Statement is not valid or it is used out of proper order. ERROR 22-322: Syntax error, expecting one of the following: a name, -, :, ;, _ALL_, _CHARACTER_, _CHAR_, _NUMERIC_. NOTE: Line generated by the macro variable "PAIR2". 53 202208 ______ 200 ERROR 200-322: The symbol is not recognized and will be ignored. MPRINT(PAIRS): KEEP ID 202208 202301; MPRINT(PAIRS): RUN;
... View more
