<>
clear
input str6 x
abc123
ab45
cdef67
end
g v2 = substr(x,-3,3)
g v3 = subinstr(x, v2, "", 1)
l
handles your second question. As to the first question, it makes no
sense to use word() on a variable that only contains one word. Words
in Stata terms are defined as space-delimited objects, and 123, abc,
2da are not words.
Kit
Kit Baum | Boston College Economics and DIW Berlin | http://ideas.repec.org/e/pba1.html
An Introduction to Stata Programming | http://www.stata-press.com/books/isp.html
An Introduction to Modern Econometrics Using Stata | http://www.stata-press.com/books/imeus.html
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
