Importing data dynamically into SAS VA using SAS Base

joshsuihn — Tue, 12 Jan 2016 16:21:39 GMT

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! 🙂

Re: Importing data dynamically into SAS VA using SAS Base

TriciaAanderud — Fri, 15 Jan 2016 13:09:07 GMT

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/

topic Importing data dynamically into SAS VA using SAS Base in SAS Visual Analytics

Importing data dynamically into SAS VA using SAS Base

Re: Importing data dynamically into SAS VA using SAS Base