topic SOLVED: Usage Note 4440: Error: User does not have appropriate authorization level for library WORK in SAS Programming

Usage Note 4440: Error: User does not have appropriate authorization level for library WORK

System — Thu, 28 May 2015 13:41:27 GMT

I am a student and I have just installed SAS on my computer. I have been getting errors when I try to open a SAS file. I have found an error note which seems related to my problem:

Usage Note 4440: Error: User does not have appropriate authorization level for library WORK

The following error message may occur when running SAS with the wrong

umask setting for the user's WORK directory:

ERROR: User does not have appropriate authorization level for library

WORK.

FATAL: Unable to initialize the options subsystem.

(SASXKINI): PHASE 3 KERNEL INITIALIZATION FAILED.

UNABLE TO INITIALIZE THE SAS KERNEL

This error occurs because the umask settings for ROOT and the user do

not match. By default, ROOT has a umask setting of 022 for all

directories. If a user does not have at least group write authority they

will not be able to write output to the WORK directories.

To circumvent this problem, make sure that the userid also has a umask

of 022 or another setting that includes write authority for the group

However, I do not understand what I am supposed to do now. Can someone please give a step by step guide on fixing this problem?

Re: Usage Note 4440: Error: User does not have appropriate authorization level for library WORK

ballardw — Thu, 28 May 2015 14:55:56 GMT

Is this the University Edition? If so and you're running on a Windows platform the virtual machine settings may be the issue.

If that is not the exact error you are receiving then post exact error text and what you did to get the message. Which method were you using to open a file and what type of file? Program code, process, command line, point and click?

Re: Usage Note 4440: Error: User does not have appropriate authorization level for library WORK

System — Fri, 29 May 2015 02:06:46 GMT

I think I may be running the University edition as I did receive it from my university. I am not sure what virtual machine settings are. I am trying to open a .sas7bdat file. The message is

ERROR: User does not have appropriate authorization level for library WORK.

ERROR: Path: C:\Users\Kevin\AppData\Local\Temp\SAS Temporary

ERROR: Files\_TD5484_KEVIN-PC_.

NOTE: Unable to initialize the options subsystem.

ERROR: (SASXKINI): PHASE 3 KERNEL INITIALIZATION FAILED.

ERROR: Unable to initialize the SAS kernel.

Re: Usage Note 4440: Error: User does not have appropriate authorization level for library WORK

System — Fri, 29 May 2015 05:38:52 GMT

I think I am using the University Edition. I am not sure what the virtual machine settings are. I am trying to open a .sas7bdat file. The message I am getting is:

ERROR: User does not have appropriate authorization level for library WORK.

ERROR: Path: C:\Users\Kevin\AppData\Local\Temp\SAS Temporary

ERROR: Files\_TD5512_KEVIN-PC_.

NOTE: Unable to initialize the options subsystem.

ERROR: (SASXKINI): PHASE 3 KERNEL INITIALIZATION FAILED.

ERROR: Unable to initialize the SAS kernel.

Re: Usage Note 4440: Error: User does not have appropriate authorization level for library WORK

System — Sat, 30 May 2015 02:57:24 GMT

Also, I can open SAS Enterprise Guide fine, but the error occurs when I try to open SAS 9.4.

Re: Usage Note 4440: Error: User does not have appropriate authorization level for library WORK

Cynthia_sas — Sat, 30 May 2015 12:11:59 GMT

Hi:

If you have Enterprise Guide, it is unlikely that you are using the SAS University Edition. The University Edition is SAS, inside a Virtual Machine, the Virtual Machine is accessed thru either VMware Player or Oracle Virtual Box. So if you look on your Start Menu, do you have Start -->All Programs--> SAS --> SAS 9.4 and Start--> All Programs --> SAS --> SAS Enterprise Guide as choices on the Start menu? If so, you are NOT running SAS University Edition.

If you obtained SAS from your school, they could have given you a site to download from, they could have given you the DVD or they could have given you an install depot. If your school has a help desk or IT department who gave you install instructions, you might want to work with them or you might want to open a track with SAS Tech Support. Until you resolve the write access ERROR message you won't be able to use SAS. EG will probably work when you open it, but then fail when you try to submit any code because EG is only a "front end" that sends your code to SAS for execution.

cynthia

Re: Usage Note 4440: Error: User does not have appropriate authorization level for library WORK

System — Sun, 31 May 2015 01:58:27 GMT

Could someone give me a step by step instructions on what this means?:

This error occurs because the umask settings for ROOT and the user do

not match. By default, ROOT has a umask setting of 022 for all

directories. If a user does not have at least group write authority they

will not be able to write output to the WORK directories.

To circumvent this problem, make sure that the userid also has a umask

of 022 or another setting that includes write authority for the group

