Append the result datasets

[GN0001]

/* data1, data2, data3, data4*/


%let readFrom = data1;

data thisdata;
set &readfrom;
run;

Hello team,

On the code on the top, The macro variable readFrom reads from data1, data2, data3 and data4. Each time we replace readfrom variable macro with data1, data2, data3 and data4

I want to save the result thisdata in a table , which is read from data1 and then append to it  thisdata when readfrom variable is replaced by data2.

We keep the result data1, then append to it data2, then data3 and data4.

Any help is greatly appreciated.

Regards,

blueblue

[SASKiwi]

Don't think you need macro variables for that:

data thisdata;
set data1 - data4;
run;

[s_lassen]

Unless you do something special with the data first, you can just read them in one fell swoop:

%let readfrom=data1 data2 data3 data_Test data_OK;
data thisdata;
set &readfrom;
run;

But if you need to do something special with each input data set first, you may want to do something like this:

%macro read_data(readfrom,out=final_output);
  %local i;
  %if %sysfunc(exist(&out)) %then %do;
    proc delete data=&out;run;
    %end;
   %do i=1 %to %sysfunc(countw(&readfrom));
      data temp_out;
          set %scan(&readfrom,&i);
      run;
      /* You will probably have more processing here, in this case */
      
      /* if BASE dataset does not exist, the input is just copied, no problem */
      proc append data=temp_out base=&out;
      run;
      %end;
%mend;

%read_data(&readfrom);

[GN0001]

Hello team member,

I understood the first part only, that is enough for me for now. I will come back to this later. 
Blue & Black