topic Re: Select variables to merge in SAS Programming

Select variables to merge

ramgouveia — Mon, 12 Apr 2021 14:06:28 GMT

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?

Re: Select variables to merge

Reeza — Wed, 07 Apr 2021 21:34:31 GMT

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

Re: Select variables to merge

ramgouveia — Wed, 07 Apr 2021 22:05:10 GMT

Thank you @Reeza!