BookmarkSubscribeRSS Feed
poltroon
Calcite | Level 5

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.

 

5 REPLIES 5
ChrisNZ
Tourmaline | Level 20

I can run your code on the free AWS SAS UE.

kk.png

 

 

ChrisNZ
Tourmaline | Level 20

Are you failing to run this on your PC running a VM in virtualbox?

poltroon
Calcite | Level 5

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.

ChrisNZ
Tourmaline | Level 20

Oh. On sas.com? I don't know about this. At what address?

 

Tom
Super User Tom
Super User

So are you running VIYA instead of "regular" SAS?

That probably has some changes in how you deal with files.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

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!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 834 views
  • 0 likes
  • 3 in conversation