topic running the same code on multiple data in SAS Programming

running the same code on multiple data

lillymaginta — Wed, 04 Oct 2017 20:20:46 GMT

I have multiple datasets, I want to run the same code for each and then combine them in one dataset. Can do that in one step?

data a; set dx_md_01;

where name in (druga, drugb, drugc);

run;

data b; set dx_md_02;

where name in (druga, drugb, drugc);

run;

data c; set dx_md_03;

where name in (druga, drugb, drugc);

run;

proc append base= a data=b;run;

proc append base= a data=c;run;

PaigeMiller — Wed, 04 Oct 2017 20:25:56 GMT

data all;
set dx_md_01 dx_md_02 dx_md_03;
where name in (druga, drugb, drugc);
run;

lillymaginta — Wed, 04 Oct 2017 21:10:25 GMT

Thank you!