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! 

CFC_SAS_Communities_400x225.jpg

Call for content now open!

It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.

Submit your proposal →

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
  • 2254 views
  • 3 likes
  • 2 in conversation