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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.