topic Re: impossible to open a table in SAS Programming

impossible to open a table

alka54 — Mon, 29 Aug 2016 10:10:23 GMT

Hi,

i'm currently using SAS 9.4 with Windows 7.

When I try to open a table, I get the following error message :

ERROR: Could not query the specified values from the registry.

I also get error message in the log :

ERROR: Attempt to get a string value from a list when the item was a number.
Arguments passed to GETNITEMC:
1 itemlist = 11447
2 (Character Literal) = 'Headers'
3 (Numeric Literal) = 1
4 (Numeric Literal) = 1
5 (Character Literal) = 'LABELS'
Program returning prematurely at line 2558
AF Program: SASHELP.FSP.DATAVIEW.SCL
*** Line 1310: [ERROR: #114] Unable to perform requested function
Parameters passed to method _LOADMODEL:
Program returning prematurely at line 1310
AF Program: SASHELP.FSP.DATAVIEW.SCL
*** Line 662: [ERROR: #114] Unable to perform requested function
Parameters passed to method _OPENTABLE:
1 table = 'test.Base'
2 mode = ''
3 access = ''
Program returning prematurely at line 662
AF Program: SASHELP.FSP.DATAVIEW.SCL
*** Line 486: [ERROR: #114] Unable to perform requested function
ERROR: Call to _SETUP_ failed. Unable to send event SETUP to obj1.
Parameters passed to method _SENDEVENT:
1 (Character Literal) = 'SETUP'
2 command_list = 9795
Program returning prematurely at line 486
AF Program: SASHELP.FSP.VTFRAME.SCL
*** Line 108: [ERROR: #114] Unable to perform requested function
Parameters passed to method CMDARGS:
Program returning prematurely at line 108
AF Program: SASHELP.FSP.VTFRAME.SCL

What can I do ?

Thank you.

Re: impossible to open a table

RahulG — Mon, 29 Aug 2016 10:36:17 GMT

Can you describe a bit what type of table is it?

It seems, a view has been created and you are trying to open the view.

Re: impossible to open a table

Kurt_Bremser — Mon, 29 Aug 2016 11:02:12 GMT

Searching for the text of the error message on google leads me to http://www.hollandnumerics.co.uk/sasfaq/SASFAQ12.HTM, which suggests that deleting your registry.sas7bitm file in your SASUSER (while SAS is not running) might help you.

Re: impossible to open a table

alka54 — Mon, 29 Aug 2016 15:23:49 GMT

Thanks for your answer.

It concerns every table I want to vizualize. The problem appeared suddendly without any action on my part.

I didn't find a registry.sas7bitm file in my SASUSER. Can it be the cause of the problem ?

Re: impossible to open a table

Kurt_Bremser — Tue, 30 Aug 2016 06:26:54 GMT

Did you inspect the directory with Windows Explorer?

If yes, my next step would be to completely remove the SASUSER directory and all its contents, so SAS can create a new one on startup.

If that does not fix your problem, you should raise an issue with SAS technical support.

Re: impossible to open a table

alka54 — Tue, 30 Aug 2016 09:49:50 GMT

thank you, i removed the SASUSER directory and it fixed the problem..

Re: impossible to open a table

employee_brian — Fri, 02 Jun 2017 20:04:13 GMT

The SASUSER directory (Server 2012 R2, SAS 9.4) is the C:\Users\<username>\Documents\My SAS Files\ 9.4 folder. Deleting the 9.4 folder resolved this issue for me.

*Just a note for those who may not know where the SASUSER dir is.