topic Re: Import CSV from the Web in SAS Procedures

Import CSV from the Web

ets_kps — Fri, 17 Apr 2015 17:32:48 GMT

Ok folks my turn to ask for help....

And I want to do it in as few calls as possible. Either a PROC IMPORT or a FILENAME.

Any guidance you can provide is appreciated.

Going one step further, what if it was an .xls?

Thanks in advance-K

ballardw — Fri, 17 Apr 2015 19:31:22 GMT

proc import file=testurl out=work.junk dbms=csv;run;

would be the approach but it times out on me.

Tom — Sat, 18 Apr 2015 02:05:37 GMT

Seems pretty easy. Binary format like an Excel file would be harder, you might want to first copy it to a temporary file.

data want;

infile testurl dsd firstobs=2;

input label pixel0-pixel783 ;

run;

Patrick — Sat, 18 Apr 2015 02:10:25 GMT

Your code works perfectly for me with SAS9.4 under Win7 64bit

Ksharp — Sat, 18 Apr 2015 08:07:29 GMT

It is easy to import Binary format like Excel file as well for SAS .Check it out .

Xia Keshan