BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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?
1 REPLY 1
LinusH
Tourmaline | Level 20
PROC TRANSPOSE would be the obvious choice. See on line doc under Base SAS Procedures.

/Linus
Data never sleeps

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

What is Bayesian Analysis?

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1070 views
  • 0 likes
  • 2 in conversation