As question mentioned, I have several tables with product IDs variables from different time, a lot of which are in common. However, some of each contains ID that the others do not contain.
I want to combine them vertically based on their time, but only take the common variables in all the tables. Is there a simple step I can do that instead of checking for missing data in the new table everytime I combine them? Thank you!
Hello @psychopedia,
Do you mean something like this?
/* Create test data */
data have1;
array x year a b c d e (2011 10:14);
run;
data have2;
array x year b c d e f g (2012 20:25);
run;
data have3;
array x year c d e f g h (2013 30:35);
run;
/* Combine tables vertically, restricted to common variables */
proc sql;
create table want as
select * from have1 union all corr
select * from have2 union all corr
select * from have3;
quit;
proc print data=want noobs;
run;
You may want to check the sort order in dataset WANT and possibly add an ORDER BY clause if you're not satisfied.
Thank you! This is what I m looking for. Really appreciate it.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.