topic Re: Reading part of raw data in SAS Studio

Reading part of raw data

marianhabesland — Wed, 27 Sep 2017 00:09:12 GMT

The raw data displayed below contains values for the following variables:

League (Character)
Team (Character)
Wins (Numeric)
Losses (Numeric)

Write a DATA step that reads in the value for League, tests it, keeps only observations with a value of ‘American’, and produces an output data set containing all 4 variables.

This is my code so far:

data WORK.Illus;
infiles datalines delimiter = ' ';
input League $8. @;
if League = 'American';
input Team $18.
Wins 2
Losses 2;
datalines;
National New York Mets 19 12
American Toronto Blue Jays 19 13
American Boston Red Sox 17 12
National St Louis Cardinals 13 11

;

This is all I get in my table. What can I do to actually get the data I need in the table?

Re: Reading part of raw data

WarrenKuhfeld — Wed, 27 Sep 2017 00:32:30 GMT

Remove both 2's. You do not want to read from column 2.
Wins 2
Losses 2;

Re: Reading part of raw data

Tom — Wed, 27 Sep 2017 01:25:40 GMT

Post code and especially the data using the Insert Code or Insert SAS code buttons in the editor.

Otherwise important information, like which columns the data is in, whether there is anything to make the end of the team name, etc. will be lost because the forum will format your post into paragraphs.