When you test for equality you must use == not =.
replace drugcat=drug1 if drug1==1 | drug1==2 | drug1==3
replace drugcat=drug2 if drug2==1 | drug2==2 | drug2==3
This would be even better:
replace drugcat=drug1 if inlist(drug1, 1, 2, 3)
Nick
[email protected]
Ziad El-Khatib
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
it is giving invalid syntax.
*
* 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/