Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Importing data dynamically into SAS VA using SAS Base

Reply
New Contributor
Posts: 4

Importing data dynamically into SAS VA using SAS Base

[ Edited ]

I'm tyring to figure out importing data (from SQL database) dynamically to Non-distributed SAS VA using SAS Base.

For example, I'd like to extract last 90 days of data from SQL database.

So, I can use SAS code below to pull last 90 days data.


%let date_window=90;

 

proc sql; connect to odbc as DBData (DSN=DSNdata user=user1 pw=userpw);
create table Defect as
select * from connection to Defect
(
DECLARE @Date datetime
SET @Date = DATEADD(day, DATEDIFF(day, 0, GetDate()),0) - &date_window.

SELECT *
FROM [DBName].[schema].[Table]
where ATTIME >@date
);

quit;

 

Then, at SAS script level, I'd like to know

1. how to load and unload the created 'Defect' table to SAS VA

2. how to delete/clear the data from SAS VA (LASR Tables) once it has been loaded 

3. (I'm one fo the admins of SAS VA instantiated) where I can check SAS VA config info such as port. 

 

Please give some help! Smiley Happy 

 

Frequent Contributor
Posts: 123

Re: Importing data dynamically into SAS VA using SAS Base

You might consider using the Autoload feature for this task.  You can drop a dataset to the host file system and the autoloader will place it in the LASR server.  It manages the task quiet nicely.

 

Here's an overview of the process:

https://www.zencos.com/blog/using-the-sas-visual-analytics-autoload-feature/


Tricia Aanderud
Zencos Consulting
Twitter: @taanderud - Follow me!

Ask a Question
Discussion stats
  • 1 reply
  • 288 views
  • 1 like
  • 2 in conversation