topic After assigning a library, SAS EG is not listing the SAS datasets in SAS Programming

After assigning a library, SAS EG is not listing the SAS datasets

Abhijit — Thu, 28 May 2015 11:06:10 GMT

Hi All

I have never encoutered a problem like this.

I have 2 sas dataset under /saswork0.

I assign a library with the help of below statement:

libname AA "/saswork0";

After running the above statement, I refresh the libraries under Server List. Under AA library, I was expecting EG to list out all the SAS datasets but that's not the case.

Anyone has encoutered a problem like this. Any help would be greatly appreciated.

Thanks

Abhi

Re: After assigning a library, SAS EG is not listing the SAS datasets

Kurt_Bremser — Thu, 28 May 2015 11:14:57 GMT

From where do you know that you have 2 datasets in /saswork0?

And what did the log say after you ran the libname statement?

Re: After assigning a library, SAS EG is not listing the SAS datasets

Abhijit — Thu, 28 May 2015 11:17:48 GMT

Please find the log details:

16 libname AA "/saswork0";

NOTE: Libref AA was successfully assigned as follows:

Engine: V9

Physical Name: /saswork0

Re: After assigning a library, SAS EG is not listing the SAS datasets

Kurt_Bremser — Thu, 28 May 2015 11:23:40 GMT

And how do you know there should be 2 datasets in that library?

Re: After assigning a library, SAS EG is not listing the SAS datasets

Abhijit — Thu, 28 May 2015 11:28:32 GMT

Becasue I have copied from comand line in Unix. The datasets existed in an area where I did not have access. What it did was, I used sudo command (this gave me root's rights) & then copied accross the data to /saswork0. After copying it, I did chmod 666 on the file.

Re: After assigning a library, SAS EG is not listing the SAS datasets

Kurt_Bremser — Thu, 28 May 2015 11:36:55 GMT

I know this may sound silly, but are you sure you did this on the same machine/system that runs your workspace server?

Next step would be to somehow get a listing of the directory.

This could either be done with the "files" section of your server list in EG, if you can navigate down to the root.

Or by running the ls command (with filename pipe, to catch the output), if you're not hindered by the NOXCMD option.

Or by using the method to list items in a directory described here:

SAS Filesystem Toolbox - sasCommunity

Re: After assigning a library, SAS EG is not listing the SAS datasets

Kurt_Bremser — Thu, 28 May 2015 11:38:06 GMT

Another silly question: what are the filenames of the datasets?

Re: After assigning a library, SAS EG is not listing the SAS datasets

Abhijit — Thu, 28 May 2015 11:50:12 GMT

u46018513@cenitws1 > pwd

/saswork0

u46018513@cenitws1 > ls -l

total 2062

-rwxrwxrwx 1 censas dpcenit 925696 May 27 10:58 config_table.sas7bdat

Re: After assigning a library, SAS EG is not listing the SAS datasets

Kurt_Bremser — Thu, 28 May 2015 12:14:59 GMT

You said you used sudo to become root and did a chmod 666 on the file. This file has mode 777 (executable bits set), and neither belongs to root nor the user currently logged in (u46018513). So something does not compute, to borrow the famous line.

Is cenitws1 actually the system running your workspace server?

Re: After assigning a library, SAS EG is not listing the SAS datasets

Ksharp — Thu, 28 May 2015 12:44:48 GMT

Maybe the role copying file is different the role starting SAS process .

One is ROOT , another is SAS ?

Xia Keshan

Re: After assigning a library, SAS EG is not listing the SAS datasets

Abhijit — Thu, 28 May 2015 12:47:22 GMT

Sorry, later on I did 777 as well. I am completely thrown by this stuff.