Re: Usage Note 4440: Error: User does not have appropriate authorization level for library WORK

SASKiwi — Sun, 31 May 2015 04:51:23 GMT

The usage note 4440 is only relevant to SAS running on Unix operating systems. The evidence you have provided suggests that you are running SAS on Windows where there is no such thing as a ROOT user or UMASK.

Are you just running SAS on your PC or if you are using EG does it connect to SAS on your PC or a remote SAS server?

Re: Usage Note 4440: Error: User does not have appropriate authorization level for library WORK

System — Sun, 31 May 2015 05:41:43 GMT

I am not entirely sure what you are saying. From what I can tell, SAS 9.4 and SAS Enterprise Guide are separate programs on my computer. I also other SAS programs such as SAS Deployment Manager, IML Studio etc. in the SAS folder.

Re: Usage Note 4440: Error: User does not have appropriate authorization level for library WORK

jakarman — Sun, 31 May 2015 05:48:18 GMT

The message 4440 on Unix is an indication that something was done wrong at the installation. That note is a terrible wrong description on what is going on, it is in error.

The root-cause is a wrong defined sas-work directory. As that one is defined in the SAS config-file that one must be taken into consideration.

The requirement is that anybody should be able to create (write delete anything) in that location is the temporary area /tmp or %tmp% some oldies will recognize.

Unix:
The /tmp is the default shared directory anybody can use on A Unix system, only for small temporary data. For SAS it is far too small. Another or multiple like this have to be defnied. This is going into technical details often being the problematic one to accomplish as SAS is that diificult not being an notepad application.

It can be any acceptable name for Unix-admins like /var/local/sas/tmp at that point the filesystem is set with spave and autorisation. The best chmod setting is 3777 (four digits!) as that is having /tmp also. The owner can be root (or "sassrv") the group eg "sas" or sas at a higer level so the "others" can have a different meaning.

That 3 is indicating:

a/ sgid That has the meaning of the group as set a the directory will be inherited by subdirectories not the primary group.
b/ sticky-bit That has the meaning (only at directories) of deleting is only possible by the owner of the file or by the owner of the directory
The last 7 (others rwx) is only allowed in combination with that first "3".

That umask is a setting new files/dirs will get by a running process. That note 4440 is humbug.

Windows:
That %tmp% was well known in the era of DOS 2.1 for a shared but single user system. It cannot be used in a multiuser system having the issues of unwanted shared temporary data. So they moved it to"%temp%". You can type that %temp% in your (win)explorer as you can type %appdata%".

1- Please type %temp% and note what you see. That should be "C:\Users\Kevin\AppData\Local\Temp\" Your ID you used with Windows should be "Kevin". When not than you have your issue.
2.1- Using EGuide with the local connection you are using SAS on you desktop. It is the continuation of 1/
2.2- Using Eguide with a server profile than there is a Windows Server somewhere. That one should know you too. (that is another challenge).

You did try to open the sas7bdat file? Please do not work that way. It is trusting the file-association to start some program on you desktop that will open the file.
In this case Eguide cannot be associated to open the file it is SAS-Base. At least you got a correct message SAS-Base on your desktop has started but is installed wrong.
This could happen when Kevin did give you a modified sas-config with his local/temp hard coded. It will work for Kevin not for you.

Re: Usage Note 4440: Error: User does not have appropriate authorization level for library WORK

System — Mon, 01 Jun 2015 00:13:44 GMT

I have typed in %temp% and I have gotten "C:\Users\Kevin\AppData\Local\Temp". I am not sure what you mean by instructions 2.1 and 2.2. I am Kevin and I have not installed SAS on any other computer. I received a license file from my university.

Re: Usage Note 4440: Error: User does not have appropriate authorization level for library WORK

jakarman — Mon, 01 Jun 2015 05:33:39 GMT

The difference between 2.1 and 2.2 is whether you would have:

2.1 SAS-base on the Desk-top with Eguide . We can accept now this is your situation

2.2 SAS-base running on a server with Eguide

What is strange is that your are getting an error with 2 lines for 1 single location

