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

How do i load a table into LASR on conditional basis?

Reply
Occasional Contributor
Posts: 15

How do i load a table into LASR on conditional basis?

Hello Everyone,

 

I was wondering if there is a way to load a table into LASR based on a condition (eg: Load CARS table into LASR where Status='Success').

 

Any help or suggestions will be much appreciated.

 

Product Details: SAS Visual Analytics 7.4

 

Thanks

Aswin

Super User
Posts: 4,031

Re: How do i load a table into LASR on conditional basis?

Posted in reply to aswinrahul_madu

You can load LASR tables using SAS code that contains conditional processing including DATA steps.

Occasional Contributor
Posts: 15

Re: How do i load a table into LASR on conditional basis?

Hi SASKiwi,

Thanks for your inputs. Can you help me by citing an example? Right now, i
would like to load table by using a data query.
Frequent Contributor
Posts: 131

Re: How do i load a table into LASR on conditional basis?

Posted in reply to aswinrahul_madu

Hi,

 

How are you loading your LASR tables? Enterprise Guide, DI or Query Builder?

 

 

 

 

Occasional Contributor
Posts: 15

Re: How do i load a table into LASR on conditional basis?

Posted in reply to itchyeyeballs
Hello,

I am using data builder to load the tables.

Thanks
Aswin
Trusted Advisor
Posts: 1,852

Re: How do i load a table into LASR on conditional basis?

Posted in reply to aswinrahul_madu

Hello @aswinrahul_madu,

 

could you already give a look to the Reload-on-start feature? https://support.sas.com/documentation/cdl/en/vaag/69958/HTML/default/viewer.htm#n1s2hnpd892n7fn1dp18...

 

Also, interesting to know, Autoload can help you to automatically load data, if you just drop the final dataset in the autoload folder https://support.sas.com/documentation/cdl/en/vaag/69958/HTML/default/viewer.htm#n0nm6qjzfz4eban1237q...

 

Besides those options, Your queries can be sent to be scheduled in your OS http://support.sas.com/documentation/cdl/en/vaug/68648/HTML/default/viewer.htm#p1ddpa5p0q2x28n1hgkex...

 

This means, there will be a scheduled task in your OS scheduler (Windows Task scheduler or cron/at), and you can set triggers in those scheduler. For this last functionality, I would ask support from your system admins.

 

Hope it helps.

 

Kind regards,

Juan

Ask a Question
Discussion stats
  • 5 replies
  • 180 views
  • 0 likes
  • 4 in conversation