topic Merge Several Datasets Having The Same Variable Names in SAS Procedures

Merge Several Datasets Having The Same Variable Names

NKormanik — Wed, 06 Jul 2016 02:45:17 GMT

I want to merge 9 files.

Each of the files has the same 3 variables:

X, Y, Percent (out datasets from 9 Proc Freq runs)

Two issues come up:

-- Do I have to rename Y in each of the files beforehand? (Doesn't SAS automatically do that?)

-- I don't want to keep the Percent column in any of the files. How to most easily dump that one?

data merged;
merge one
merge two
merge three;
.
merge nine
by X;
run

Any help greatly appreciated.

Nicholas Kormanik

Re: Merge Several Datasets Having The Same Variable Names

Ksharp — Wed, 06 Jul 2016 02:53:30 GMT

You have to rename Y since SAS would not do it for you, Keep the variables you need.

data merged;
merge 
one(keep=x y rename=(y=y1))
two(keep=x y rename=(y=y2)
three(keep=x y rename=(y=y3))
....
nine(keep=x y rename=(y=y9));
by X;
run;

Re: Merge Several Datasets Having The Same Variable Names

NKormanik — Wed, 06 Jul 2016 04:27:09 GMT

Thank you, Xia Keshan! Beautifully done.

By the way, really good to see you back here. What a wonderful asset to this community.

Nicholas