Save the resulting dataset in the AUTOLOAD folder

[pedrammobedi]

I am connected using ODBC to a database table and I am loading that table into SAS Enterpside Guide.

What I want to do is to save the table content as a SAS data set but in Visual Analytics AUTOLOAD folder. It is apparently saved in the WORK library with my current settings which does not serve my purpose.

So I guess I can split my problem into two questions:

1. How can I create a dataset from the query?
2. How can I save this dataset in a folder I want and not the WORK library?

Thanks in advance but please do not answer with general statements.

[JuanS_OCS]

Hi @pedrammobedi, I believe your questions are being answered on a different post. Maybe it would be interesting if you refer to the links on the other posts and mention if the question is solved or not 😉

[pedrammobedi]

This question is not solved. But if I get an answer on my other question, I can remove this one since my problem is very near a solution thanks to you.

[SASKiwi]

Copying a dataset to the SAS VA Autoload folder is as simple as putting it here  - please note this is the default location for Windows so it may be different for you.

\SAS\Config\Lev1\AppData\SASVisualAnalytics\VisualAnalyticsAdministrator\ AutoLoad

A simple SAS program can move it there:

libname autoload "\\MySASVAServer\SAS\Config\Lev1\AppData\SASVisualAnalytics\VisualAnalyticsAdministrator\
AutoLoad";

data autoload.MyTable;
  set MyTable;
run;

[pedrammobedi]

Thanks and sorry for the delay. Let me try this and come back to you.