BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
lillymaginta
Lapis Lazuli | Level 10

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;

 

1 ACCEPTED SOLUTION

Accepted Solutions
PaigeMiller
Diamond | Level 26
data all;
set dx_md_01 dx_md_02 dx_md_03;
where name in (druga, drugb, drugc);
run; 
--
Paige Miller

View solution in original post

2 REPLIES 2
PaigeMiller
Diamond | Level 26
data all;
set dx_md_01 dx_md_02 dx_md_03;
where name in (druga, drugb, drugc);
run; 
--
Paige Miller
lillymaginta
Lapis Lazuli | Level 10

Thank you! 

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1406 views
  • 3 likes
  • 2 in conversation