02-21-2012 02:35 AM
I have a proc transpose question. I would like to go from this:
|Year||Office||Safey||Well-Being||Admin Support||staff trai|
I have been having a little trouble.
proc transpose data=have;
Every combo I try does not seem to work.
Any help is greatly appreciated.
02-21-2012 03:12 AM
input Year $ Office $ Safey WellBeing AdminSupport stafftrai;
FY11 Office1 .90 .67 .78 .99
proc transpose data=have out=want;
var year office Safey WellBeing AdminSupport stafftrai;