Help using Base SAS procedures

proc transpose question

Reply
Frequent Contributor
Posts: 144

proc transpose question

Hi all--

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

YearOfficeSafey
Well-Being Admin Supportstaff trai

FY11

Office1

.90.67.78.99

To this:

          



YearFY11
OfficeOffice1
Safey0.9
Well-Being 0.67
Admin Support0.78
staff training0.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

Super Contributor
Posts: 349

proc transpose question

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;

Ask a Question
Discussion stats
  • 1 reply
  • 117 views
  • 0 likes
  • 2 in conversation