Hi All,
I know nothing of programming and working with data like this. The US Census Bureau website has .xlsx tables that relate family income to voter turnout and reasons for not voting, using CPS data from Nov 2018, and I guess preceding months, plus their Voting and Registration Supplement. There are what looks like .dat purely numerical fixed width documents of this data on the Census website, and I guess there may be various renditions of the same info on cps.ipums.org. How may this information be viewed in a similar format to the .xlsx tables for a single state? Is this practical on SAS Studio? Thank You 🙂
The US Census website has many files on the same topics.
It really helps to give us a specific link to the files you are interested in as the search function on that site is marginal at best.
Often when the Census site has text, such as fixed column, data there will usually be one or more programs or documents on how to bring such data into some statistics packages such as SAS or SPSS and sometimes even example analysis programs.
Unfortunately without a specific example it is hard to provide much other than 1) read the data into SAS and 2) select the records of interest. You could likely write an XLSX file of the data you want.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.