topic Re: Trouble loading external csv file in SAS Studio demo in SAS Programming

Trouble loading external csv file in SAS Studio demo

poltroon — Wed, 04 Mar 2020 00:27:38 GMT

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.

Re: Trouble loading external csv file in SAS Studio demo

ChrisNZ — Fri, 06 Mar 2020 08:48:02 GMT

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

Re: Trouble loading external csv file in SAS Studio demo

ChrisNZ — Fri, 06 Mar 2020 08:49:18 GMT

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

Re: Trouble loading external csv file in SAS Studio demo

poltroon — Sat, 07 Mar 2020 02:07:57 GMT

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.

Re: Trouble loading external csv file in SAS Studio demo

ChrisNZ — Sun, 08 Mar 2020 05:20:00 GMT

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

Re: Trouble loading external csv file in SAS Studio demo

Tom — Mon, 09 Mar 2020 13:04:36 GMT

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

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