I imported some data table using SAS Base such as:      libname LASR11 SASIOLA startserver host='elitedesk-2012.sas.com' SIGNER="http://elitedesk-2012.sas.com:80/SASLASRAuthorization" port=10011 tag='hps'; data LASR11.Defect; set defect; run; proc metalib; omr(library="/Products/SAS Visual Analytics Administrator/Visual Analytics LASR" repname="Foundation" ); select("defect"); run;   The data table imported as above can't be added to LASRStartSchema in Data Prepration with this message.    How can I  change figure out this issue?    Thanks. ... View more

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! 🙂    ... View more