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

Importing data dynamically into SAS VA using SAS Base

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.

FROM [DBName].[schema].[Table]
where ATTIME >@date



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: 130

Re: Importing data dynamically into SAS VA using SAS Base

Posted in reply to joshsuihn

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:


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

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