How can I change this macro to create all the variables in one data set? I want  First_ADD and Second_ADD in the out flag data set. I want to do this for multiple varibles using the macro but it keeps overwriting itself and keeping the last flag that was created by the macro. Thank you!   %MACRO FLAG(VAR1,VAR2,FLAGNAME); DATA FLAG; SET RULE1; &FLAGNAME=0; DO _N_=1 to countw(&VAR1,',') while(&FLAGNAME=0); word=scan(&VAR1,_N_,','); if word=' ' then continue; if indexw(trim(&VAR2),trim(word),',') then &FLAGNAME=1; end; drop word; run; %MEND FLAG; %FLAG(Addresses1,Addresses2,First_ADD); %FLAG(Addresses1,Addresses3,Second_ADD); ... View more

I want to compare the variables name A to Name B. Name a is a concatenation separated by commas of multiple names from an A file and Name B is a concatenation separated by commas of multiple name from a B file. I want to compare them so that if there are any matches between any of the non missing names within NAMEA to any of the non missing names in NAMEB it will output as a match indicated by 1. I'm wondering if an array with a do loop would somehow work. Thank you!   Original File     ID    Name_A          Name B                 Match_Flag 1      MILLIE,MIL     MIL                         1 2     BILL,BOB,,       BOB,,                     1 3     KYLE,,              BILL,BROWN      0 4     ,,                         ,,                             0   ... View more

I am running a macro that creates two data sets, I want to output 2 datasets to the same excel worksheet. Then I want to call the macro again and add another worksheet with two datasets to the same workbook. Whenever I run this code, the second run does not add another worksheet. I am wondering what is going on. Thank you     ods excel file='\path' options( sheet_interval='NONE' sheet_name="&SCHEMA"); proc report data=TABLE_DIFF_FINAL; run; proc report data=VAR_DIFF_FINAL; run; ods excel close;     ... View more