Import CSV from the Web

[ets_kps]

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

I want to know how to import this file from the web. https://raw.githubusercontent.com/sassoftware/enlighten-integration/master/SAS_Base_OpenSrcIntegrati...

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]

filename testurl url "https://raw.githubusercontent.com/sassoftware/enlighten-integration/master/SAS_Base_OpenSrcIntegrati...";

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

would be the approach but it times out on me.

[Patrick]

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

[Tom]

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

filename testurl url "https://raw.githubusercontent.com/sassoftware/enlighten-integration/master/SAS_Base_OpenSrcIntegrati...";

data want;

infile testurl dsd firstobs=2;

input label pixel0-pixel783 ;

run;

[Ksharp]

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

http://blogs.sas.com/content/sasdummy/2013/09/17/copy-file-macro/

Xia Keshan