Re: st: Create a variable equal to the first part of another variable

["Joseph Coveney" <stajc2@gmail.com>]

Mario Jose wrote:

Nick and Rich thank you for your suh<ggestion. I have implemented as
you suggested
gen home_country=substr( id_shar_cty, 1,2)
gen host_country=substr("id_shar_cty", -2,.)
but from both I got the error message "type mismatch". The variable
id_shar_cty is the observation ID from where I want to extract the
other two variables. Am I doing something wrong?

--------------------------------------------------------------------------------

It seems that id_shar_cty is not a string variable.  Try typing

    describe id_shar_cty

or

     confirm string variable id_shar_cty

at the command line.

Joseph Coveney

. input str9 id_shar_cty

     id_shar~y
  1. AT9898_DE
  2. PL9769_CZ
  3. end

. 
. generate str2 home_country = substr(id_shar_cty, 1, 2)

. generate str2 host_country = substr(id_shar_cty, -2, .)

. 
. list, noobs abbreviate(20)

  +-------------------------------------------+
  | id_shar_cty   home_country   host_country |
  |-------------------------------------------|
  |   AT9898_DE             AT             DE |
  |   PL9769_CZ             PL             CZ |
  +-------------------------------------------+

. 
. exit

end of do-file

*
*   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/