Help using Base SAS procedures

turning variable records into new variables

Reply
N/A
Posts: 0

turning variable records into new variables

I have a table with variables for state, year, and and a single variable for the tax rate in that state. I would like to reorganize the data so that the state variable is removed, and instead there is a variable for the year, and 50 new variables, one for each state. Every record under the states would show the tax rate for that combination of state and year. However, I am fairly new to SAS and don't have a good idea as to if/how this should be done.

Any suggestions?
Super User
Posts: 5,323

Re: turning variable records into new variables

PROC TRANSPOSE would be the obvious choice. See on line doc under Base SAS Procedures.

/Linus
Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 97 views
  • 0 likes
  • 2 in conversation