clearing the cache in SAS

[deleted_user]

Hi,

I am not sure this is the right forum for my question, if not please direct me to the appropriate forum.

I am using SAS 9 (SAS for Windows) interface do write and run my SAS programs. I am having an issue with caching. I can connect to a database, using the code below, iwth no problem. However, if the database changes somehow (e.g. table gets deleted), i do not see this change reflected via my connection. I try to clear the libname and reinitialize it, but the tables in the database as seen through this connection do not change. THe only way to get around this, I have found, would be to exit the SAS application and restart it. This is really annoying. It seems to me some sort of caching of my entire database is happening, but I can't be sure. Can anyone tell me what is happening and how I can get around this issue?

libname db_name ODBC datasrc="somesrc" user=user_name
password=**** schema=someschema
;

Thanks in advance!

[GreenCode]

You can try following statement to un-assign libname:
libname db_name clear;

[deleted_user]

What is being cached is the result set of a query to the database.

If you are in EG, then you have to right-click on the library and issue the "Refresh" command.

If you are in PC SAS (dms?) then I'm not sure what you need to do to get it to update, other than to stop the session and restart SAS, which I agree is annoying.