Help using Base SAS procedures

proc transpose

Reply
N/A
Posts: 0

proc transpose

I have three variables (group, year, rate):
group year rate
corp 2009 1
corp 2010 2
csbu 2009 3
csbu 2010 2
ecs 2009 1
ecs 2010 4

How do I convert the above data to this:
group 2009 2010
corp 1 2
csbu 3 2
ecs 1 4
Super Contributor
Super Contributor
Posts: 3,174

Re: proc transpose

Yes, PROC TRANSPOSE is the ticket! And it's well documented both in online HELP and at the SAS support http://support.sas.com/ website, if you would consider these sources for gaining knowledge from an uber reference source.

Scott Barry
SBBWorks, Inc.


Google advanced search argument, this topic/post:

proc transpose site:sas.com
Ask a Question
Discussion stats
  • 1 reply
  • 95 views
  • 0 likes
  • 2 in conversation