BookmarkSubscribeRSS Feed
terrence_s
Calcite | Level 5

Hi there,

 

I'm not sure what the issue is, but I cannot seem to edit Data Grids through Enterprise Guide.

My colleauge was able to do this (though after some permission changes recently she cannot do it anymore either).

 

I use an locally installed Enterprise Guide, connected to a sasApp metadata server. The Datagrids themselves are stored on the compute server.

 

When I open the Datagrid in Enterprise Guide, I can read the data, but double clicking on a cell would not prompt me to open it up to Edit Mode. The entire Edit section is greyed out also.

 

Is there some permission setting I'm missing?

5 REPLIES 5
CaseySmith
SAS Employee

What libname engine is your library assigned with?  And what specific version of EG (in Help->About) are you using?


Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF

View now: on-demand content for SAS users

terrence_s
Calcite | Level 5

Where would I check the libname engine assignment?

 

I know my libname is this:

LIBNAME dbadg BASE "F:\SAS\Contexts\DBA\DataGrids";

 

and I'm using version 7.11 (7.100.1.2711) (64-bit)

CaseySmith
SAS Employee

Your libname statement indicates you are using the BASE engine.  Another way to check is to query the dictionary table, with code such as:

 

proc sql;

select * from sashelp.vlibnam

where libname eq "DBADG";

quit;

 

I can't think of why you would be unable to edit the data grid values then.  BASE engine is definitely supported.

 

Try submitting this code:

 

LIBNAME dbadg BASE "F:\SAS\Contexts\DBA\DataGrids";

data dbadg.test;

set sashelp.class;

run;

 

After submitting that code, are you able to edit the values in dbadg.test that will be open in the data grid?

 

EG 7.11 (7.100.1.2711) is the initial 7.11 release without any updates applied.  You could try installing the latest update to see if you are encountering an issue that was addressed in an update:

http://ftp.sas.com/techsup/download/hotfix/HF2/U23.html#U23005

 

Casey


Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF

View now: on-demand content for SAS users

terrence_s
Calcite | Level 5

Thanks Casey

 

I ran the first snippet in your response and got this:

DataGrid_sashelp.vlibnam.JPG

 

When I ran the second snippet, I was able to edit that Data Grid.

Really not sure what the difference is.

 

I will try installing the hotfix too.

 

Thanks

Terrence

 

 

CaseySmith
SAS Employee

Terrence,

 

Since you are able to edit the data when you manually assigned a library using the BASE engine and your DBADG library is configured to be assigned via the META libname engine (which can be seen in your query results), I suspect it is just a permissions issue.  I suggest checking the permissions on your library (and/or registered tables) defined in metadata (using SAS Management Console).

 

Casey


Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF

View now: on-demand content for SAS users

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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
  • 5 replies
  • 2142 views
  • 0 likes
  • 2 in conversation