DATA Step, Macro, Functions and more

How to input data in a summary table format

Reply
New User
Posts: 1

How to input data in a summary table format

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:

 

Capture.JPG

 

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 

Super User
Posts: 23,980

Re: How to input data in a summary table format

Posted in reply to Sherryfu0315

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.

Ask a Question
Discussion stats
  • 1 reply
  • 99 views
  • 0 likes
  • 2 in conversation