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: identifying highest number of consecutive variables where answer is consistent across observation
From
Alison El Ayadi <[email protected]>
To
[email protected]
Subject
st: identifying highest number of consecutive variables where answer is consistent across observation
Date
Thu, 20 Feb 2014 09:04:04 -0800
Hi -
I am doing some data cleaning on survey data and am looking to
identify observations where there are 15 or more of the same answers
in a row (across the variables in current order). All of the
variables are string. Does anyone have an easy automated way to do
this? I'm thinking that it could be done by generating a variable
that provided the maximum number of same responses in a row, but have
no idea how to code this. Variables are q1 - q94, and all string.
Any suggestions on efficiently writing this code would be greatly appreciated.
Best,
Alison
*
* 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/