Drop that second if :O
On Apr 22, 2011 1:57 PM, "Gabriel Rosas" <email@example.com> wrote:
> Or following Sterling's suggestion:
> If intnx('day',surgery_date,-90) LE surgery_date LE If
> On Apr 22, 2011 1:52 PM, "Suzanne McCoy" <
> Suzanne.McCoy@catalinamarketing.com> wrote:
>> If intnx('month',surgery_date,-3)
>> -----Original Message-----
>> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Jill
>> Sent: Friday, April 22, 2011 1:39 PM
>> To: SAS-L@LISTSERV.UGA.EDU
>> Subject: Identifying dates within 3-month range
>> Hello everyone. I'm working with a macro to match controls to cases based
> on a surgery date range of +/-3 months. Surgery date is in the mmddyy8.
> form. I've been scouring the Internet looking for guidance on how best to
> this, but I'm not having much luck.
>> Here's my thinking thus far: If I extract the months from each date, I'll
> only get a crude +/- 3 month estimate that doesn't take into account the
> days of the month. If I convert the entire date to days and use a +/- 30
> range, I can't accurately account for months with 31 days.
>> So my question is, am I even able to use the entire date (mmddyy8.) in
> getting the most precise +/- 3 month range? If so, what's the best syntax
> format to accomplish this task?
>> Thanks in advance.