Desktop productivity for business analysts and programmers

Cannot explore data table in local SAS library

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 14
Accepted Solution

Cannot explore data table in local SAS library

When I right click "explore" on a data table, SAS Enterprise Guide gave me "The active server does not support workspace pooling".

 

When I right click "explore" on a data table which is included in the project tree, SAS Enterprise Guide gave me "The selected dataset cannot be shown in the Data Explorer because the z/OS server is not configured in a way that is compatible with this function. Contact SAS Technical Support for more information."

 

However, I can double click to open the data table from the project tree.

 

I Googled and cannot find anything. I am talking about regular SAS data libraries which sit on a network hard drive.

 


Accepted Solutions
Solution
‎04-07-2016 11:50 AM
SAS Employee
Posts: 14

Re: Cannot explore data table in local SAS library

Hi,

 

See this section of the 9.4 EBI Desktop Administration Guide: http://support.sas.com/documentation/cdl/en/bidaag/69032/HTML/default/viewer.htm#p0oyqlm9apfiktn157j...

 

Using Data Explorer and Quick Stats in SAS Enterprise Guide requires the use of client-managed pooled SAS Workspace Servers.

 

5thandfifty7th Smiley Happy

View solution in original post


All Replies
Solution
‎04-07-2016 11:50 AM
SAS Employee
Posts: 14

Re: Cannot explore data table in local SAS library

Hi,

 

See this section of the 9.4 EBI Desktop Administration Guide: http://support.sas.com/documentation/cdl/en/bidaag/69032/HTML/default/viewer.htm#p0oyqlm9apfiktn157j...

 

Using Data Explorer and Quick Stats in SAS Enterprise Guide requires the use of client-managed pooled SAS Workspace Servers.

 

5thandfifty7th Smiley Happy

SAS Super FREQ
Posts: 270

Re: Cannot explore data table in local SAS library

EG's data explorer does not currently support z/OS servers.  "Exploring" data (in the EG data explorer) and opening data (in the EG data grid) are two separate features.  The EG data explorer uses client-driven workspace pooling (multiple workspace sessions) to execute the interactive "exploration" features (filters, sorts, quick stats) in parallel.  This client-driven workspace pooling isn't supported with z/OS servers, thus the EG data explorer isn't supported with z/OS servers.

Occasional Contributor
Posts: 14

Re: Cannot explore data table in local SAS library

Thank you guys.

 

@fifthand57th Does this mean I have to setup the pooling to just explore a data table? This sounds odd, because I can just double click to view a data table in old PC SAS.

 

@CaseyS_SAS I didn't want to use z/OS server. That's just an odd message SEG gave me which I have no idea.

 

Is there a simple way can let me explore data tables in SEG like in old PC SAS?

Community Manager
Posts: 2,691

Re: Cannot explore data table in local SAS library

"Explore Data" is a richer view of data that presents summary stats with some plots incorporated.  But you can always use the built-in data grid -- simply "Open" your data by double-clicking to add to your project, or right-click->Open on data that you've already added.  I've discussed some of the new grid view features here.

 

For the deeper insight that you might be missing from "Explore", try the Describe->Characterize Data task.  Or the Graph->Scatterplot Matrix for numerical data.

 

Chris

Occasional Contributor
Posts: 14

Re: Cannot explore data table in local SAS library

Sorry for misusing the word "explore". I was refering to simply "open" the data table and see the spreadsheet kind of view of the data. I know the way you described, but that will add the data table to the project tree, which is kind of annoying when you do not need that. I read from somewhere that right click the "Explore" will allow me to view the data table without adding it to the project tree, and I can change the default action of double click from "open" to "explore". But somehow SEG gave me the strange errors I posted on the first post. 

 

I just realized that, to "explore" data tables, I can simply open a blank SEG window and "open" data tables to view them. Or maybe I should just do it in PC SAS, instead of SEG.

 

Thank you guys.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 373 views
  • 0 likes
  • 4 in conversation