Hi all--
I have a proc transpose question. I would like to go from this:
FY11
Office1
To this:
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
Hi,
Try this...
data have;
input Year $ Office $ Safey WellBeing AdminSupport stafftrai;
cards;
FY11 Office1 .90 .67 .78 .99
;
proc transpose data=have out=want;
var year office Safey WellBeing AdminSupport stafftrai;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Register now!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for:
View all other training opportunities.