topic how to subtract weeks from date in New SAS User

how to subtract weeks from date

hjjijkkl — Fri, 21 May 2021 23:13:32 GMT

How do you subtract weeks from a given date? how can i code that

for example I have a data with a date (date1 ) and I want to subtract 36 weeks and get a new date (date2). please look the table below for example.

date1 date 2

5/3/2012 8/25/2011

6/4/2012 9/26/2011

Re: how to subtract weeks from date

hjjijkkl — Fri, 21 May 2021 23:15:10 GMT

Meaning subtracting 36 weeks from date1 to get date 2

Re: how to subtract weeks from date

Kurt_Bremser — Sat, 22 May 2021 07:30:04 GMT

Use the INTNX function with a 'week' interval.

Re: how to subtract weeks from date

PaigeMiller — Sat, 22 May 2021 09:40:47 GMT

Another way to do this is to suntract 36*7 from each date.

Re: how to subtract weeks from date

ballardw — Sat, 22 May 2021 14:50:18 GMT

How many times has it been suggested to you to provide data in the form of a data step?

For one thing, we need to know if the values are actually SAS data values or not.

This shows adjusting a date by 36 weeks to the Same day of the week, Beginning of the week or End of the week.

data have;
   input date1 :mmddyy10.;
datalines;
5/3/2012      
6/4/2012
; 

data want;
   set have;
   date2= intnx('week',date1,-36,'s');
   date3= intnx('week',date1,-36,'b');
   date4= intnx('week',date1,-36,'e');
   format date: mmddyy10.;
run;