Hello SAS community, 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? (SAS 9.4 using web browser interface SAS VA) Thanks!
... View more