Replacing dummy variables = 1 when a firm's activity is classified within a certain SIC code

Hi everyone, I am asking some help for the construction of a formula that maybe has some errors. I generated a dummy variable which should be 1 when firms'activities lie within a certain SIC code range (SIC1 for the primary activity; SIC2 for the secondary activity), but when I try to do so by using the following formula, no changes are applied to the variable. Specifically I used:

"replace LitigationRisk = 1 if YEAR == 2013 & inrange(SIC1|SIC2, 3600, 3674)"

What's wrong? I guess there are some troubles with the format of SIC1 and 2 variables. Here are the data:

Code:

* Example generated by -dataex-. To install: ssc install dataex
clear
input str117 CompanyName int YEAR str11 CountryofIncorporation float(SIC1 SIC2 LitigationRisk)
"AMAG Austria Metall AG"                        2013 "Austria" 177   . 0
"AMAG Austria Metall AG"                        2014 "Austria"   .   . .
"AMAG Austria Metall AG"                        2015 "Austria"   .   . .
"AMAG Austria Metall AG"                        2016 "Austria"   .   . .
"AMAG Austria Metall AG"                        2017 "Austria"   .   . .
"AMAG Austria Metall AG"                        2018 "Austria"   .   . .
"AMAG Austria Metall AG"                        2019 "Austria"   .   . .
"AT & S Austria Technologie & Systemtechnik AG" 2013 "Austria" 249   . 0
"AT & S Austria Technologie & Systemtechnik AG" 2014 "Austria"   .   . .
"AT & S Austria Technologie & Systemtechnik AG" 2015 "Austria"   .   . .
"AT & S Austria Technologie & Systemtechnik AG" 2016 "Austria"   .   . .
"AT & S Austria Technologie & Systemtechnik AG" 2017 "Austria"   .   . .
"AT & S Austria Technologie & Systemtechnik AG" 2018 "Austria"   .   . .
"AT & S Austria Technologie & Systemtechnik AG" 2019 "Austria"   .   . .
"Agrana Beteiligungs AG"                        2013 "Austria"  61   . 0
"Agrana Beteiligungs AG"                        2014 "Austria"   .   . .
"Agrana Beteiligungs AG"                        2015 "Austria"   .   . .
"Agrana Beteiligungs AG"                        2016 "Austria"   .   . .
"Agrana Beteiligungs AG"                        2017 "Austria"   .   . .
"Agrana Beteiligungs AG"                        2018 "Austria"   .   . .
"Agrana Beteiligungs AG"                        2019 "Austria"   .   . .
"Andritz AG"                                    2013 "Austria" 215 197 0
"Andritz AG"                                    2014 "Austria"   .   . .
"Andritz AG"                                    2015 "Austria"   .   . .
"Andritz AG"                                    2016 "Austria"   .   . .
"Andritz AG"                                    2017 "Austria"   .   . .
"Andritz AG"                                    2018 "Austria"   .   . .
"Andritz AG"                                    2019 "Austria"   .   . .
"Asamer Baustoffe AG"                           2013 "Austria"   .   . 0
"Asamer Baustoffe AG"                           2014 "Austria"   .   . .
"Asamer Baustoffe AG"                           2015 "Austria"   .   . .
"Asamer Baustoffe AG"                           2016 "Austria"   .   . .
"Asamer Baustoffe AG"                           2017 "Austria"   .   . .
"Asamer Baustoffe AG"                           2018 "Austria"   .   . .
"Asamer Baustoffe AG"                           2019 "Austria"   .   . .
"Athos Immobilien AG"                           2013 "Austria" 422   . 0
"Athos Immobilien AG"                           2014 "Austria"   .   . .
"Athos Immobilien AG"                           2015 "Austria"   .   . .
"Athos Immobilien AG"                           2016 "Austria"   .   . .
"Athos Immobilien AG"                           2017 "Austria"   .   . .
"Athos Immobilien AG"                           2018 "Austria"   .   . .
"Athos Immobilien AG"                           2019 "Austria"   .   . .
"Aventa AG"                                     2013 "Austria"   .   . 0
"Aventa AG"                                     2014 "Austria"   .   . .
"Aventa AG"                                     2015 "Austria"   .   . .
"Aventa AG"                                     2016 "Austria"   .   . .
"Aventa AG"                                     2017 "Austria"   .   . .
"Aventa AG"                                     2018 "Austria"   .   . .
"Aventa AG"                                     2019 "Austria"   .   . .
"Burgenland Holding AG"                         2013 "Austria" 327 380 0
"Burgenland Holding AG"                         2014 "Austria"   .   . .
"Burgenland Holding AG"                         2015 "Austria"   .   . .
"Burgenland Holding AG"                         2016 "Austria"   .   . .
"Burgenland Holding AG"                         2017 "Austria"   .   . .
"Burgenland Holding AG"                         2018 "Austria"   .   . .
"Burgenland Holding AG"                         2019 "Austria"   .   . .
"CA Immobilien Anlagen AG"                      2013 "Austria" 414 341 0
"CA Immobilien Anlagen AG"                      2014 "Austria"   .   . .
"CA Immobilien Anlagen AG"                      2015 "Austria"   .   . .
"CA Immobilien Anlagen AG"                      2016 "Austria"   .   . .
"CA Immobilien Anlagen AG"                      2017 "Austria"   .   . .
"CA Immobilien Anlagen AG"                      2018 "Austria"   .   . .
"CA Immobilien Anlagen AG"                      2019 "Austria"   .   . .
"Cleen Energy AG"                               2013 "Austria"   .   . 0
"Cleen Energy AG"                               2014 "Austria"   .   . .
"Cleen Energy AG"                               2015 "Austria"   .   . .
"Cleen Energy AG"                               2016 "Austria"   .   . .
"Cleen Energy AG"                               2017 "Austria"   .   . .
"Cleen Energy AG"                               2018 "Austria"   .   . .
"Cleen Energy AG"                               2019 "Austria"   .   . .
"DO & CO AG"                                    2013 "Austria" 398   . 0
"DO & CO AG"                                    2014 "Austria"   .   . .
"DO & CO AG"                                    2015 "Austria"   .   . .
"DO & CO AG"                                    2016 "Austria"   .   . .
"DO & CO AG"                                    2017 "Austria"   .   . .
"DO & CO AG"                                    2018 "Austria"   .   . .
"DO & CO AG"                                    2019 "Austria"   .   . .
"EVN AG"                                        2013 "Austria" 327 269 0
"EVN AG"                                        2014 "Austria"   .   . .
"EVN AG"                                        2015 "Austria"   .   . .
"EVN AG"                                        2016 "Austria"   .   . .
"EVN AG"                                        2017 "Austria"   .   . .
"EVN AG"                                        2018 "Austria"   .   . .
"EVN AG"                                        2019 "Austria"   .   . .
"FACC AG"                                       2013 "Austria" 260   . 0
"FACC AG"                                       2014 "Austria"   .   . .
"FACC AG"                                       2015 "Austria"   .   . .
"FACC AG"                                       2016 "Austria"   .   . .
"FACC AG"                                       2017 "Austria"   .   . .
"FACC AG"                                       2018 "Austria"   .   . .
"FACC AG"                                       2019 "Austria"   .   . .
"Fabasoft AG"                                   2013 "Austria" 436   . 0
"Fabasoft AG"                                   2014 "Austria"   .   . .
"Fabasoft AG"                                   2015 "Austria"   .   . .
"Fabasoft AG"                                   2016 "Austria"   .   . .
"Fabasoft AG"                                   2017 "Austria"   .   . .
"Fabasoft AG"                                   2018 "Austria"   .   . .
"Fabasoft AG"                                   2019 "Austria"   .   . .
"Flughafen Wien AG"                             2013 "Austria" 311   . 0
"Flughafen Wien AG"                             2014 "Austria"   .   . .
end
label values SIC1 SIC1
label def SIC1 61 "2062", modify
label def SIC1 177 "3354", modify
label def SIC1 215 "3554", modify
label def SIC1 249 "3672", modify
label def SIC1 260 "3724", modify
label def SIC1 311 "4581", modify
label def SIC1 327 "4911", modify
label def SIC1 398 "5812", modify
label def SIC1 414 "6513", modify
label def SIC1 422 "6798", modify
label def SIC1 436 "7372", modify
label values SIC2 SIC2
label def SIC2 197 "3559", modify
label def SIC2 269 "4924", modify
label def SIC2 341 "6512; 6519", modify
label def SIC2 380 "6719; 4923", modify

Thanks a lot for the answers!

BJ Data Tech Solution

Home / Data Cleaning / Data management / Data Processing / Replacing dummy variables = 1 when a firm's activity is classified within a certain SIC code
Replacing dummy variables = 1 when a firm's activity is classified within a certain SIC code

0 Response to Replacing dummy variables = 1 when a firm's activity is classified within a certain SIC code

Post a Comment

Home / Data Cleaning / Data management / Data Processing / Replacing dummy variables = 1 when a firm's activity is classified within a certain SIC code Replacing dummy variables = 1 when a firm's activity is classified within a certain SIC code

Related Posts with Replacing dummy variables = 1 when a firm's activity is classified within a certain SIC code

0 Response to Replacing dummy variables = 1 when a firm's activity is classified within a certain SIC code

Post a Comment

Home / Data Cleaning / Data management / Data Processing / Replacing dummy variables = 1 when a firm's activity is classified within a certain SIC code
Replacing dummy variables = 1 when a firm's activity is classified within a certain SIC code