topic Re: Libname related opening folder with SAS result in SAS Programming

Libname related opening folder with SAS result

wlierman — Tue, 22 Oct 2024 21:32:18 GMT

I have a likely simple question. I have the following Libname statements

Libname  ANALYZE 'M:\DATA\OR0206965\DRTS__4.2024_forward';
Libname  ANALYZE2 'M:\DATA\OR0206965\DRTS__5.2024_forward';
Libname  ANALYZE3 'M:\DATA\OR0206965\DRTS__7.2024_forward';
Libname  ANALYZE4 'M:\DATA\OR0206965\DRTS__Telehealth';

with following log

  Libname  ANALYZE 'M:\DATA\OR0206965\DRTS__4.2024_forward';
NOTE: Libref ANALYZE was successfully assigned as follows:
      Engine:        V9
      Physical Name: M:\DATA\OR0206965\DRTS__4.2024_forward
191  Libname  ANALYZE2 'M:\DATA\OR0206965\DRTS__5.2024_forward';
NOTE: Libref ANALYZE2 was successfully assigned as follows:
      Engine:        V9
      Physical Name: M:\DATA\OR0206965\DRTS__5.2024_forward
192  Libname  ANALYZE3 'M:\DATA\OR0206965\DRTS__7.2024_forward';
NOTE: Libref ANALYZE3 was successfully assigned as follows:
      Engine:        V9
      Physical Name: M:\DATA\OR0206965\DRTS__7.2024_forward
193  Libname  ANALYZE4 'M:\DATA\OR0206965\DRTS__Telehealth';
NOTE: Libref ANALYZE4 was successfully assigned as follows:
      Engine:        V9
      Physical Name: M:\DATA\OR0206965\DRTS__Telehealth

The result of a proc sql query gives

NOTE: Compressing data set ANALYZE4.URBAN_RURAL decreased size by 13.04 percent.
      Compressed is 46271 pages; un-compressed would require 53208 pages.
NOTE: Table ANALYZE4.URBAN_RURAL created, with 36233957 rows and 12 columns.

I go to the explorer pane to open up the folder DRTS_Telehealth. But the folder does not open.

I've rebooted the SAS session. But to no avail.

I am obviously overlooking something here and would appreciate help from the SAS expert community.

Thank you.

wlierman

Re: Libname related opening folder with SAS result

ChrisHemedinger — Tue, 22 Oct 2024 22:06:44 GMT

Silly question, but you mean "DRTS__Telehealth" with 2 underscores, right? Not "DRTS_Telehealth" as you have in your message?

Re: Libname related opening folder with SAS result

wlierman — Tue, 22 Oct 2024 22:13:50 GMT

Yes. Sorry, two underscores.

Re: Libname related opening folder with SAS result

ballardw — Tue, 22 Oct 2024 22:43:52 GMT

How long did you wait?

Recent our IT has been adding some security and "data management" tools that impact performance of SAS quite notably. If I use the SAS Explorer and navigate to a library that I have not opened very recently SAS pauses as it accesses all the information of the library and for a library with many data sets I sometimes have to wait more than 10 minutes. If your library has multiple data datasets as large as that example, or possibly even worse multiple views that access such sized files, there might be more of a performance penalty than that.

Re: Libname related opening folder with SAS result

wlierman — Wed, 23 Oct 2024 03:35:50 GMT

I don't know how long, since I leave almost immediately not knowing what is going on. So you are saying that it could take several or a multiple of several minutes before the dataset is shown.

Re: Libname related opening folder with SAS result

ChrisHemedinger — Wed, 23 Oct 2024 12:15:05 GMT

You say the issue is "the folder won't open". Assuming you can get to the M: drive in general, and it seems you can if your local SAS session just successfully created a data set there.

Can you see the file another way? For example, open a command prompt/terminal and list the files:

dir M:\DATA\OR0206965\DRTS__Telehealth OR (powershell) ls M:\DATA\OR0206965\DRTS__Telehealth

Re: Libname related opening folder with SAS result

ballardw — Wed, 23 Oct 2024 14:30:03 GMT

@wlierman wrote:

I don't know how long, since I leave almost immediately not knowing what is going on. So you are saying that it could take several or a multiple of several minutes before the dataset is shown.

In your original question you stated:

I go to the explorer pane to open up the folder DRTS_Telehealth. But the folder does not open.

Since the libraries you show are all on a drive letter M: it is almost certain that the drive is some flavor of network shared drive. The SAS explorer pane would typically be showing the whole library before any data sets if you click on a library. After the library is open then the data sets would be available and response time for opening data sets is definitely related to data set size.

My question and description related to one possible cause of a delay in displaying anything in the Explorer pane. I suspect other network tools or network bandwidth issues might have a similar impact.

So how long did you wait?

Re: Libname related opening folder with SAS result

wlierman — Wed, 23 Oct 2024 15:29:44 GMT

Yes I am able to open the folder now. But thank you for the command line alternative. I have put that in my toolbox of SAS tips.

Re: Libname related opening folder with SAS result

wlierman — Wed, 23 Oct 2024 15:31:49 GMT

I let it sit overnight. It opens now. Thank you for the insight about how SAS works behind the scenes. I have put that in my SAS toolkit.