best practice for daily query fetch date

Reply
Frequent Contributor
Posts: 93

best practice for daily query fetch date

hi,

 

I'm setting up daily automated reporting. Each morning, the job is set to query our tables for date: two days minus today (there is a two-day lag with the table refresh).  An approach is to write: where table_date=today()-2;.

 

If there is a better way (or if the above should be avoided), pls let me know. Currenly engine we use is Netezza, or Hadoop.

 

thank you 

PROC Star
Posts: 284

Re: best practice for daily query fetch date

I might be better if done in netezza as where table_date=current_date-2 and create a work sas table and then run the report on it

Ask a Question
Discussion stats
  • 1 reply
  • 94 views
  • 3 likes
  • 2 in conversation