I am trying to compute the difference in dates based on the date values in two columns and store the results in a third column. The dataset I have looks like this below.
Id Col1_Date Col2_Date
1 2009-09-10 1916-02-29
1 2009-09-10 NA
The expected output should be
Id Col1_Date Col2_Date Date_Diff
1 2009-09-10 1916-02-29 93.6
1 2009-09-10 NA NA
I have tried a simple DataSet as shown below, but this is not working. I am not seeing any values in Date_Diff column.
DATA WORK.DF1 ;
SET WORK.DF1 ;
FORMAT DOB date10.;
Date_Diff = Col1_Date - Col2.Date;
RUN;
Any help or suggestions on achieving this is much appreciated.
Are the dates SAS dates, ie numeric with a format such as yymmdd or are they character variables?
If they're character you first have to convert them to a number/numeric to do calculations.
@StarMan wrote:
I am trying to compute the difference in dates based on the date values in two columns and store the results in a third column. The dataset I have looks like this below.
Id Col1_Date Col2_Date 1 2009-09-10 1916-02-29 1 2009-09-10 NA
The expected output should be
Id Col1_Date Col2_Date Date_Diff 1 2009-09-10 1916-02-29 93.6 1 2009-09-10 NA NA
I have tried a simple DataSet as shown below, but this is not working. I am not seeing any values in Date_Diff column.
DATA WORK.DF1 ; SET WORK.DF1 ; FORMAT DOB date10.; Date_Diff = Col1_Date - Col2.Date; RUN;
Any help or suggestions on achieving this is much appreciated.
Great ... but you haven't told us what you do see so we can compare it to the expected output. We need that.
As a potential source of problems, your syntax is wrong here:
Date_Diff = Col1_Date - Col2.Date;
It should say
Date_Diff = Col1_Date - Col2_Date;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.