topic Re: Combine tables vertically taking only common variables in simple steps in SAS Programming

Combine tables vertically taking only common variables in simple steps

psychopedia — Fri, 03 Jun 2016 20:20:27 GMT

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!

Re: Combine tables vertically taking only common variables in simple steps

FreelanceReinh — Fri, 03 Jun 2016 21:17:34 GMT

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.

Re: Combine tables vertically taking only common variables in simple steps

psychopedia — Fri, 03 Jun 2016 22:09:44 GMT

Thank you! This is what I m looking for. Really appreciate it.