When I open a SASHELP view, I get the error "Unable to process SAS data set options for SQL view"

[chipican]

Hi all,

When I double-click on a SASHELP view in order to open it in the Table Viewer, a pop-up shows up with this error message: "ERROR: Unable to process SAS data set options for SQL view SASHELP.XXX" (XXX being the view name), and the view does not open.

The error occurs for any view in SASHELP, i.e. VCOLUMN, VTABLE, VMACROS, etc.

I'm using SAS Studio 3.71 (Basic Edition) with SAS 9.04.

Does anyone know how I can get rid of this error and be able to open SASHELP view in the Table Viewer?

[ballardw]

---

@chipican wrote:

Hi all,

When I double-click on a SASHELP view in order to open it in the Table Viewer, a pop-up shows up with this error message: "ERROR: Unable to process SAS data set options for SQL view SASHELP.XXX" (XXX being the view name), and the view does not open.

The error occurs for any view in SASHELP, i.e. VCOLUMN, VTABLE, VMACROS, etc.

I'm using SAS Studio 3.71 (Basic Edition) with SAS 9.04.

Does anyone know how I can get rid of this error and be able to open SASHELP view in the Table Viewer?

---

Since this generally works with a default installation I would have to ask if you, or some one in your organization, has modified the default behaviors of the menu items.

You might check by  ( the following works in Foundation (Base or DMS SAS) you may have to hunt through SAS Studio settings to find the equivalent. Or do this in the SAS 9.04 (sure you didn't mean 9.4?) you are using.

1) make the SAS explorer window active

2) Click on Tools in the main menu, select Explorer options

3) Go to the Members Tab

   if the VIEW entry for Default Action Command does not look like: VIEWTABLE %8b.%32b

   then select View by clicking on it, then click on the EDIT buton

   Edit Default action to be the string above for the &Open action Item

   Click OK on menus to save options.

[chipican]

Dear @ballardw, thank you for you reply. Sorry for the delay in answering, I was off for a long time.

I read through your reply and will forward it to our IT Team who manages the SAS Studio installation. I hope they will be able to apply your solution as we run SAS Studio on a Linux server.