https://communities.sas.com/t5/SAS-Procedures/turning-variable-records-into-new-variables/m-p/75517#M21916 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.<BR /> <BR /> Any suggestions? Tue, 13 Oct 2009 05:33:06 GMT deleted_user 2009-10-13T05:33:06Z https://communities.sas.com/t5/SAS-Procedures/turning-variable-records-into-new-variables/m-p/75517#M21916 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.<BR /> <BR /> Any suggestions? Tue, 13 Oct 2009 05:33:06 GMT https://communities.sas.com/t5/SAS-Procedures/turning-variable-records-into-new-variables/m-p/75517#M21916 deleted_user 2009-10-13T05:33:06Z https://communities.sas.com/t5/SAS-Procedures/turning-variable-records-into-new-variables/m-p/75518#M21917 PROC TRANSPOSE would be the obvious choice. See on line doc under Base SAS Procedures.<BR /> <BR /> /Linus Tue, 13 Oct 2009 06:58:58 GMT https://communities.sas.com/t5/SAS-Procedures/turning-variable-records-into-new-variables/m-p/75518#M21917 LinusH 2009-10-13T06:58:58Z