Combining tables horizontally ,vertically using Proc SQL

[deleted_user]

Hi

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

Please suggest in this regard.

regards
rupa

[Scooby_Drew]

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;

[Bill]

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;