How to import this text file

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

How to import this text file

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!


Accepted Solutions
Solution
‎11-16-2012 07:51 PM
Respected Advisor
Posts: 4,920

Re: How to import this text file

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

PG

View solution in original post


All Replies
Super User
Posts: 19,789

Re: How to import this text file

Here's how to read it from the web.

But my syntax doesn't work either and I don't want to debug Smiley Sad

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;

Solution
‎11-16-2012 07:51 PM
Respected Advisor
Posts: 4,920

Re: How to import this text file

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

PG
New Contributor
Posts: 4

Re: How to import this text file

Thanks!

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 254 views
  • 3 likes
  • 3 in conversation