Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: st: imputing dates into a string date

From   Tim Evans <>
To   "''" <>
Subject   RE: st: imputing dates into a string date
Date   Thu, 7 Jun 2012 16:01:22 +0100

Perhaps I am missing something here.

When I have the following dates in Stata:


and use the code 

g dx_clean = subinstr(var1, "xx", "01", 1)

I get:

var1	dx_clean
01/xx/2001	01/01/2001
xx/01/2001	01/01/2001
01/01/xxxx	01/01/01xx

The problem seems that both the month gets imputed and also the first part of the missing year.

So I still prefer Nicks original example.

Best wishes


-----Original Message-----
From: [] On Behalf Of Nick Cox
Sent: 07 June 2012 15:35
To: ''
Subject: RE: st: imputing dates into a string date

I wouldn't do precisely that. There might be dates with missing months too, for all we know. That code would replace "XX/XX" with "01/01". Replacing a missing day with 1 is one thing; replacing a missing month with January messes up the data. So, ever picky, I recommend instead

g dx_clean = subinstr(dx, "XX", "01", 1)


daniel klein

this is (probably) much simpler than you might assume. All you need to
type is the one line

g dx_clean = subinstr(dx, "XX", "01", .)

Substitute -g dx_clean- in the code with -replace dx- if you want to
change your original variable.

Hi all,
This is working fine, until I come across a date that actually starts like this:


Then my code to generate a date returns a blank. What I would like to
do is add in something that allows me to evaluate whether the day is
xx and if so, insert 01.

*   For searches and help try:

This email and any attachments hereto contains proprietary information, some or all of which may be confidential or legally privileged. It is for the exclusive use of the intended recipient(s) only. If an addressing or transmission error has misdirected this e-mail and you are not the intended recipient(s), please notify the author by replying to this e-mail. If you are not the intended recipient you must not use, disclose, distribute, copy, print, or rely on this e-mail or any attachments, as this may be unlawful.

*   For searches and help try:

© Copyright 1996–2017 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index