At 3:59 PM +0800 6/7/05, Max Bulsara wrote:
I have a long string variable that contains a two digit code. I need
to split it into separate variables. I don't have a separator so
cannot use 'split'. I could use a substr command but the length of
the string can be 50 characters long and hence requires 25 substr
commands. Is there another way of splitting this variable? I am
using stata v9. Would appreciate any comments.
eg:
Var1 Var11 Var12 Var13 Var14 Var15......
==========================================
aabbccddeeffgg aa bb cc dd ee
aa bbccgg wwzz rr aa bb cc gg
bbddyy bb dd yy
Why not just use a loop? For example:
forv i = 1(2)50 {
gen Var1`=(`i'+1)/2' = substr(Var1,`i',2)
}
will work with your example above.
-- Phil
*
* 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/
