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.
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.
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.
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.
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 ?
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.
thank you, i removed the SASUSER directory and it fixed the problem..
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.