I have the following string variable that has 60 unique values. I want to assign Bureau Veritas Certification (USA) and Bureau Veritas North America Inc to the same numeric value. Similarly, I want to assign ERM - New England Inc, ERM Certification and Verification Se.., Environmental Resources Management (UK), and, Environmental Resources Management (U..) to the same numerical value.
Is there an 'or' and and 'and' option in the label command? If so, which one make the most sense 'or' or 'and'? Is there any other easy way to do this?
tabulate Verifiers
Verifiers | Freq. Percent Cum.
----------------------------------------+-----------------------------------
(None) | 1,182 79.97 79.97
Anthesis (UK) Limited | 1 0.07 80.04
Beco Groep | 2 0.14 80.18
Bureau Veritas Certification (USA) | 20 1.35 81.53
Bureau Veritas North America Inc | 19 1.29 82.81
Burns & McDonnell | 5 0.34 83.15
Business for Social Responsibility | 6 0.41 83.56
CH2M HILL | 3 0.20 83.76
Carbon Verification Service LLC | 4 0.27 84.03
Ceres | 2 0.14 84.17
Conestoga-Rovers & Associates | 3 0.20 84.37
Corporate Integrity Ltd | 9 0.61 84.98
Cventure LLC | 2 0.14 85.12
DNV (UK) | 3 0.20 85.32
DNV GL AS | 7 0.47 85.79
DNV GL Business Assurance USA Inc | 3 0.20 85.99
Deloitte & Touche LLP (UK) | 1 0.07 86.06
Deloitte & Touche LLP (USA) | 15 1.01 87.08
Det Norske Veritas Certification Inc | 1 0.07 87.14
Det Norske Veritas Quality Assurance .. | 1 0.07 87.21
ERM - New England Inc | 2 0.14 87.35
ERM Certification and Verification Se.. | 20 1.35 88.70
Environmental Resources Management (UK) | 1 0.07 88.77
Environmental Resources Management (U.. | 7 0.47 89.24
Ernst & Young LLP (UK) | 1 0.07 89.31
Ernst & Young LLP (USA) | 21 1.42 90.73
FIRA Sustainability BV | 17 1.15 91.88
GHD Pty Ltd | 1 0.07 91.95
Haley & Aldrich Inc | 4 0.27 92.22
ISOS Group LLC | 4 0.27 92.49
Independent Advisory Board | 11 0.74 93.23
Jacobs | 1 0.07 93.30
Jane Nelson (Ms) | 1 0.07 93.37
KPMG LLP | 7 0.47 93.84
LBG Research Institute | 1 0.07 93.91
LRQA | 2 0.14 94.05
Lloyd's Register Quality Assurance Ltd | 1 0.07 94.11
Lloyd’s Register Quality Assurance Inc | 12 0.81 94.93
Lloyd’s Register Quality Assurance In.. | 22 1.49 96.41
Lucideon CICS Limited | 1 0.07 96.48
Matrix+ Consulting Pty Ltd | 1 0.07 96.55
Moss Adams LLP | 10 0.68 97.23
PricewaterhouseCoopers (France) | 2 0.14 97.36
Roger Cotton (Mr LL.B., LL.M) | 2 0.14 97.50
SCS Engineers | 1 0.07 97.56
SCS Global Services | 2 0.14 97.70
SGS United Kingdom Ltd | 9 0.61 98.31
Science Applications International Co.. | 2 0.14 98.44
Stantec Consulting Ltd | 1 0.07 98.51
The Climate Registry | 1 0.07 98.58
Thunderbird School of Global Management | 2 0.14 98.71
Tim Smith (Mr) | 2 0.14 98.85
Trucost | 1 0.07 98.92
Trucost plc | 3 0.20 99.12
Two Tomorrows (Europe) Ltd | 2 0.14 99.26
Two Tomorrows (North America) Inc | 4 0.27 99.53
WSP Environmental Ltd | 5 0.34 99.86
WSP USA Inc | 1 0.07 99.93
World Monitors Inc | 1 0.07 100.00
----------------------------------------+-----------------------------------
Total | 1,478 100.00
Related Posts with label & then encode - Assigning 2 or more values to same number
Imputing a passive variableDear all, I have the following data. A group identifier for the region (region) a person lives in wi…
looking for tl_2016_us_county.zip,can you share the package with me?Can any friends share this map pack(tl_2016_us_county.zip)? Just to practice the operation of the sp…
Interpreting significant intereactions inHello, I post below a results table for a diff in diff model. For simplicities sake, please look on…
Interpretation of xtreg,feDear Community, Could you please help with the interpretation of the -xtreg -fe results. Basically,…
dual treatment effect modelI'd like to ask if there is an official command of dual treatment effect model. I use the stata17 ve…
Subscribe to:
Post Comments (Atom)
0 Response to label & then encode - Assigning 2 or more values to same number
Post a Comment