Are there plans to incorporate send to AMO features for SAS datasets in SAS Studio? It is really hard to get my data out for editing in excel. I know how to export it, but I don't have a need to keep the excel on our server.  Having to export, download from the server, and then open it is incredibly tedious for little adhoc jobs. I was hoping to switch over to SAS Studio from EG because I am doing so many adhoc and not project oriented tasks. Without some type of integration, it takes longer. I currently have SAS Studio 3.81.   Thank you ... View more

I have a libname with this as an option and I am still getting the table name prefixing the variable name.  I am using SAS 9.4.   Here is the code.   Do I have something wrong in the syntax?   libname &lib_name. ODBC dsn=HiveODBC_PROD user=&user_id. password="&hive_pwd." schema=&schema_name. DBLIBINIT='set hive.resultset.use.unique.column.names=false' connection=sharedread;   ... View more

My SAS EGs can get cluttered with temporary data sets in the project tree.  I need to use these while I am in the active session.  However, when I end the session I would love to clear out all the temp data sets listed there.  I know with proc data sets you can delete them from the work directory, but they still show up in the project tree. I would be great to clean them out when closing.   The clutter would be gone once you open the EG the next time.   Is there any method to do this? these all show up when I open a new session even though they are temporary     ... View more