hello.
i have ten datasets (z1-z10). they all have a variable named "group". the variable length varies in the ten datasets from 2 to 6.
is there a way i can concatenate all 10 datasets and have the "group" variable length be 6 in the final dataset without any data being truncated?
many thanks.
christine
What about this:
data want;
length group $10.;
set z1-z10;
run;
proc sql;
create table want as
select * from z1
union all corr
select * from z2
union all corr
............
select * from z10
;
quit;
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.
Ready to level-up your skills? Choose your own adventure.