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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.