transpose in one step instead two

SASPhile — Mon, 23 May 2011 18:09:33 GMT

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;

Re: transpose in one step instead two

art297 — Mon, 23 May 2011 21:20:07 GMT

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

Art

topic Re: transpose in one step instead two in SAS Programming

transpose in one step instead two

Re: transpose in one step instead two