topic Re: How to solve ERROR:Insufficient authorization to access /sas/config/Lev1/SASApp/c:\temp\20200416 in SAS Programming

How to solve ERROR:Insufficient authorization to access /sas/SASApp/c:\temp\200416.txt

annypanny — Thu, 16 Apr 2020 09:55:02 GMT

Hi community,

I am using this code to

find out today's file and read that file into a dataset:

data _null_;
length dsnname $100;
today=put(today(),yymmdd7.);
dsnname = compress('c:\temp\'||today||'.txt');
file phold filevar=dsnname notitles;
put today;
run;

but getting this error: Insufficient authorization to access /sas/config/Lev1/SASApp/c:\temp\200416.txt

how to solve this I also want to add

'/folders/myfolders/sales.pdf'

but don't know where to add this.

my file format is OnlineUser20200416 but in the error it is showing 200416, please correct the date time format in this code too. I am using windows(EG sas)

Thanks in advance

Edited

Re: How to solve ERROR:Insufficient authorization to access /sas/config/Lev1/SASApp/c:\temp\20200416

yabwon — Thu, 16 Apr 2020 08:28:52 GMT

Hi,

From your error it look that you try to write a Windows machine file "c:\temp\20200416.txt" from the linux/UNIX machine (/sas/config/Lev1/SASApp/).
I'm guessing that your filename statement is:
`filename PHOLD "c:\temp\20200416.txt";` ?
You have to create file on the Linux/UNIX machine first (e.g. in your home folder `filename PHOLD "~/20200416.txt";`). and then copy it to WIndows.

All the best
Bart

Re: How to solve ERROR:Insufficient authorization to access /sas/config/Lev1/SASApp/c:\temp\20200416

annypanny — Thu, 16 Apr 2020 08:43:25 GMT

could you please give the soluion that what change I have to do in my code and where, as I am a bit confuse here

Re: How to solve ERROR:Insufficient authorization to access /sas/config/Lev1/SASApp/c:\temp\20200416

yabwon — Thu, 16 Apr 2020 08:51:32 GMT

Ok, so step by step:

1) Just to clarify, you are working on Linux/UNIX server, right?

2) you have a data set on your windows PC in folder: "c:\temp\" and the filename is "OnlineUser20200416.txt"

3) you want to read the file into a SAS dataset (if yes, what is the file structure)?

Bart

Re: How to solve ERROR:Insufficient authorization to access /sas/config/Lev1/SASApp/c:\temp\20200416

Kurt_Bremser — Thu, 16 Apr 2020 09:33:34 GMT

Since this is a continuation from https://communities.sas.com/t5/SAS-Programming/How-to-extract-an-external-file-into-a-sas-dataset-in-EG-windows/m-p/640331, I quote my answers from there:

You must always keep in mind that you work in a client/server environment. Code you run on the server (via SAS Studio or Enterprise Guide) has to use path names available on the server, and the syntax of the server's operating system.

Since your SAS server is obviously a UNIX system, you need to use the UNIX File System language. And point your file references to locations where you have the required permissions.

and

I cannot look into your server (if I could, I would either have the police knocking soon, or your IT people would all be fired), so you need to know where to put data in your system environment. Get help from your server administrators, they can tell you where to put data on the server (a good bet is always $HOME), and how to move the data from there to its final intended location.

Re: How to solve ERROR:Insufficient authorization to access /sas/config/Lev1/SASApp/c:\temp\20200416

annypanny — Thu, 16 Apr 2020 10:07:43 GMT

1. i am working on windows system.
3.yes

Re: How to solve ERROR:Insufficient authorization to access /sas/config/Lev1/SASApp/c:\temp\20200416

annypanny — Thu, 16 Apr 2020 10:11:50 GMT

I have successfully run the above code now how can I read the dataset?
using infile?

Re: How to solve ERROR:Insufficient authorization to access /sas/config/Lev1/SASApp/c:\temp\20200416

Kurt_Bremser — Thu, 16 Apr 2020 10:32:00 GMT

@annypanny wrote:
1. i am working on windows system.
3.yes

If you can show me a path like

/sas/config/Lev1/SASApp/

on any Windows system in production use, I will happily eat that broomstick over there (in German: "dann fress' ich einen Besen").

Your Enterprise Guide (or the browser with which you access SAS Studio) runs on Windows, but your SAS runs on a UNIX system.

Re: How to solve ERROR:Insufficient authorization to access /sas/config/Lev1/SASApp/c:\temp\20200416

Kurt_Bremser — Thu, 16 Apr 2020 10:38:19 GMT

PS this path

/sas/config/Lev1/SASApp/

is almost exactly the path to the default SASApp server context on our AIX server.

Re: How to solve ERROR:Insufficient authorization to access /sas/config/Lev1/SASApp/c:\temp\20200416

yabwon — Thu, 16 Apr 2020 11:30:30 GMT

Hi,

I'm confused by your answers.

I see two options: either you elaborate about your issue in clearer way, or I won't be able to help you.

Bart