BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
ramgouveia
Obsidian | Level 7

I have this code:

 

Data M;
Merge MV (in=A) MERGEED202001B (in=B);
By UC;

If A or B;
Run;

 

But I want to keep only some variables of the two datasets.

 

Which command line should I add?

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User
KEEP. You can add it as a data set option similar to IN.

merge missingValues(in=A keep= list of variables to keep) .... MERGEEFATURADMRSS202001B (in=B keep = list of variables to keep);

View solution in original post

2 REPLIES 2
Reeza
Super User
KEEP. You can add it as a data set option similar to IN.

merge missingValues(in=A keep= list of variables to keep) .... MERGEEFATURADMRSS202001B (in=B keep = list of variables to keep);
ramgouveia
Obsidian | Level 7
Thank you @Reeza!
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
  • 1098 views
  • 3 likes
  • 2 in conversation