DATA Step, Macro, Functions and more

transpose in one step instead two

Reply
Super Contributor
Posts: 647

transpose in one step instead two

Can this be done in one transpose data step?
proc sql;
create table access_v1 as
select Sales_Group,Product,sum(Sales_CY_Mth) as sls_cy_mth, sum(_2010) as S_2010, sum(_2011) as s_2011
from acess.acess1
group by Sales_Group,Product,Customer_Segment;

quit;


PROC TRANSPOSE DATA=access_v1 OUT=access_v2(drop=_name_) suffix=_acess2010;
BY Sales_Group ;
ID Product ;
VAR S_2010;

run;



PROC TRANSPOSE DATA=access_v1 OUT=access_v3(drop=_name_) suffix=_acess2011;
BY Sales_Group ;
ID Product ;
VAR S_2011;

run;
PROC Star
Posts: 7,356

Re: transpose in one step instead two

Can you provide some sample data (in the form of a data step), as well as the final file you wish to achieve?

Art
Ask a Question
Discussion stats
  • 1 reply
  • 118 views
  • 0 likes
  • 2 in conversation