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? Product name: SAS® Studio Release: 5.1 SAS® Viya® release: V.03.04 Build date: September 16, 2019 04:35:31 AM 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.
... View more
