BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
mark4
Obsidian | Level 7

When using SAS Studio, I can create and work with libraries as you would expect, but this is never seen by the 'Libraries' tab.  Running this shows the data sets are created and available for use, but this is never seen by the 'Libraries' tab:

 

libname desktop "C:\Users\L6ZY\Desktop";

proc import datafile="C:\Users\L6ZY\Desktop\my_csv.csv" dbms=csv out=test; run;

proc sql noprint;
create table test_2 as select * from test;
create table desktop.test as select * from test;
quit;

proc datasets lib=work;
run;

proc datasets lib=desktop;
run;

After running this, the log shows there are no issues:

NOTE: This session is in interactive mode.
 
 1          libname desktop "C:\Users\L6ZY\Desktop";
 NOTE: Libref DESKTOP was successfully assigned as follows: 
       Engine:        V9 
       Physical Name: C:\Users\L6ZY\Desktop
 2          
 3          proc import datafile="C:\Users\L6ZY\Desktop\approved_list.csv" dbms=csv out=test;
 3        !                                                                                   run;
 NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary 
 parameter values will be saved to WORK.PARMS.PARMS.SLIST.
 4           /**********************************************************************
 5           *   PRODUCT:   SAS
 6           *   VERSION:   9.4
 7           *   CREATOR:   External File Interface
 8           *   DATE:      17MAY18
 9           *   DESC:      Generated SAS Datastep Code
 10          *   TEMPLATE SOURCE:  (None Specified.)
 11          ***********************************************************************/
 12             data WORK.TEST    ;
 13             %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
 14             infile 'C:\Users\L6ZY\Desktop\approved_list.csv' delimiter = ',' MISSOVER DSD
 14       ! lrecl=32767 firstobs=2 ;
 15                informat V1 $83. ;
 16                informat V2 $22. ;
 17                informat V3 $26. ;
 18                informat V4 $363. ;
 19                informat V5 $25. ;
 20                informat V6 $21. ;
 21                informat V7 $19. ;
 22                informat V8 $14. ;
 23                format V1 $83. ;
 24                format V2 $22. ;
 25                format V3 $26. ;
 26                format V4 $363. ;
 27                format V5 $25. ;
 28                format V6 $21. ;
 29                format V7 $19. ;
 30                format V8 $14. ;
 31             input
 32                         V1 $
 33                         V2 $
 34                         V3 $
 35                         V4 $
 36                         V5 $
 37                         V6 $
 38                         V7 $
 39                         V8 $
 40             ;
 41             if _ERROR_ then call symputx('_EFIERR_',1);  /* set ERROR detection macro variable
 41       ! */
 42             run;
 NOTE: The infile 'C:\Users\L6ZY\Desktop\approved_list.csv' is:
       Filename=C:\Users\L6ZY\Desktop\approved_list.csv,
       RECFM=V,LRECL=32767,File Size (bytes)=271909,
       Last Modified=16May2018:17:36:50,
       Create Time=16May2018:17:36:50
 
 NOTE: 816 records were read from the infile 'C:\Users\L6ZY\Desktop\approved_list.csv'.
       The minimum record length was 88.
       The maximum record length was 756.
 NOTE: The data set WORK.TEST has 816 observations and 8 variables.
 NOTE: DATA statement used (Total process time):
       real time           0.02 seconds
       cpu time            0.01 seconds
       
 
 816 rows created in WORK.TEST from C:\Users\L6ZY\Desktop\approved_list.csv.
   
   
   
 NOTE: WORK.TEST data set was successfully created.
 NOTE: The data set WORK.TEST has 816 observations and 8 variables.
 NOTE: PROCEDURE IMPORT used (Total process time):
       real time           0.23 seconds
       cpu time            0.14 seconds
       
 
 43         
 44         proc sql noprint;
 45         create table test_2 as select * from test;
 NOTE: Table WORK.TEST_2 created, with 816 rows and 8 columns.
 
 46         create table desktop.test as select * from test;
 NOTE: Table DESKTOP.TEST created, with 816 rows and 8 columns.
 
 47         quit;
 NOTE: PROCEDURE SQL used (Total process time):
       real time           0.04 seconds
       cpu time            0.04 seconds
       
 
 48         
 49         proc datasets lib=work;
                                             Directory
 
                      Libref         WORK                                     
                      Engine         V9                                       
                      Physical Name  C:\MySASv94\saswork\_TD14824_L76364_\Prc3
                      Filename       C:\MySASv94\saswork\_TD14824_L76364_\Prc3
 
 
                                 Member       File
                     #  Name     Type         Size  Last Modified
 
                     1  PARMS    CATALOG     17408  05/17/2018 12:50:09        
                     2  REGSTRY  ITEMSTOR    25600  05/17/2018 12:49:55        
                     3  SASGOPT  CATALOG      5120  05/17/2018 12:49:56        
                     4  TEST     DATA       589824  05/17/2018 12:50:09        
                     5  TEST_2   DATA       589824  05/17/2018 12:50:09        
 50         run;
 
 51         
 
 NOTE: PROCEDURE DATASETS used (Total process time):
       real time           0.41 seconds
       cpu time            0.15 seconds
       
 
 52         proc datasets lib=desktop;
                                             Directory
 
                                Libref         DESKTOP              
                                Engine         V9                   
                                Physical Name  C:\Users\L6ZY\Desktop
                                Filename       C:\Users\L6ZY\Desktop
 
 
                                Member     File
                       #  Name  Type       Size  Last Modified
 
                       1  TEST  DATA     589824  05/17/2018 12:50:09        
 53         run;

