Generating categorical variable on base year value

[Olly Rice]

Hi there,

I've got stuck on how to code a new categorical variable with the value of another categorical value at it's baseline year of 2010 for all years of that bank.
Essentially for a given bank ""ABH Financial Ltd."" for instance I would like to generate a new variable that is the value of _clus_13 at 2010 for all years of that bank - in this case it would be equal to 2 for each year.

If anyone could tell me the appropriate command to achieve this that would be incredibly helpful!

Thank you

Olly



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

* Example generated by -dataex-. To install: ssc install dataex
clear
input str86 institutionname int year byte _clus_13
"321 Crédito – Instituição Financeira de Crédito, SA" 2010 1
"321 Crédito – Instituição Financeira de Crédito, SA" 2011 1
"321 Crédito – Instituição Financeira de Crédito, SA" 2012 1
"321 Crédito – Instituição Financeira de Crédito, SA" 2013 1
"321 Crédito – Instituição Financeira de Crédito, SA" 2014 1
"321 Crédito – Instituição Financeira de Crédito, SA" 2015 2
"321 Crédito – Instituição Financeira de Crédito, SA" 2016 1
"A.B.S. Factoring AG"                                       2010 1
"A.B.S. Factoring AG"                                       2011 1
"A.B.S. Factoring AG"                                       2012 1
"A.B.S. Factoring AG"                                       2013 1
"A.B.S. Factoring AG"                                       2014 1
"A.B.S. Factoring AG"                                       2015 1
"A.B.S. Factoring AG"                                       2016 4
"ABC Factors SA"                                            2010 1
"ABC Factors SA"                                            2011 1
"ABC Factors SA"                                            2012 1
"ABC Factors SA"                                            2013 1
"ABC Factors SA"                                            2014 1
"ABC Factors SA"                                            2015 1
"ABC Factors SA"                                            2016 1
"ABH Financial Ltd."                                        2010 2
"ABH Financial Ltd."                                        2011 1
"ABH Financial Ltd."                                        2012 1
"ABH Financial Ltd."                                        2013 1
"ABH Financial Ltd."                                        2014 1
"ABH Financial Ltd."                                        2015 1
"ABH Financial Ltd."                                        2016 2
"ABK Allgemeine Beamten Bank AG"                            2010 2
"ABK Allgemeine Beamten Bank AG"                            2011 4
"ABK Allgemeine Beamten Bank AG"                            2012 1
"ABK Allgemeine Beamten Bank AG"                            2013 1
"ABK Allgemeine Beamten Bank AG"                            2014 1
"ABK Allgemeine Beamten Bank AG"                            2015 1
"ABK Allgemeine Beamten Bank AG"                            2016 1
"ABK Bank"                                                  2010 5
"ABK Bank"                                                  2011 2
"ABK Bank"                                                  2012 5
"ABK Bank"                                                  2013 1
"ABK Bank"                                                  2014 1
"ABK Bank"                                                  2015 1
"ABK Bank"                                                  2016 1
"ABN AMRO Bank (Luxembourg) SA"                             2010 3
"ABN AMRO Bank (Luxembourg) SA"                             2011 3
"ABN AMRO Bank (Luxembourg) SA"                             2012 3
"ABN AMRO Bank (Luxembourg) SA"                             2013 3
"ABN AMRO Bank (Luxembourg) SA"                             2014 3
"ABN AMRO Bank (Luxembourg) SA"                             2015 3
"ABN AMRO Bank (Luxembourg) SA"                             2016 3
"ABN AMRO Bank NV"                                          2010 1
"ABN AMRO Bank NV"                                          2011 1
"ABN AMRO Bank NV"                                          2012 2
"ABN AMRO Bank NV"                                          2013 1
"ABN AMRO Bank NV"                                          2014 2
"ABN AMRO Bank NV"                                          2015 2
"ABN AMRO Bank NV"                                          2016 2
"ABN AMRO Group NV"                                         2010 1
"ABN AMRO Group NV"                                         2011 1
"ABN AMRO Group NV"                                         2012 2
"ABN AMRO Group NV"                                         2013 1
"ABN AMRO Group NV"                                         2014 2
"ABN AMRO Group NV"                                         2015 2
"ABN AMRO Group NV"                                         2016 2
"AEGON Bank NV"                                             2010 5
"AEGON Bank NV"                                             2011 5
"AEGON Bank NV"                                             2012 2
"AEGON Bank NV"                                             2013 2
"AEGON Bank NV"                                             2014 2
"AEGON Bank NV"                                             2015 2
"AEGON Bank NV"                                             2016 1
"AGCO Finance GmbH"                                         2010 1
"AGCO Finance GmbH"                                         2011 1
"AGCO Finance GmbH"                                         2012 1
"AGCO Finance GmbH"                                         2013 1
"AGCO Finance GmbH"                                         2014 1
"AGCO Finance GmbH"                                         2015 1
"AGCO Finance GmbH"                                         2016 1
"AIB Mortgage Bank"                                         2010 4
"AIB Mortgage Bank"                                         2011 1
"AIB Mortgage Bank"                                         2012 1
"AIB Mortgage Bank"                                         2013 1
"AIB Mortgage Bank"                                         2014 1
"AIB Mortgage Bank"                                         2015 1
"AIB Mortgage Bank"                                         2016 1
"AKA Ausfuhrkredit-Gesellschaft mbH"                        2010 4
"AKA Ausfuhrkredit-Gesellschaft mbH"                        2011 4
"AKA Ausfuhrkredit-Gesellschaft mbH"                        2012 4
"AKA Ausfuhrkredit-Gesellschaft mbH"                        2013 4
"AKA Ausfuhrkredit-Gesellschaft mbH"                        2014 4
"AKA Ausfuhrkredit-Gesellschaft mbH"                        2015 4
"AKA Ausfuhrkredit-Gesellschaft mbH"                        2016 4
"ALBIS Leasing AG"                                          2010 1
"ALBIS Leasing AG"                                          2011 1
"ALBIS Leasing AG"                                          2012 4
"ALBIS Leasing AG"                                          2013 1
"ALBIS Leasing AG"                                          2014 1
"ALBIS Leasing AG"                                          2015 1
"ALBIS Leasing AG"                                          2016 1
"ALETTI & C. Banca di Investimento Mobiliare SpA"           2010 5
"ALETTI & C. Banca di Investimento Mobiliare SpA"           2011 5
end

[Nick Cox]

See https://www.stata-journal.com/sjpdf....iclenum=dm0055

dm0055 is thus revealed as an otherwise unpredictable search term for mentions here.

Here are three ways to do it. There are many other variations on the theme.

egen wanted1 = total(_clus_13 * (year == 2010) ), by(inst) 

egen wanted2 = max(cond(year == 2010, _clus_13, .) ), by(inst) 

egen wanted3 = max(clus_13 / (year == 2010) ), by(inst)

[Olly Rice]

Thank Nick! the first one worked perfectly!