match merging two data-sets using the "by" statement when variable names are different

Accepted Solution Solved
Reply
Contributor
Posts: 41
Accepted Solution

match merging two data-sets using the "by" statement when variable names are different

Hello,


when merging two data sets using the by statement, like in this example:


DATA dataC;

MERGE dataA dataB;

BY var1;


I can match-merge the observations of two datasets (dataA and dataB) into a new dataset (dataC) using a specified variable (var1) as the key.


However, is there an easy way when merging two datasets using the "by" statement where the variable names are different in deach dataset? For example, if i dataA the variable is called var1 and in dataB the variable is called varB?


Regards,

P.


Accepted Solutions
Solution
‎12-18-2012 03:07 PM
Super User
Posts: 17,868

Re: match merging two data-sets using the "by" statement when variable names are different

rename the variable in the merge statement so they are the same or use PROC SQL.

DATA dataC;

MERGE dataA dataB (rename=varB=var1);

BY var1;


View solution in original post


All Replies
Solution
‎12-18-2012 03:07 PM
Super User
Posts: 17,868

Re: match merging two data-sets using the "by" statement when variable names are different

rename the variable in the merge statement so they are the same or use PROC SQL.

DATA dataC;

MERGE dataA dataB (rename=varB=var1);

BY var1;


☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 172 views
  • 0 likes
  • 2 in conversation