BookmarkSubscribeRSS Feed
bulewind
Fluorite | Level 6

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!

3 REPLIES 3
Reeza
Super User

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() 
art297
Opal | Level 21

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

1239
Calcite | Level 5

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.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 7107 views
  • 0 likes
  • 4 in conversation