you could try to find the config.sas in the SASHOME below then `progam files (x86)'' And verfiy that SASWORK setting.
It makes no sense that setting has got broken up. "C:\Users\Kevin\AppData\Local\Temp". The rest of "SAS Temporary Files\" (it is one string) is in that config-file.

ERROR: Path: C:\Users\Kevin\AppData\Local\Temp\SAS Temporary

ERROR: Files\_TD5484_KEVIN-PC_.

That number 5484 is a random number (_TD_process-id) followed by machine-id (KEVIN_PC shared work machines servers)

As you got the license-file you did the installation on your machine yourself,

What Windows Version? What SAS version?
Can you find SAS-base to start (should give that error)? and can you find that sas config line about sas-work? (what does it say?)

For the university edition SAS is redirecting first-line support to your university (I believe so).

Re: Usage Note 4440: Error: User does not have appropriate authorization level for library WORK

Kurt_Bremser — Mon, 01 Jun 2015 06:49:55 GMT

Since it's verified that you run your SAS on Windows, this note might be more helpful:

6653 - "Error: User does not have appropriate authorization for library WORK"error message appears at invocation

First, I would make sure that "C:\Users\Kevin\AppData\Local\Temp\SAS Temporary Files" actually exists, and that you can create a simple file there (to test the permissions). Just create a text file in notepad and try to save it in the "SAS Temporary Files" folder.

Re: Usage Note 4440: Error: User does not have appropriate authorization level for library WORK

System — Wed, 03 Jun 2015 01:51:00 GMT

I've actually solved the problem. For some reason, I did not have permission to access the folder even though I am the administrator of the computer.

Re: Usage Note 4440: Error: User does not have appropriate authorization level for library WORK

Kurt_Bremser — Wed, 03 Jun 2015 07:31:17 GMT

Welcome to the wonderful world of Windows, where sometimes even God (= the Administrator) is not almighty.

Re: Usage Note 4440: Error: User does not have appropriate authorization level for library WORK

jakarman — Wed, 03 Jun 2015 11:39:11 GMT

Of course you are not the admin. That is an impossible privilege escalation being closed by MS. When you connect with Eguide to a server the object spawner is the one that spawns the process not the kernel. The object spawner is running by a local server account when you did not change that. The local server account cannot escalate privileges to an admin account. Yes you can login with your key having those admin setting but it will not get those granted.

It is something the same with the setup bit at Unix. Only that bit is allowing to switch at root level.

Re: Usage Note 4440: Error: User does not have appropriate authorization level for library WORK

System — Sat, 06 Jun 2015 01:23:28 GMT

This is irrelevant to the topic, but I am getting an error "Not allowed to post content more than once every 120 seconds" when I try to post a new thread on this forum.

My new question for a thread is:

I am trying to conduct a proc sql which does a left join, but I get an ERROR: Sort execution failure. I have tried changing the value of sortsize, but that does not seem to work. Modifying the value of memsize is blanked out. I am changing it through Tools > Options > System > System Adminstration > Memory. I have put in options fullstimer msglevel=i ;

Some of my log is:

NOTE: SAS threaded sort was used.

ERROR: Sort execution failure.

40 quit;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SQL used (Total process time):

real time 46:15.10

user cpu time 6:09.48

system cpu time 1:10.21

memory 539212.23k

OS Memory 561896.00k

Timestamp 05/06/2015 11:44:34 PM

Step Count 7 Switch Count 0

and

22 quit;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SQL used (Total process time):

real time 42:58.80

user cpu time 6:03.10

system cpu time 1:09.32

memory 1247728.63k

OS Memory 1269916.00k

Timestamp 05/06/2015 10:38:24 PM

Step Count 4 Switch Count 0

Usually, it only takes about 25 minutes to get an error so the 40+ mins is a bit different. I don't think the errors are occurring due to a lack of disk space as I have over 25 GB of free space and the two files I am trying to join together are around 3GB and 30 MB respectively. Unless, there is a restriction on the amount of memory Temporary Files can take?

Re: Usage Note 4440: Error: User does not have appropriate authorization level for library WORK

SASKiwi — Sat, 06 Jun 2015 01:41:27 GMT

Please post your SQL code. One reason for your errors might be invalid SQL with "correct" syntax. Check your MEMSIZE setting using PROC OPTIONS. What value has it?

Re: Usage Note 4440: Error: User does not have appropriate authorization level for library WORK

System — Sat, 06 Jun 2015 01:49:56 GMT

proc sql;

create table event as

select a.*,b.size

from event a left join size b

on (a.date=b.date)

order by permno,rdq1,td_count;

quit;

memsize is 2147483648. I don't think I can modify this. sortsize is currently at 268435456, but I have changed it 50%, 75% and 100%. I still receive the error regardless.

Re: Usage Note 4440: Error: User does not have appropriate authorization level for library WORK

jakarman — Sat, 06 Jun 2015 05:34:07 GMT

Your execution time and data-sizing doe not match to normal behavior.

A common pitfall is the Cartesian product as it blows up the data. When this happens, there should be a warning-note of that.

There is something strange in you SQL that is your new dataset (work.event) and an input dataset (event a left join) are the same. This is logical not possible in a RDBMS approach. During the processing those should be segregated. With classic SAS that is solved by using an intermediate file. I have also seen warnings SAS is not happy with that anymore as of multithreading within their PRoc SQL.