BookmarkSubscribeRSS Feed
aswinrahul_madu
Obsidian | Level 7

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

5 REPLIES 5
SASKiwi
PROC Star

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

aswinrahul_madu
Obsidian | Level 7
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.
itchyeyeballs
Pyrite | Level 9

Hi,

 

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

 

 

 

 

aswinrahul_madu
Obsidian | Level 7
Hello,

I am using data builder to load the tables.

Thanks
Aswin
JuanS_OCS
Amethyst | Level 16

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 5 replies
  • 970 views
  • 0 likes
  • 4 in conversation