Hello,
I am merging two rather large datasets each of which contain 4,000 variables and they both have the same variable names.
Given the large number of variables, I am wondering if there a SAS procedure that would allow me to rename all of the variables in a single dataset at once? Perhaps by adding a simple suffix or prefix?
I Googled around and found some PROC SQL options however, I am simply not familiar with SQL so the code was not very clear.
I am using SAS version 9.
Any help or references would be appreciated.
Thank you.
If they have the same variable names are you sure you want a merge and not an append?
Although it doesn't matter for this question you a SAS version is along the lines of 9.3 or 9.4 not just 9.
Well, that's quite simple, then.
data family;
set
mothers
children
;
run;
proc sort data=family;
by family_id;
run;
4000 variables in multiple datasets, that really does not sound like an efficient or easy way to be working. Personally I wouldn't work with any dataset having more than 30 odd variables, its just unworkable. Consider a restructure.
What does it mean restructure?
@Ronein wrote:
What does it mean restructure?
Transpose.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.