topic How do i load a table into LASR on conditional basis? in SAS Visual Analytics

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

aswinrahul_madu — Fri, 13 Oct 2017 15:42:33 GMT

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

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

SASKiwi — Fri, 13 Oct 2017 21:50:20 GMT

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

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

aswinrahul_madu — Sat, 14 Oct 2017 05:03:35 GMT

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.

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

itchyeyeballs — Sun, 15 Oct 2017 19:28:24 GMT

Hi,

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

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

aswinrahul_madu — Mon, 16 Oct 2017 04:40:35 GMT

Hello,

I am using data builder to load the tables.

Thanks
Aswin

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

JuanS_OCS — Mon, 16 Oct 2017 07:08:16 GMT

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#n1s2hnpd892n7fn1dp18x2xgffel.htm

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#n0nm6qjzfz4eban1237qqrcmxz0j.htm

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#p1ddpa5p0q2x28n1hgkexlzh7v5y.htm

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