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
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.
Your code works perfectly for me with SAS9.4 under Win7 64bit
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;
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.