Dear all,
I am using the following data with permno for all the different companies and the dummy for plants inside of the Netherlands (=1) and plants outside of Netherlands (=0). My dataset is way longer than that but this is just an abstract.
permno firms in NE
19166 0
19166 0
19166 1
19166 0
11703 0
11703 1
11703 1
11703 0
11703 1
11703 0
11703 1
19133 0
19133 0
I am trying to create a new variable which allows me to code as "1" whatever permno has a firm in the Netherlands & Outside. If the permno only has in the Netherlands it remains 0. (see for example permno 19166 which has 3 firms outside of the Netherlands and 1 within the Netherlands and permno 19133 which only has firms in the Netherlands). We would therefore get a new column with a serie of 1 for the permno that has firms within the Netherlands AND outside the Netherlands and a serie of 0 for permno 19133.
Thank you for your help
Related Posts with Complex conditions/generation
Command collapse AND keeping the original datasetDear all, I was just thinking about this: When you analyze hierarchical structured dataset (for exa…
How to flag observations that have a certain charateristic in one round but do not have that characteristic in any of the subsequent rounds?Hi everyone, Please consider the following data Code: * Example generated by -dataex-. To install: …
How to use categorical variable in dynamic panel regression?Hello, I am using a country variable, called "targetcountry" in my dynamic panel regression. This v…
Esttab with longtable optionI am exporting a regression table to LaTeX using the community contributed esttab command with longt…
putexcel for multiple tables extending beyond Excel column ZI recently found myself with need to produce over 1000 cross-tabulations with their respective chi-s…
Subscribe to:
Post Comments (Atom)
0 Response to Complex conditions/generation
Post a Comment