Hi,
I am having difficulty properly importing this file into SAS. http://www.dougstats.com/12-13RD.txt
I would like to be able to write a code that imports it directly from the web. Let me know if you can help!
Thanks!
Use URL Access method (and change variable 3m and 3a to v3m and v3a) :
filename ex URL "http://www.dougstats.com/12-13RD.txt";
data test;
infile ex firstobs=2;
length player $16;
input Player $ Team $ PS $ GP Min FGM FGA V3M V3A FTM FTA OR TR AS ST TO BK PF DQ PTS TC EJ FF Sta;
run;
PG
Here's how to read it from the web.
But my syntax doesn't work either and I don't want to debug
I'm sure someone else will help though...
filename foo url
'http://www.dougstats.com/12-13RD.txt';
data test;
infile foo length=len firstobs=2;
input Player $8. Team $3. PS $2. GP Min FGM FGA 3M 3A FTM FTA OR TR AS ST TO BK PF DQ PTS TC EJ FF ;
run;
Use URL Access method (and change variable 3m and 3a to v3m and v3a) :
filename ex URL "http://www.dougstats.com/12-13RD.txt";
data test;
infile ex firstobs=2;
length player $16;
input Player $ Team $ PS $ GP Min FGM FGA V3M V3A FTM FTA OR TR AS ST TO BK PF DQ PTS TC EJ FF Sta;
run;
PG
Thanks!
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.