topic Re: Append the result datasets in SAS Programming

Append the result datasets

GN0001 — Tue, 18 Jan 2022 03:43:58 GMT

/* 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

Re: Append the result datasets

SASKiwi — Tue, 18 Jan 2022 03:52:28 GMT

Don't think you need macro variables for that:

data thisdata;
set data1 - data4;
run;

Re: Append the result datasets

s_lassen — Tue, 18 Jan 2022 11:34:53 GMT

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);

Re: Append the result datasets

GN0001 — Sat, 22 Jan 2022 03:25:54 GMT

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