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!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.