proc transpose question

[Mgarret]

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:

Year	FY11
Office	Office1
Safey	0.9
Well-Being	0.67
Admin Support	0.78
staff training	0.99

I have been having a little trouble.

proc transpose data=have;

by

var

id

run;

Every combo I try  does not seem to work.

Any help is greatly appreciated.

Thanks

[shivas]

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;