topic Re: How to input data in a summary table format in SAS Programming

How to input data in a summary table format

Sherryfu0315 — Fri, 09 Feb 2018 01:41:11 GMT

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

Re: How to input data in a summary table format

Reeza — Fri, 09 Feb 2018 02:50:49 GMT

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.