topic Re: how to compare date with current date? in SAS Programming

how to compare date with current date?

bulewind — Wed, 22 Mar 2017 20:27:13 GMT

if input(Date_Stop,yymmdd8.) < %sysfunc(today(),yymmddn8.) then do;errordes5='Invalid Date_Stop'; end ;

how to compare date with current date? above statements don't work, please help, thanks!

Re: how to compare date with current date?

Reeza — Wed, 22 Mar 2017 20:33:11 GMT

Please take a minute to format your code. The followin gis the correct comparison, assuming your date variable is a character and formatted as yymmdd.

input(Date_Stop,yymmdd8.) < today()

Re: how to compare date with current date?

art297 — Wed, 22 Mar 2017 20:35:17 GMT

Your code appears like your stop_date is a character field. If so, then the following should work:

data have;
  input date_stop $;
  if input(Date_Stop,yymmdd8.) < today() then do;
    errordes5='Invalid Date_Stop';
  end ;
  cards;
20151012
20170322
20170323
;

Art, CEO, AnalystFinder.com

Re: how to compare date with current date?

1239 — Fri, 24 Mar 2017 08:00:17 GMT

Please provide more details on the requirement like what exactly you are trying to achieve. If date is compared with current date then what you want to achieve.