topic Re: Reg Date in SAS Procedures

Reg Date

R_Win — Wed, 09 Feb 2011 05:03:12 GMT

Hi i am having a date i should minus it from the todays date(sysdate)

Data a;
input date ddmmyy10.;
cards;
05/02/2011
run;

for examples sysdate is 10/02/2011 then out put sholud be date=5 it should be automatic as the systemdate but not with today function

Re: Reg Date

Olivier — Wed, 09 Feb 2011 09:39:58 GMT

Hi.
Since SAS dates are stored as number of days (beginning on day 0 which is january 1st, 1960), what you want to do is basically a substraction.
The SAS function called TODAY() or DATE() -- both give the same result -- will deliver the exact date every day.
[pre]Data a;
input date ddmmyy10.;
gap = TODAY() - date ;
cards;
05/02/2011
run;[/pre]

Re: Reg Date

R_Win — Thu, 10 Feb 2011 08:44:42 GMT

Thanks for your reply but i want it my macro sysdate.

Re: Reg Date

sbb — Thu, 10 Feb 2011 13:52:43 GMT

Yes, you can code/use the SAS-maintained macro variable &SYSDATE using a date-constant technique:

DATA _NULL_;
TODAY = "&SYSDATE"D;
PUT TODAY= DATE9.;
RUN;

Do consider that the SAS function TODAY() and using &SYSDATE as shown above are equivalent.

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument, this topic / post:

data step sysdate constant site:sas.com