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!