I am a beginner in Stata (ver 16) and need help regarding dummy variable.

There is a dummy variable in my dataset, which needs to assume the value of 1, if the auditor (either auditor_name or auditor_partner_name in the dataset) is one of the big 4 or their partners (36 in total). Needless to say, the total number of auditors is very high.

The following is a sample of my dataset.

Thank you in advance.

Warm regards,

Avik


Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
co_code company_name                                  aud_date auditor_name              auditor_partner_name          year
57531 "DEEPAM HOSPITAL PVT. LTD."                       19448 "PARAMESWARAN&ASSOCIATES"  "VPARAMESWARAN"              2013
70661 "APIS INDIA LTD."                                 20544 "SUDHIRAGARWAL&ASSOCIATES" "SUDHIRKUMARAGARWAL"         2016
108826 "JAYPEE CAPITAL SERVICES LTD."                    18717 "RANJANAVANDANA&CO."       "NA"                         2011
146443 "MINDARIKA PVT. LTD."                             20909 "DELOITTEHASKINS&SELLSLLP" "DEEPAKROY"                  2017
153254 "NAFISA TRADING CO. LTD."                         14700 "GKTULSYAN&CO."            "NA"                         2000
173558 "SHRISTI INFRASTRUCTURE DEVP. CORPN. LTD."        19813 "SSKOTHARI&CO."            "RNBARDHAN"                  2014
175005 "PHOENIX INDUSTRIES LTD. (1993)"                  20909 "JLBHATT&CO."              "YOGESHJBHATT"               2017
210444 "SANGAL PAPERS LTD."                              19448 "SHIAM&CO."                "RAJESHKUMARJAIN"            2013
220439 "SHIKHAR CONSULTANTS LTD."                        21274 "RDB&ASSOCIATES"           "ANIKETBALDAWA"              2018
221189 "SHIVA INDUSTRIAL SECURITY AGENCY (GUJARAT) LTD." 17622 "HBDESAI&ASSOCIATES"       "HBDESAI"                    2008
223320 "SHREE RAJASTHAN SYNTEX LTD."                     15430 "MCBHANDARI&CO."           "NA"                         2002
240602 "SUNITA COMMERCIALS PVT. LTD."                    18717 "MITTAL&ASSOCIATES"        "MMEHTA"                     2011
290297 "ENERGYLINK (INDIA) LTD."                         17987 "KISHANMMEHTA&CO."         "NA"                         2009
379538 "MAN PROJECTS LTD."                               19448 "SHAPARIA&MEHTA"           "SANJIVBMEHTA"               2013
385659 "ZEE DIGITAL CONVERGENCE LTD."                    19448 "SUBHASHCGUPTA&CO."        "SUBHASHCGUPTA"              2013
407949 "IMATEK SOLUTIONS PVT. LTD. [MERGED]"             16891 "UKG&ASSOCIATES"           "CHAMPAKKDEDHIA"             2006
437740 "KIMIYA ENGINEERS PVT. LTD."                      20544 "SHARADJOSHI&CO."          "SHARADCHANDRASADASHIVJOSHI" 2016
467753 "SIDERFORGEROSSI INDIA PVT. LTD."                 17256 "BSRAVIKUMAR&ASSOCIATES"   "BSRAVIKUMAR"                2007
547355 "TAG ECO RECYCLING INDIA PVT. LTD."               20544 "SBP&ASSOCIATES"           "JAINPANKAJKIRAN"            2016
557763 "U E I GLOBAL EDUCATION PVT. LTD."                17987 "MGB&CO.LLP"               "LKSHRISHRIMAL"              2009
end
format %tdnn/dd/CCYY auditing_date