06-06-2017 01:35 PM
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?
06-07-2017 09:55 AM
proc sql; create table want as select * from z1 union all corr select * from z2 union all corr ............ select * from z10 ; quit;