topic Re: Transposing in SAS Procedures

Transposing

brophymj — Tue, 03 Mar 2015 16:43:34 GMT

I am trying to achieve the following transpose?

Any ideas how this can be done?

Reeza — Tue, 03 Mar 2015 16:49:58 GMT

PaigeMiller — Tue, 03 Mar 2015 16:55:09 GMT

Where does the result of 374 come from? That can't be obtained by transposing.

Tom — Tue, 03 Mar 2015 17:10:11 GMT

Looks more like a report than a transpose.

proc freq ;

weight exposure;

tables yr*level ;

run;

art297 — Tue, 03 Mar 2015 17:19:47 GMT

Or, if you need the transposed dataset, just add an OUT option to Tom's suggested code and transpose the output file. e.g.:

proc freq data=have;

weight exposure;

tables year*level/out=need;

run;

proc transpose data=need out=want (drop=_:);

by year;

id level;

var count;

run;

Jim_G — Tue, 03 Mar 2015 17:39:19 GMT

I offer this, but as Paige stated don’t see where 374 come from in your new dataset.

Proc sort; by year level;

Data new; set; by year level;

If level=:’Cons’ then cons=exposure;

If level=:’Manu’ then manu=exposure;

If level=:;Distri’ the distr=exposure;

If level=:’Ware’ then ware=exposure;

Label cons= ‘Construction’ manu=’Manufacturing’

distr=”Distribution’ ware=’Warehouse;

if last.year the output; drop level exposure;

run;

proc print ; run;