I'm having some trouble with the interactive query of a table from a DB (i.e., click 'Run') and the LASR table scheduler (i.e., click the clock symbol and set a nightly query for new records).
When I view my data prep setup within VA Data Builder, I've set the 'Where' clause to include all desired records after a given date (1st May). Running this with the interactive query produces the correct result:
77 RECORDS.trn_dt >= '01May2017'd
The following day howerver, the table comes back missing the current month (July). Looking at the Batch Logs, I see that the SAS code on the scheduler reflects an older version of my Data Prep file, where I only wanted 1st May to 30th June:
77 RECORDS.trn_dt Between '01May2017'd AND '30Jun2017'd
How do I ensure that the scheduler is using the current version of my files, and how can I manage the scheduler directly?
That did it! I was under the assumption that the scheduler would run the most recent version of the file, but re-scheduling the query fixed the issue. Thanks!
SAS INNOVATE 2024
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.