I am attempting to load some sample data from the CDC to try out some graphing types. I am starting from a file that is valid SAS code that ran on the Academic version in AWS marketplace.
filename _cause URL 'https://data.cdc.gov/api/views/bi63-dtpu/rows.csv?accessType=DOWNLOAD';
proc import datafile=_cause replace dbms=csv out=work.cause_of_death;
datarow=2;
run;
quit;
It fails with
NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to WORK.PARMS.PARMS.SLIST. ERROR: Physical file does not exist, https://data.cdc.gov/api/views/bi63-dtpu/rows.csv?accessType=DOWNLOAD. ERROR: Import unsuccessful. See SAS Log for details. NOTE: The SAS System stopped processing this step because of errors.
I also tried changing the url to
https://data.cdc.gov/api/views/bi63-dtpu/rows.csv
Does the demo simply not support a url load?
I was able to upload the CSV file and tried
"/Users/email@example.com/My Folder/NCHS_-_Leading_Causes_of_Death__United_States.csv"
proc import
datafile="/Users/email@example.com/My Folder/NCHS_-_Leading_Causes_of_Death__United_States.csv"
replace dbms=csv out=work.cause_of_death;
datarow=2;
run;
quit;
which returns
NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to WORK.PARMS.PARMS.SLIST. ERROR: Physical file does not exist, /Users/email@example.com/My Folder/NCHS_-_Leading_Causes_of_Death__United_States.csv.
This seems a simple question, so my apologies.
Are you failing to run this on your PC running a VM in virtualbox?
No, this is the SAS demo that runs through the browser hosted at sas.com. I'm using chrome on a mac to run it.
Oh. On sas.com? I don't know about this. At what address?
So are you running VIYA instead of "regular" SAS?
That probably has some changes in how you deal with files.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.