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.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.