Solved: Re: Conditional Date

paperboy22 · Posted 10-20-2018 01:09 PM

Hello,

I am trying to create a variable that results in a yes if the patients birthday is today and a no otherwise. For example, the only the patient's birthday that is today has a birthday of 10/20/1947 and today is 10/20/2018 so I keep getting 'No' for it. I've tried this, but it has not worked: if bdate=today() then Today='Yes';
else if bdate ne today()then Today='No';

Kurt_Bremser · Posted 10-20-2018 01:16 PM

today = ifc(month(today()) = month(bdate) and day(today()) = day(bdate),'yes','no');

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

View solution in original post

Kurt_Bremser · Posted 10-20-2018 01:16 PM

today = ifc(month(today()) = month(bdate) and day(today()) = day(bdate),'yes','no');

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

paperboy22 · Posted 10-20-2018 02:09 PM

Thank you that worked great.

Conditional Date

Re: Conditional Date

Re: Conditional Date

Re: Conditional Date

Registration is open

SAS Training: Just a Click Away