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
You can load LASR tables using SAS code that contains conditional processing including DATA steps.
Hi,
How are you loading your LASR tables? Enterprise Guide, DI or Query Builder?
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.