|
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 ;
run ;
proc print data=one ;
format begindatetime datetime. yesterday date9. ;
run ;
/LWn
"Nevin Krishna" <nevinkrishna@hotmail.com> skrev i meddelandet
news:9d1b44fd.0405182113.79cae6be@posting.google.com...
> Hello,
>
> 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
| 
