In chapter 2.10 of Little SAS Book. There is an example data file named canoes as follows:
Bellatorum School: CSULA Time: 1:40.5
The Kraken School: ASU Time: 1:45.35
Black Widow School: UoA Time: 1:33.7
Koicrete School: CSUF Time: 1:40.25
Khaos School: UNLV Time: 2:03.45
Max School: UCSD Time: 1:26.47
Hakuna Matata School: UCLA Time: 1:20.64
Prospector School: CPSLO Time: 1:12.08
Andromeda School: CPP Time: 1:25.1
Kekoapohaku School: UHM Time: 1:24.49
The book shows how to read "School" and "Time" use colon modifier, but does not show how to read the entire data file, which should include the first variable: Canoe team's names. I tried it but with no success. I'm having trobule reading the "Hakuna Matata" part. It has a space in between and the delimiter of the data file is space. Can anyone show me how to read the above data file into SAS? Thanks!
I don't know what edition you are using, but the fifth edition includes the following code, which appears to read the RaceTime variable:
DATA canoeresults;
INFILE 'c:\MyRawData\Canoes.dat';
INPUT @'School:' School $ @'Time:' RaceTime :STIMER8.;
RUN;
The RaceTime variable will be read in terms of seconds. For example, the first observation has a RaceTime of 100.5 seconds.
Yes. But it does not show how to read the first variable: Canoe team's name. Thanks!
Add before the input:
Informat teamname $20. ;
modify input
input teamname & <the other variables>
This assumes that the important but not mentioned two spaces after the team names is consitent.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.