Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
st: using loop for [_n+1]
From
"Dherani, Mukesh" <[email protected]>
To
"[email protected]" <[email protected]>
Subject
st: using loop for [_n+1]
Date
Thu, 15 Nov 2012 10:37:31 +0000
Dear satalist,
I have few variables both mix of str and numeric entering multiple times. These include company, money, account, date etc. I want to add money if the next row is exactly the same, however stata is coming up with errors when I used following syntax:
("invalid syntax" - if I converted all variables to numeric & "type mismatch" if variables are mix of str and numeric.)
foreach x of varlist v1 v2 v3 .....v10 {
sort v1 v2,stable
gen money=mone+mone[_n+1] if `x'=`x'[_n+1] // here I want to say if the two rows are exactly the same then add money in first row
replace money=mone if `x'!=`x'[_n+1] // here I want to say if the two rows are different then replace it with original value
}
I have used "`x'=`x'[_n+1]" to keep stata happy if there were string variables.
thank you in advance.
best,
Mukesh
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/faqs/resources/statalist-faq/
* http://www.ats.ucla.edu/stat/stata/