You should be getting both version of the output. I am not a user of EG interface, but my guess is: CREATE TABLE TEST2 AS creates the TEST2 dataset in the WORK library (Output data) and SELECT * FROM TEST2; prints the contents of TEST2 in the Results. That last statement is just there for your convenience, it is not required.    Further processing should use the TEST2 dataset. ... View more

First clarify if you want Statement_02 as used in your assignment or Statement2 as used in your Retain and Array statements. You don't help yourself by having two different indexing variables count and CountForStmt. No need for any do loop since your CountForStmt is the index into the array that you need:   if CountForStmt> 1 then misser[CountForStmt]=statement; replace all of the 2 through 24 code that you indicate.   ... View more

To check you code I made a sligh change: %macro product; /*This is the Macro code to generate statment with format MCCYYYYMM.MALD_STMT. */ %local year month fname ; %do year=2013 %to 2016; %do month=1 %to 12; %let fname=MC&year.%sysfunc(putn(&month,Z2)).Acct; /* %if %sysfunc(exist(&fname)) %then &fname ; <<< line replaced by next one */ %put &FNAME; %end; %end; %mend; data TotalStatement ; /*this is the step to append all the Acct tables from MC201301 TO MC201612. */ set %product ; ; /* <<< one more semicolon added to close SET statement */ run;  check generated code by macro in the log. All file names created as expected; if file MC201612.acct exists then the only real change is adding the semicolon after set statement.   ... View more