This is confirmed by the results tab:

image.png

However, the 'Libraries' tab does not change, and it shows my 'Work' library as empty.  Attempting to refresh does not change anything.  For what it's worth, I have no issues running this in 'regular' SAS or EG.

 

image.png

1 ACCEPTED SOLUTION

Accepted Solutions
AmyP_sas
SAS Employee

Are you using interactive mode?  That's the "go interactive" icon you can select (and you can also set your preferences to always start in interactive mode) which lets you submit one line at a time like you can in display manager.  You can see the details in the user's guide but the short story is that an interactive mode tab is pretty much its own SAS session separate from the rest of the interface.  So libraries you set up don't show in the navigation though you can see them with PROC CONTENTS or whatever.  And interactive mode makes use of WEBWORK for temporary files since it can't access WORK from the main Studio SAS session.  

 

Is this a delightful user experience?  Nope.  And I do what I can to discourage folks from using interactive mode unless they're aware of its limitations.  We are working on a better way to do this (essentially offering an interactive mode type experience but in a more obviously separate perspective) since many users want to use interactive PROC's they way they're designed to be used.

View solution in original post

11 REPLIES 11
Reeza
Super User
This sounds like a tech support question, and they'll want the version of SAS Studio as well.
ballardw
Super User

Did you do anything to refresh the libraries tab? Web browsers, ie SAS Studio, usually won't change a display until the link is actually refreshed.

mark4
Obsidian | Level 7

Yes.  Hitting the refresh icon on the Libraries tab does not change anything.

AmyP_sas
SAS Employee

Are you using interactive mode?  That's the "go interactive" icon you can select (and you can also set your preferences to always start in interactive mode) which lets you submit one line at a time like you can in display manager.  You can see the details in the user's guide but the short story is that an interactive mode tab is pretty much its own SAS session separate from the rest of the interface.  So libraries you set up don't show in the navigation though you can see them with PROC CONTENTS or whatever.  And interactive mode makes use of WEBWORK for temporary files since it can't access WORK from the main Studio SAS session.  

 

Is this a delightful user experience?  Nope.  And I do what I can to discourage folks from using interactive mode unless they're aware of its limitations.  We are working on a better way to do this (essentially offering an interactive mode type experience but in a more obviously separate perspective) since many users want to use interactive PROC's they way they're designed to be used.

mark4
Obsidian | Level 7

Thanks.  The issue was in fact interactive mode.  Looking at the documentation, I should be able to see created data that doesn't live in the work folder by refreshing the Library tab.  I wasn't able to get this to work, but was that because you can only see new data once it has been assigned to a library before you start interactive mode?  But yeah, based on all this, it is a pain and something I will keep disabled.

mark4
Obsidian | Level 7

That did fix it, but SAS Studio opens in interactive mode by default.  Is there an option to disable this so that non-interactive mode is the default setting, and if I want interactive mode, I have to manually turn it on?

BrianGaines
SAS Employee

Within the General section of the Preference for SAS Studio, there is an option to "Start new programs in interactive mode."  Make sure that is unchecked. 

 

interactiveModeStartup.jpg

mark4
Obsidian | Level 7

You must be using a newer version.  I'm running 3.2 and only have this.  (Further details on my version are below.)

image.png

 

Release: 3.2 (Single User)

Supported browsers:
  • Microsoft Internet Explorer 9, 10, 11
  • Mozilla Firefox 21+
  • Google Chrome 27+
  • Apple Safari 6.0+ (on Apple OS X)

Build date: Thursday, July 24, 2014, 7:59 AM
SAS Mid-tier release: Thursday, July 24, 2014, 7:57 AM
SAS release: 9.04.01M2P07232014
SAS platform: X64_8PRO WIN
Site name: **
Site number: **

Copyright © 2012-2014, SAS Institute Inc., Cary, NC, USA.

BrianGaines
SAS Employee

Yes, in your screen shot, there is an option to "Start new programs in interactive mode" and it's currently checked.  That option needs to be unchecked.

  studio32interactive.png

mark4
Obsidian | Level 7
Ha...thanks. I have no idea how I missed something so obvious.
BrianGaines
SAS Employee

It happens! 🙂  Glad to help.

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 11 replies
  • 3409 views
  • 0 likes
  • 5 in conversation