Hi,
I have a PROC SQL statement which appends 2 tables together, however, I need all the variables captured to show horizontally, any idea how to do this please?
Example (as you can see, I have all 8 variables listed from Current and Previous Tables)
Curr_email curr_first_name curr_user curr_network Prev_email Prev_first_name Prev_user Prev_network
proc sql; create table work.cancelled_Combined AS
select E_mail AS Curr_email, First_Name as curr_first_name, User_ID as curr_user, Network as curr_network from work.cancelled_this_month
UNION ALL
select E_mail AS Prev_email, First_Name as Prev_first_name, User_ID as Prev_user, Network as Prev_network from work.cancelled_previous_month;
quit;
... View more