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
Genetic Matching packageAnalogously to the GenMatch package from R, is there any package in Stata that runs the Genetic Matc…
Panel VARHello everyone. I am trying to apply a fixed effect estimation procedure on a panel var. The variabl…
What does Stata do with margins when using weighted least squares?I was surprised to find that, with weight (or aweight), margins does not seem to compute the average…
nlogit - level 2 alternative variable alt not foundDear scholars, I am having a problem running nlogit after the specification of nlogittree. I have t…
Filter households' data from a censusHi everyone! I'm working on my Master's thesis and I need help. I'm working with census data, and I …
Subscribe to:
Post Comments (Atom)
0 Response to label & then encode - Assigning 2 or more values to same number
Post a Comment