calculate date from another date and days

lone0708 — Mon, 24 Jan 2022 09:40:49 GMT

hello community,

this is probably very simple, but how do I calculate a day based on another date minus x days.

Data have:

ID date1 days_from_date2

1 24MAR2007 296

Data want:

ID date1 days_from_date2 Date2

1 24MAR2007 296 date1 - 296

Re: calculate date from another date and days

japelin — Mon, 24 Jan 2022 09:52:34 GMT

Just subtracting.

Data have;
  input ID date1:date9. days_from_date2;
  format date1 date9. ;
datalines;
1 24MAR2007 296
;
run;

data want;
  set have;
  Date2=date1-days_from_date2;
  format Date2 date9.;
run;

If DATE1 is a character variable, convert it with input as follows

data want;
  set have;
  Date2=input(date1,date9.)-days_from_date2;
  format Date2 date9.;
run;

topic Re: calculate date from another date and days in SAS Programming

calculate date from another date and days

Re: calculate date from another date and days