I've found some code that works great at importing a xlsx file from a URL. The code successfully creates a duplicate of the file onto my computer but when I try to import the file into SAS I get the following issue.
Could not find 'workbook' entry in xlsx file. rc=8014900E (-2146136050)
Requested Input File Is Invalid
ERROR: Import unsuccessful. See SAS Log for details.
If I open the file then save it SAS can import the file successfully. That isn't too big of an issue I would just prefer it be automated. I'm quite sure the file is an xlsx file as there is no prompt warning from excel when I open the file. I have also downloaded a third party program that recognized the file as an xlsx file.
Any suggestions?
filename cm1url HTTP "http://tti.tamu.edu/documents/ums/congestion-data/complete-data.xlsx";
data _null_;
n=-1;
infile cm1url recfm=s nbyte=n length=len;
input;
file "C:\temp\TestPROCtoNDC.xlsx" recfm=n;
put _infile_ $varying32767. len;
run;
proc import file='C:\temp\TestPROCtoNDC.xlsx' out=PCR_day
dbms=xlsx replace;
getnames=no;
run;
Maybe a stupid question, but what happens if you skip the copy part, and just try to import the file from where it is?
filename cm1url HTTP "http://tti.tamu.edu/documents/ums/congestion-data/complete-data.xlsx";
proc import file=cm1url out=PCR_day
dbms=xlsx replace;
getnames=no;
run;
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 how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.