proc transpose question

Mgarret — Tue, 21 Feb 2012 07:35:30 GMT

Hi all--

I have a proc transpose question. I would like to go from this:

Year	Office	Safey	Well-Being	Admin Support	staff trai
FY11	Office1	.90	.67	.78	.99

To this:

I have been having a little trouble.

proc transpose data=have;

var

run;

Every combo I try does not seem to work.

Any help is greatly appreciated.

Thanks

shivas — Tue, 21 Feb 2012 08:12:48 GMT

Hi,

Try this...

data have;

input Year $ Office $ Safey WellBeing AdminSupport stafftrai;

cards;

FY11 Office1 .90 .67 .78 .99

;

run;

proc transpose data=have out=want;

var year office Safey WellBeing AdminSupport stafftrai;

run;

topic proc transpose question in SAS Procedures