topic SAS Viya - proc export with replace gives ERROR: File denoted by URI was not found in SAS Programming

SAS Viya - proc export with replace gives ERROR: File denoted by URI was not found

alexandravieira — Tue, 03 Nov 2020 13:39:10 GMT

Hi, I'm doing a simple proc export:

FILENAME REFFILE FILESRVC FOLDERPATH="&exp_path" FILENAME='cars.csv';
proc export data=sashelp.cars outfile=REFFILE dbms=csv replace; run;
FILENAME REFFILE clear;

&exp_path exists.

First time I run it, it runs fine and the csv is created correctly. Second time I run it, I get the error: "ERROR: File denoted by URI '/files/files/c36d64c8-4d60-416c-833e-7633a138bf8e' was not found" and it corrupts the file cars.csv.

If I take out the replace option, it runs fine, it just says that it won't replace the file because I didn't specify the replace option.

What am I doing wrong? I'm on SAS Viya 3.5

Thanks in advance

Alex

Re: SAS Viya - proc export with replace gives ERROR: File denoted by URI was not found

BrunoMueller — Wed, 04 Nov 2020 10:10:11 GMT

I ran this code on SAS Viya 3.5, it works every time, in the log one can see, that there is always a new file uri shown.

filename reffile filesrvc folderpath="&exp_path" filename='cars.csv';

proc export
  data=sashelp.cars
  outfile=REFFILE
  dbms=csv
  replace
;
run;

What are your permissions on the folder you write the file too? You can view those using the applications menu -> Environment Manager -> Content and then use the RightMouseButton to view the Authorization on the folder in question.

Maybe it is best to contact Technical Support on this error.