calculate date from another date and days

[lone0708]

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

[japelin · Accepted solution]

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;