Desktop productivity for business analysts and programmers

Save the resulting dataset in the AUTOLOAD folder

Reply
Contributor
Posts: 61

Save the resulting dataset in the AUTOLOAD folder

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.

Capture.PNG

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.

 

Trusted Advisor
Posts: 1,185

Re: Save the resulting dataset in the AUTOLOAD folder

[ Edited ]

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 Smiley Wink

Contributor
Posts: 61

Re: Save the resulting dataset in the AUTOLOAD folder

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.
Super User
Posts: 3,233

Re: Save the resulting dataset in the AUTOLOAD folder

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;

 

Contributor
Posts: 61

Re: Save the resulting dataset in the AUTOLOAD folder

Thanks and sorry for the delay. Let me try this and come back to you.
Ask a Question
Discussion stats
  • 4 replies
  • 398 views
  • 0 likes
  • 3 in conversation