Hello my name is Terry Reid and I am enrolled in a beginner's level SAS class. I am using the current version of SAS Studio. I am having serious trouble downloading census data and putting it in a usable format in a table for SAS. It comes out looking like three rows instead of individual columns with the headings that I searched on. I have reviewed the SAS video Creating a SAS Table from CSV File multiple times. If you notice the file they show is already formatted in easy to recognize rows with multiple columns with the variables at the top. The printout that I downloaded from the census, which is attached to this request, has multiple variables and data in 3 rows without clearly separating the variables into individual columns with the data properly presented below it in rows associated with those variables. I need to learn the steps for properly downloading a file from the Census Bureau or how to make it usable once I get it, if this is the only format available. In addition, I need to learn how to code for several counties from different states, where each county will be presented independently or collectively in a report. An example of the variables are Earnings Range Low, Earnings Range High, Estimated Population, Date, County, State, Gender, Worked Full-Time and Worked Full Time for 12 Months. Most of these variables are in the report mentioned above, but not in an easily usable format. Thank you for any help that you can provide.
... View more
