I did try running the codes in EG, but it always gave error msg. I guess it was server issue. The error msg is 'ERROR: Insufficient authorization to access /sas/sas94/config/Lev3/SASApp/C:......'. If exporting files from EG 'Export', it will need some manual works - export files one by one. But I think it got to be a better way to export FILES in EG since it is a powerful tool.  Thanks you for your input. Hope EG will improve this soon. ... View more

I still got the same error message I copied my code here, please see if I misunderstood you. %LET Amantadi = '17520', '17521', '17530'; %LET Rimantad = '00730'; %LET Tamiflu = '98980', '98981', '26729', '73441'; %LET Relenza = '92221'; %LET GCNS = &Amantadi. &Rimantad. &Tamiflu. &Relenza.; /*%LET GCNS = &Amantadi,&Rimantad,&Tamiflu,&Relenza;*/ %LET HC = ('A', 'J', 'K', 'L', 'S'); %PUT GCNS=&GCNS; . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . WHERE PAID_DATE_YEAR_MONTH = '201212'                                                                                                                                                                                                                                                          AND GCNS IN &GCNS Log: ERROR: Error Code: -102  ASA Error -131: Syntax error near '17520' Thank you so much!! ... View more

Thank you, Astounding. Sorry, I pasted wrong WHERE clause value in my original email. but You are correct, I expect the macros can give me the same result as WHERE GCNS in ('17520','00730','98980','92221','17521','17530','98981','26729','73441'). So far I have not get it worked yet. Thank you for any suggestions. ... View more

Reeza, Thank you for responding my questions. As you advised, I changed code without brackets %LET Amantadi = '17520', '17521', '17530'; %LET Rimantad = '00730'; %LET Tamiflu = '98980', '98981', '26729', '73441'; %LET Relenza = '92221'; and coded in WHERE clause AND GCNs IN (&Amantadi,&Rimantad,&Tamiflu,&Relenza) The log message is ERROR: Error Code: -102  ASA Error -131: Syntax error near '17520' I tried the other way %LET Amantadi = '17520', '17521', '17530'; %LET Rimantad = '00730'; %LET Tamiflu = '98980', '98981', '26729', '73441'; %LET Relenza = '92221'; %LET GCNS = &Amantadi,&Rimantad,&Tamiflu,&Relenza; %PUT GCNS=&GCNS; Log result was correct, but when I ran the pgm with code AND GCNS IN &GCNS the log message still "ERROR: Error Code: -102  ASA Error -131: Syntax error near '17520' I expect the macros can result in WHERE clause as WHERE GCNS in ('17520','00730','98980','92221','17521','17530','98981','26729','73441')   ----- by the way, I pasted wrong WHERE clause value in my original email. Astounding was correct, my original WHERE clause won't work. At this point, any idea why I got the error message? Thank you all for any suggestions. ... View more