Hi,
I am given a data set on how satisfaction depends on race, gender, age and regional location. However, the format of the txt. file is like below:
It looks like a formatted summary table. I am wondering how can I input these data into SAS? I would like to have five variables: satisfaction, gender, race, region and age.
Thanks a lot!
Best,
Sherry
It looks to be column delimited so you could read it in as column formatted, something like the following to get you started.
A data step is the best approach.
infile '../cda.txt' firstobs=7;
input @1 region $ @20 White_lt35_M @27 White_lt35_F .... etc;
And if it's a single data set that you need to read, and only once, there's no issue with copying it to Excel, reformatting and then exporting it back as a CSV and importing that. You run the risk of adding errors but it's easy to check with a small data set.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.