subtracting dates in stata to calculate age

#Subtracting dates in stata to calculate age how to#
#Subtracting dates in stata to calculate age software#
#Subtracting dates in stata to calculate age code#

Learn how to calculate the difference between dates using functions from Google Sheets: DATEDIF, DAYS360, and EDATE. Learn more about Detect errors in formulas.

This example uses the EDATE function, which is used to calculate maturity dates on banking notes. This is based on a 360-day year (twelve 30-day months) that are typical in accounting calculations.Ĭonvert this to a date format and this should be, which is four months (or -4) prior to the date in A3. The number of days between the two dates in A2 and A3, which is 570. This example uses the NETWORKDAYS function. The last argument, A3:A5, lists the holidays to be subtracted from the working days. Working days exclude weekends and holidays. The number of whole working days between the two dates in A2 and A3, which is 107. This example uses the YEAR function, NOW function, and MONTH function. The number of months between A3 and the current date. The two arguments of the DAYS function can be actual dates, cell references, or another date and time function-such as the TODAY function. The number of days between two dates, using two date functions. To account for a leap year occurring every 4 years, 365.25 is used in the formula.Ĭalculates the number of days between two dates without using cell references, which is 153. Learn how to format a cell as a number or date.Ĭalculates the year-fractional age between the dates in A5 and A3.Ĭalculates the age between the dates in A5 and A6, which is 12.08. If this cell doesn't display as a number, ensure that it is formatted as a number or General.

The age of a person born in 1960, without using cell references. Learn how to format a cell as a number or date. If this cell doesn't display a number, ensure that it is formatted as a number or General. This example uses the YEAR and NOW functions. The result is the age of person-the difference between today and the birthdate in A2. Open a new worksheet, the right-click cell A1 and choose Paste Options > Keep Source Formatting. To use these examples in Excel, drag to select the data in the table, then right-click the selection and pick Copy.

The table below shows common methods to do so, using the Date and time functions. Please see examples below: if we specify 1908 we suggest STATA the correct year is 1908, and if we specify 2008 then we suggest STATA the correct year is 2008.Excel can help you calculate the age of a person in different ways. We do so by adding another option to the date command, where we specify the topyear that appears in our data. Note that in this case we have to tell STATA whether “08”is the year 1908 or 2008. Here the variable date_string2 is similar to the one before, but the year component has only two digits rather than four. The second example is slightly more complex. So we can extract the date1 variable in only one line of code. The “MDY” option tells STATA that the date_string1 variable has a month, day, and year – appearing in that specific way. Using the date command you can fix this variable just by telling STATA what this string contains. While here as well you could parse the string into pieces and build a date variable as we did before, you can also use a shortcut to get your proper date variable in one line of code.Ĭonsider variable called date_string1. Maybe the most common situation that you will come across is that your date variable gets imported as string (see data snapshot below). *combine the three components to build a daily date variableįormat %td date_proper FIXING DATE VARIABLES: Example 2 The date variable (BIRTHDATE) in my dataset is formatted as DDMMMYYYY and Ive trying to create an age integer variable from it like 21.

#Subtracting dates in stata to calculate age code#

*destring the three date components to numeric variables Calculate Age from Birth Date Posted 02-07-2018 01:07 PM (47907 views) Ive seen some other threads about this but havent been able to get my code to work based on those. *extract parts of the date_string variable Finally, the three components are destring-ed (converted to numeric) and combined into monthly date using the mdy (month,day,year) command. Next, that string is parsed into three components using the substr (stands for sub-string) command. The code first converts the variable to a string. While this can be fixed in many ways, I suggest the following approach which I hope even STATA beginners will be able to digest easily. In the example below, we start with a variable that is simply a number. Below I give a few examples that should help with that.

#Subtracting dates in stata to calculate age software#

What is often the case is that after importing data from other software such as Microsoft Excel you don’t have such proper STATA date variable. What I mean by proper is a date variable formatted in a way that STATA understands that it is a date variable. All commands above assumed you already have a proper daily date variable.