topic Combining tables horizontally ,vertically using Proc SQL in ODS and Base Reporting

Combining tables horizontally ,vertically using Proc SQL

deleted_user — Mon, 10 Sep 2007 14:25:15 GMT

Hi

How can we combine two data sets horizontally, vertically using Proc sql.

Please suggest in this regard.

regards
rupa

Re: Combining tables horizontally ,vertically using Proc SQL

Scooby_Drew — Tue, 18 Sep 2007 16:41:01 GMT

Are you trying to create a pivot table as in Excel? If so, use SQL to summarise your data then you would need to use Proc Transpose to create the pivot.

proc sql;
create table summary_data as
select count(outcome) as YTD_count, outcome, issue
from raw_data
group by outcome, issue
order by issue, outcome;
quit;

/*Turn the summary into a pivot table summary */

proc transpose data= summary_data out= pivot_data prefix=YTD_;
by issue ;
id outcome;
var YTD_count;
run;

Re: Combining tables horizontally ,vertically using Proc SQL

Bill — Tue, 18 Sep 2007 18:51:02 GMT

Horizontally:

proc sql;
create table horizontal as
select a.*,b.*
from one a, two b
where a.key=b.key

Vertically;

proc sql;
create table vertical as
select *
from one
outer union corr
select *
from two;