--- Ziad El-Khatib <[email protected]> wrote:
> Patient was using either "drug1" and "drug2".
> I am trying to create new category to put the value of adherence to
> the two drugs in one column (drugcat). Drug1 and drug2 have values of
> 1, 2, 3 or empty.
>
> i tried
>
>
> gen drugcat=0
> replace drugcat=drug1 if drug1=1 | drug1=2 | drug1=3
> replace drugcat=drug2 if drug2=1 | drug2=2 | drug2=3
>
In logical statements you need to use double equal signs when you mean
equal to:
gen drugcat=0
replace drugcat=drug1 if drug1==1 | drug1==2 | drug1==3
replace drugcat=drug2 if drug2==1 | drug2==2 | drug2==3
An alternative is:
gen drugcat=0
replace drugcat=drug1 if inlist(drug1, 1, 2, 3)
replace drugcat=drug2 if inlist(drug1, 1, 2, 3)
Or:
gen drugcat = cond(inlist(drug1, 1, 2, 3), drug1, ///
cond(inlist(drug2, 1, 2, 3), drug2, 0))
For more see: -help if- -help inlist- and -help cond-
Hope this helps,
Maarten
-----------------------------------------
Maarten L. Buis
Department of Social Research Methodology
Vrije Universiteit Amsterdam
Boelelaan 1081
1081 HV Amsterdam
The Netherlands
visiting address:
Buitenveldertselaan 3 (Metropolitan), room Z434
+31 20 5986715
http://home.fsw.vu.nl/m.buis/
-----------------------------------------
___________________________________________________________
Want ideas for reducing your carbon footprint? Visit Yahoo! For Good http://uk.promotions.yahoo.com/forgood/environment.html
*
* 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/
