topic Re: Partial Merger of two data steps in SAS Procedures

Partial Merger of two data steps

MARS — Mon, 13 Jun 2011 13:39:55 GMT

Can some please help me on following issue.

I want to merge two sas datasets to create a new data set.

However, I only need to few specific variables from the second data set to be included in the new merged data set.

Can somebody tell me the SAS-CODE to use for this purpose i.e two include only specific variables from one data set in the merge step.

(Please not that I have very huge data sets)

Re: Partial Merger of two data steps

SPR — Mon, 13 Jun 2011 14:15:48 GMT

Hello Mars,

These are two common approaches to your problem:
a) with a datastep (d1 and d2 should be sorted by X before merging):
data c;
merge d1(in=d1ind) d2(keep=X A B);
if d1ind;
by X;
run;
a) with proc SQL:
proc SQL;
create table c as
select a.*, b.A, b.B
from d1 as a left join d2 as b on a.X=b.X
;quit;
Sincerely,
SPR

Re: Partial Merger of two data steps

MARS — Mon, 13 Jun 2011 14:18:36 GMT

Thanks