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?
@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.
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.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.