Do you mean "since yesterday" or "since exactly 24 hours"?
I hope this will help you
data one ;
begindatetime = datetime()-24*60*60 ;
yesterday = today()-1 ;
proc print data=one ;
format begindatetime datetime. yesterday date9. ;
"Nevin Krishna" <email@example.com> skrev i meddelandet
> I am trying to create a program that extracts data from a database on
> a daily basis. I was hoping to limit each data extraction to data
> entered into the database within one day of the sas run. for the end
> date of the date range i was going to use &sysdate. How do i create a
> begin date that is 24 hrs before sysdate?
> thank you for your help, Nevin