topic Re: Save the resulting dataset in the AUTOLOAD folder in SAS Enterprise Guide

Save the resulting dataset in the AUTOLOAD folder

pedrammobedi — Mon, 05 Sep 2016 13:01:11 GMT

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:

How can I create a dataset from the query?
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.

Re: Save the resulting dataset in the AUTOLOAD folder

JuanS_OCS — Tue, 06 Sep 2016 11:32:05 GMT

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 😉

Re: Save the resulting dataset in the AUTOLOAD folder

pedrammobedi — Tue, 06 Sep 2016 11:36:14 GMT

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.

Re: Save the resulting dataset in the AUTOLOAD folder

SASKiwi — Tue, 06 Sep 2016 20:24:52 GMT

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;

Re: Save the resulting dataset in the AUTOLOAD folder

pedrammobedi — Mon, 12 Sep 2016 12:06:54 GMT

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