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
[email protected] | p: (202) 238-3576
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Martin Weiss
Sent: Friday, October 17, 2008 4:53 PM
To: [email protected]
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" <[email protected]>
To: <[email protected]>
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
[email protected] | 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/
