How to import this text file

[yn623]

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!

[Reeza]

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;

[PGStats · Accepted solution]

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

[yn623]

Thanks!