I am using 10 years CDC population data to run an analysis by state and year. Within the analysis, I am going to use race and ethnicity data. The issue I am having is figuring out how to use proc transpose to make each race and ethnicity its own column while keeping the accurate population data per state and year.

The data currently look like this:

State   Year Race Eth Pop
Alabama 2010 White NH xxxx
Alabama 2010 Black NH xxxx
Alabama 2010 Asian NH xxxx
Alabama 2010 AI/AN H  xxxx

I would like the data to look like this:

State    Year White/NH Black/NH Asian/NH AI/AN/H
Alabama  2010  xxxx      xxxx    xxxx     xxxx

Can I do that with proc transpose? I apologize in advance if there is a better way to format the way I want the data to look I am not adept at question writing on here.

Thank you!!