Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: Can Stata -generate- a dummy variable with 2+ 'overlapping'-if- conditions?


From   Philipp Rehm <[email protected]>
To   [email protected]
Subject   Re: st: Can Stata -generate- a dummy variable with 2+ 'overlapping'-if- conditions?
Date   Sun, 24 Sep 2006 12:58:47 +0200

g cl1_new=1 if clmarg>=.95 & clmarg<=1.05 & conlab==1

(Note the "&" as opposed to the "|" in the code).

HTH,
Philipp


Clive Nicholas wrote:
Can anyone help with this annoying problem I have? I've tried several
solutions, and I've searched the archives, the FAQs, [U] and looked at
-whelp recode- and -whelp generate- for one, without success.

I have some data, of which is an exciting snippet

. l clmarg conlab in 40/60, sep(0)

     +-------------------+
     |   clmarg   conlab |
     |-------------------|
 40. | 1.220839        0 |
 41. | 1.092907        0 |
 42. | 1.085126        0 |
 43. | .9743952        0 |
 44. | 1.054179        1 |
 45. | 1.129007        1 |
 46. | 1.125071        1 |
 47. | 1.105309        1 |
 48. | 1.027237        1 |
 49. | 1.049828        0 |
 50. | 1.061838        1 |
 51. | 1.131486        1 |
 52. | 1.182975        0 |
 53. |  1.16508        0 |
 54. | 1.157947        1 |
 55. | 1.014532        1 |
 56. | 1.033752        0 |
 57. | .9131435        0 |
 58. | .9487363        0 |
 59. | .9845221        0 |
 60. | .9323835        0 |
     +-------------------+

where I am looking to -generate- a dummy variable, <cl1>, which scores 1
if, _and only if_, (a) <conlab> = 1 and (b) if <clmarg> lies in the range
.95 and 1.05 (inclusive).

The 'best' attempt I've come up with so far is

. g cl1=1 if (clmarg>=.95 | clmarg<=1.05) & conlab==1 & clmargin <.

but the outcome here is that <cl1> = 1 where <conlab> = 1, regardless of
the value of <clmarg>. Clearly, one -if- condition has overriden the other
in this command (passing over the missings), because they overlap.

Are there any one-shot solutions that avoid this problem? Thanks very much.

CLIVE NICHOLAS        |t: 0(044)7903 397793
Politics              |e: [email protected]
Newcastle University  |http://www.ncl.ac.uk/geps

Whereever you go and whatever you do, just remember this. No matter how
many like you, admire you, love you or adore you, the number of people
turning up to your funeral will be largely determined by local weather
conditions.

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



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