Nevertheless, your description "about 8" is worrying.
In any observations that have some other number
of characters, this solution may be incorrect. Try
. assert length(oldvar) == 8
Nick
[email protected]
[email protected]
> That worked beautifully, thank you. Just saved me five hours
> of banging
> my head against the wall.
> > Try
> >
> > gen str State = substr(oldvar,4,2)
> >
> > This assumes that your original variable was string.
[email protected]
> > I have a variable that has about 8 characters per
> observation and I need
> > to take 2 characters (4th and 5th characters) and generate
> them as new
> > variables representing state codes. So for example, the
> variable has as
> > one of its value CITNA134. The characters I need to extract are NA,
> > which
> > will be recoded as State code. How would I go about doing this?
*
* 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/