Renaming a string variable in long format.

[Bruce Peer]

Hello. I am learning Stata. I need some help with renaming a string variable.

For example "IRLTLT01ATA156N" should be renamed to Austria or ATA, "IRLTLT01AUA156N" to Australia or AUA and so on.
I tried this: replace substr("IRLTL01ATA156N",9,3 )

And I get this error.
. replace substr("IRLTL01ATA156N", 9,3 )
factor-variable and time-series operators not allowed
r(101);

Thank you.

----------------------- copy starting from the next line -----------------------

* Example generated by -dataex-. For more info, type help dataex
clear
input str15 country str10 datestr int daten float value
"IRLTLT01ATA156N" "1990-01-01" 10958      8.7275
"IRLTLT01ATA156N" "1991-01-01" 11323    8.546667
"IRLTLT01ATA156N" "1992-01-01" 11688    8.139167
"IRLTLT01ATA156N" "1993-01-01" 12054    6.704325
"IRLTLT01ATA156N" "1994-01-01" 12419    7.025466
"IRLTLT01ATA156N" "1995-01-01" 12784    7.135075
"IRLTLT01ATA156N" "1996-01-01" 13149    6.321466
"IRLTLT01ATA156N" "1997-01-01" 13515    5.682842
"IRLTLT01ATA156N" "1998-01-01" 13880      4.7135
"IRLTLT01ATA156N" "1999-01-01" 14245      4.6809
"IRLTLT01ATA156N" "2000-01-01" 14610      5.5554
"IRLTLT01ATA156N" "2001-01-01" 14976    5.080167
"IRLTLT01ATA156N" "2002-01-01" 15341      4.9638
"IRLTLT01ATA156N" "2003-01-01" 15706   4.1408668
"IRLTLT01ATA156N" "2004-01-01" 16071    4.130892
"IRLTLT01ATA156N" "2005-01-01" 16437    3.393733
"IRLTLT01ATA156N" "2006-01-01" 16802   3.8008416
"IRLTLT01ATA156N" "2007-01-01" 17167   4.2970834
"IRLTLT01ATA156N" "2008-01-01" 17532    4.358525
"IRLTLT01ATA156N" "2009-01-01" 17898    3.937633
"IRLTLT01ATA156N" "2010-01-01" 18263   3.2263834
"IRLTLT01ATA156N" "2011-01-01" 18628    3.319658
"IRLTLT01ATA156N" "2012-01-01" 18993    2.371175
"IRLTLT01ATA156N" "2013-01-01" 19359   2.0107584
"IRLTLT01ATA156N" "2014-01-01" 19724   1.4872917
"IRLTLT01ATA156N" "2015-01-01" 20089    .7470416
"IRLTLT01ATA156N" "2016-01-01" 20454   .37538335
"IRLTLT01ATA156N" "2017-01-01" 20820    .5832833
"IRLTLT01ATA156N" "2018-01-01" 21185    .6861584
"IRLTLT01ATA156N" "2019-01-01" 21550   .06293333
"IRLTLT01ATA156N" "2020-01-01" 21915     -.22485
"IRLTLT01ATA156N" "2021-01-01" 22281  -.08538333
"IRLTLT01ATA156N" "2022-01-01" 22646     1.71115
"IRLTLT01AUA156N" "1990-01-01" 10958       13.18
"IRLTLT01AUA156N" "1991-01-01" 11323   10.690833
"IRLTLT01AUA156N" "1992-01-01" 11688        9.22
"IRLTLT01AUA156N" "1993-01-01" 12054    7.280833
"IRLTLT01AUA156N" "1994-01-01" 12419    9.041667
"IRLTLT01AUA156N" "1995-01-01" 12784    9.210896
"IRLTLT01AUA156N" "1996-01-01" 13149    8.209207
"IRLTLT01AUA156N" "1997-01-01" 13515    6.954918
"IRLTLT01AUA156N" "1998-01-01" 13880     5.49297
"IRLTLT01AUA156N" "1999-01-01" 14245    6.009312
"IRLTLT01AUA156N" "2000-01-01" 14610    6.314569
"IRLTLT01AUA156N" "2001-01-01" 14976    5.615264
"IRLTLT01AUA156N" "2002-01-01" 15341    5.843958
"IRLTLT01AUA156N" "2003-01-01" 15706    5.366776
"IRLTLT01AUA156N" "2004-01-01" 16071    5.590775
"IRLTLT01AUA156N" "2005-01-01" 16437    5.339973
"IRLTLT01AUA156N" "2006-01-01" 16802    5.587872
"IRLTLT01AUA156N" "2007-01-01" 17167    5.994521
"IRLTLT01AUA156N" "2008-01-01" 17532    5.817944
"IRLTLT01AUA156N" "2009-01-01" 17898    5.039512
"IRLTLT01AUA156N" "2010-01-01" 18263    5.366042
"IRLTLT01AUA156N" "2011-01-01" 18628    4.879583
"IRLTLT01AUA156N" "2012-01-01" 18993   3.3791666
"IRLTLT01AUA156N" "2013-01-01" 19359   3.6972916
"IRLTLT01AUA156N" "2014-01-01" 19724    3.656667
"IRLTLT01AUA156N" "2015-01-01" 20089    2.710833
"IRLTLT01AUA156N" "2016-01-01" 20454   2.3366666
"IRLTLT01AUA156N" "2017-01-01" 20820   2.6391666
"IRLTLT01AUA156N" "2018-01-01" 21185    2.684167
"IRLTLT01AUA156N" "2019-01-01" 21550   1.4933333
"IRLTLT01AUA156N" "2020-01-01" 21915    .9208333
"IRLTLT01AUA156N" "2021-01-01" 22281        1.48
"IRLTLT01AUA156N" "2022-01-01" 22646    3.200833
"IRLTLT01BEA156N" "1990-01-01" 10958   10.006667
"IRLTLT01BEA156N" "1991-01-01" 11323    9.285833
"IRLTLT01BEA156N" "1992-01-01" 11688    8.653334
"IRLTLT01BEA156N" "1993-01-01" 12054    7.228333
"IRLTLT01BEA156N" "1994-01-01" 12419    7.750834
"IRLTLT01BEA156N" "1995-01-01" 12784    7.480834
"IRLTLT01BEA156N" "1996-01-01" 13149      6.4925
"IRLTLT01BEA156N" "1997-01-01" 13515    5.753334
"IRLTLT01BEA156N" "1998-01-01" 13880   4.7516665
"IRLTLT01BEA156N" "1999-01-01" 14245   4.7491665
"IRLTLT01BEA156N" "2000-01-01" 14610      5.5925
"IRLTLT01BEA156N" "2001-01-01" 14976    5.130833
"IRLTLT01BEA156N" "2002-01-01" 15341    4.986667
"IRLTLT01BEA156N" "2003-01-01" 15706   4.1808333
"IRLTLT01BEA156N" "2004-01-01" 16071      4.1525
"IRLTLT01BEA156N" "2005-01-01" 16437    3.428333
"IRLTLT01BEA156N" "2006-01-01" 16802       3.815
"IRLTLT01BEA156N" "2007-01-01" 17167   4.3283334
"IRLTLT01BEA156N" "2008-01-01" 17532      4.4175
"IRLTLT01BEA156N" "2009-01-01" 17898   3.9016666
"IRLTLT01BEA156N" "2010-01-01" 18263      3.4625
"IRLTLT01BEA156N" "2011-01-01" 18628    4.233333
"IRLTLT01BEA156N" "2012-01-01" 18993           3
"IRLTLT01BEA156N" "2013-01-01" 19359        2.41
"IRLTLT01BEA156N" "2014-01-01" 19724   1.7133334
"IRLTLT01BEA156N" "2015-01-01" 20089         .84
"IRLTLT01BEA156N" "2016-01-01" 20454    .4758333
"IRLTLT01BEA156N" "2017-01-01" 20820       .7225
"IRLTLT01BEA156N" "2018-01-01" 21185        .795
"IRLTLT01BEA156N" "2019-01-01" 21550   .19333333
"IRLTLT01BEA156N" "2020-01-01" 21915  -.14833333
"IRLTLT01BEA156N" "2021-01-01" 22281 -.014166667
"IRLTLT01BEA156N" "2022-01-01" 22646   1.7333333
"IRLTLT01CAA156N" "1990-01-01" 10958   10.727077
end
format %td daten

[George Ford]

g countrycode = substr(country,9,3)

or

replace country = substr(country,9,3)

[Bruce Peer]

Thank you George. It worked.