Statalist


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

st: Re: RE: Re: regexr and missing values


From   "Martin Weiss" <martin.weiss1@gmx.de>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: Re: RE: Re: regexr and missing values
Date   Fri, 17 Oct 2008 23:00:43 +0200

Yeah, well, that is not a foolproof method to check. You should rather type -update query- when connected to be absolutely sure...

HTH
Martin
_______________________
----- Original Message ----- From: "Howard Lempel" <HLempel@brookings.edu>
To: <statalist@hsphsun2.harvard.edu>
Sent: Friday, October 17, 2008 10:59 PM
Subject: st: RE: Re: regexr and missing values


Thanks, Martin!

I now know that lack of updating is not the problem.

Howie

Howie Lempel
Research Assistant
The Brookings Institution | Economic Studies

1775 Massachusetts Ave NW | Washington DC 20036
hlempel@brookings.edu | p: (202) 238-3576

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Martin Weiss
Sent: Friday, October 17, 2008 4:53 PM
To: statalist@hsphsun2.harvard.edu
Subject: st: Re: regexr and missing values

"I also do not know how to see what Stata has updated since my last update":
see -help whatsnew-

HTH
Martin
_______________________
----- Original Message -----
From: "Howard Lempel" <HLempel@brookings.edu>
To: <statalist@hsphsun2.harvard.edu>
Sent: Friday, October 17, 2008 10:34 PM
Subject: st: regexr and missing values


Hello all,

I'm using Stata 10 (last updated 10/10/07) and am having a bit of trouble
with the -regexr- function.  I can't tell if I've stumbled on a bug or if
I'm doing something wrong.

I am trying to use -regexr- to transform a string variable called
lfpatfin.  I'd like to take every observation where the last letter in
lfpatfin is "U" and substitute an "E" for the "U".  The code appears to
work except that two observations where lfpatfin was missing have been
replaced with an "E". This appears to be similar to a problem Yun Liu had
with -regexm- on July 16 in this thread:
http://www.stata.com/statalist/archive/2008-07/msg00596.html, but I can't
tell if Yun's issue was ever resolved.  I have been unable to reproduce
the problem using the auto dataset or a dataset generic dataset I created.
My code and some output follows.  I did nothing to test in between
generating it and the -list- command.

gen test = regexr(lfpatfin,"U$", "E")
list lfpatfin test in 1/1000 if lfpatfin != test

     +-----------------+
     | lfpatfin   test |
     |-----------------|
 70. |      FRU    FRE |
105. |      RFU    RFE |
148. |        U      E |
161. |        U      E |
554. |       FU     FE |
     |-----------------|
861. |       FU     FE |
914. |        U      E |
     +-----------------+
list lfpatfin test if missing(lfpatfin) & !missing(test)

      +-----------------+
      | lfpatfin   test |
      |-----------------|
20074. |               E |
24067. |               E |
      +-----------------+

. list lfpatfin test in 16000/16200 if missing(lfpatfin)

      +-----------------+
      | lfpatfin   test |
      |-----------------|
16156. |                 |
16162. |                 |
16166. |                 |
16170. |                 |
16175. |                 |
      |-----------------|
16176. |                 |
16179. |                 |
16180. |                 |
16183. |                 |
16186. |                 |
      |-----------------|
16197. |                 |
      +-----------------+

For what it's worth, I try to make similar changes to lfpatfin
(substituting "B"s for final "D"s) later in my code and had the same
problem.

I'd appreciate it a lot if anyone has any explanation. I also do not know
how to see what Stata has updated since my last update, but I would be
grateful if anyone knows where to go for that - I'd like to check whether
the -regex- functions have been changed.  Unfortunately, I don't have the
admin rights to update my version of Stata.

Thanks for your consideration.
Howie


Howie Lempel
Research Assistant
The Brookings Institution | Economic Studies

1775 Massachusetts Ave NW | Washington DC 20036
hlempel@brookings.edu | p: (202) 238-3576



*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index