topic Re: Cannot explore data table in local SAS library in SAS Enterprise Guide

Cannot explore data table in local SAS library

jflycn — Wed, 06 Apr 2016 19:35:24 GMT

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.

Re: Cannot explore data table in local SAS library

fifthand57th — Wed, 06 Apr 2016 21:36:18 GMT

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#p0oyqlm9apfiktn157jopqfkhicm.htm

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

5thandfifty7th 🙂

Re: Cannot explore data table in local SAS library

CaseySmith — Thu, 07 Apr 2016 13:47:00 GMT

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.

Re: Cannot explore data table in local SAS library

jflycn — Thu, 07 Apr 2016 14:05:07 GMT

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.

@CaseySmith 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?

Re: Cannot explore data table in local SAS library

ChrisHemedinger — Thu, 07 Apr 2016 14:38:34 GMT

"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

Re: Cannot explore data table in local SAS library

jflycn — Thu, 07 Apr 2016 14:53:21 GMT

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.