DATA Step, Macro, Functions and more

impossible to open a table

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

impossible to open a table

 

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.


Accepted Solutions
Solution
‎08-30-2016 05:51 AM
Super User
Posts: 6,948

Re: impossible to open a table

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Regular Contributor
Posts: 242

Re: impossible to open a table

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.

Super User
Posts: 6,948

Re: impossible to open a table

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
New Contributor
Posts: 3

Re: impossible to open a table

[ Edited ]

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 ?

 

Solution
‎08-30-2016 05:51 AM
Super User
Posts: 6,948

Re: impossible to open a table

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
New Contributor
Posts: 3

Re: impossible to open a table

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

New User
Posts: 1

Re: impossible to open a table

[ Edited ]

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. 

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 609 views
  • 5 likes
  • 4 in conversation