CODEWITHSUNDEEP
sas
Lucy
Lucy

Reputation: 177

insufficient authorization to access external CSV files in sas studio

Here is the code.

data test;
    infile '/folders/myfolders/smile.txt';
run;



ods csvall file='c:\test.cvs'; 
  proc print data=WORK.ONE;
     var Name Score Grade;
     by IdNumber;
  run; 
  ods csvall close;

The first data step runs well. The main issue is with the ods part. I got the insufficient authorization to access the csv file error in logs. Could anyone tell me why? Many thanks for your time and attention.

EDIT: So sorry for the mistake. For the second block of the code, that is actually this:

ods csvall file='/folders/myfolders/test.csv'; 
      proc print data=WORK.ONE;
         var Name Score Grade;
         by IdNumber;
      run; 
      ods csvall close;

Upvotes: 0

Views: 2951

Answers (1)

Chris J
Chris J

Reputation: 7769

To my knowledge, code you submit in SAS Studio is run on the server to which you're connected.

The first datastep reads from a (Unix) server path (forward slashes to delimit folders). The second block of code is trying to write out to a Windows drive (drive letter and backslash delimiters), but as the code is running on the Unix server, it knows nothing of your local (Windows) environment.

Upvotes: 1

Related Questions