topic How to import this text file in SAS Programming

How to import this text file

yn623 — Sat, 17 Nov 2012 00:08:04 GMT

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!

Re: How to import this text file

Reeza — Sat, 17 Nov 2012 00:46:53 GMT

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;

Re: How to import this text file

PGStats — Sat, 17 Nov 2012 00:51:05 GMT

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;

Re: How to import this text file

yn623 — Sun, 18 Nov 2012 16:06:20 GMT

Thanks!