topic How to select birthdate < 5? in SAS Programming

How to select birthdate < 5?

ybz12003 — Wed, 26 Feb 2020 01:41:26 GMT

Hello,

How to select the people less than 5 days in the 'Birthdate' column? For example, 02/25/2020 <= 5 days.

Re: How to select birthdate < 5?

Patrick — Wed, 26 Feb 2020 01:59:47 GMT

Please always provide some sample data in the form of a SAS datastep.

Below should give you the idea.

data have;
  input birthdate :date9.;
  format birthdate date9.;
  datalines;
01feb2000
20feb2001
27feb2002
05mar2003
;

data want;
  set have;
  _yearShift=intck('year',birthdate,today());
  _birthdate=intnx('year',birthdate,_yearShift,'s');
  format _birthdate date9.;
  diff=today()-_birthdate;
/*  if abs(diff)<=5 then output;*/
run;

proc print;
run;

Re: How to select birthdate < 5?

ybz12003 — Wed, 26 Feb 2020 02:16:27 GMT

Thank you.