Identifying observations with same address but different values on a third variable

[Aline Campos]

I’m working with a dataset that contains information about businesses:

* Example generated by -dataex-. For more info, type help dataex

clear

input str30 company str47 address long NAICScode byte duplicateaddress

"CIRCLE K" "4474 RANDOLPH RD CHARLOTTE"             445120 0

"CIRCLE K" "2326 OWEN DR FAYETTEVILLE"              445120 0

"CIRCLE K" "1627 E MAIN ST LINCOLNTON"              445120 0

"CIRCLE K" "1001 SE CARY PKWY CARY"                 445120 0

"CIRCLE K" "379 SHAWNEEHAW AVE BANNER ELK"          445120 0

"CIRCLE K" "4100 WESTERN BLVD RALEIGH"              445120 1

"CIRCLE K" "8191 CLIFFDALE RD FAYETTEVILLE"         445120 0

"CIRCLE K" "2820 LILLINGTON HWY SPRING LAKE"        445120 0

"CIRCLE K" "919 DURHAM RD WAKE FOREST"              445120 0

"CIRCLE K" "7905 SOUTH BLVD CHARLOTTE"              445120 0

"CIRCLE K" "8500 HARPS MILL RD RALEIGH"             445120 0

"CIRCLE K" "8925 PINEVILLE MATTHEWS RD CHARLOTTE"   445120 1

"CIRCLE K" "6400 BURLINGTON RD WHITSETT"            445120 0

"CIRCLE K" "1003-1007 SPRING LN SANFORD"            445120 0

"CIRCLE K" "1612 CONOVER BLVD E CONOVER"            445120 0

"CIRCLE K" "1803 SAFRIET RD STATESVILLE"            445120 0

"CIRCLE K" "3505 KILDAIRE FARM RD CARY"             445120 0

"CIRCLE K" "546 ASHDALE CT CONCORD"                 445120 0

"CIRCLE K" "3101 YANCEYVILLE ST GREENSBORO"         445120 0

"CIRCLE K" "903 N NC 16 HWY CONOVER"                445120 0

"CIRCLE K" "8100 POPLAR TENT RD CONCORD"            445120 0

"CIRCLE K" "1764 IRELAND DR FAYETTEVILLE"           445120 0

"CIRCLE K" "3458 N MAIN ST HOPE MILLS"              445120 0

"CIRCLE K" "5981 UNIVERSITY PKWY WINSTON SALEM"     445120 0

"CIRCLE K" "3308 APEX HWY # 55 DURHAM"              445120 0

"CIRCLE K" "501 W 3RD ST PEMBROKE"                  445120 0

"CIRCLE K" "5018 SUNSET RD CHARLOTTE"               445120 0

"CIRCLE K" "220 CHARLOTTETOWNE AVE CHARLOTTE"       445120 0

"CIRCLE K" "3721 TRYON RD RALEIGH"                  445120 0

"CIRCLE K" "1800 N CROATAN HWY KILL DEVIL HILLS"    445120 0

"CIRCLE K" "3424 MATTHEWS MINT HILL RD MATTHEWS"    445120 0

"CIRCLE K" "1830 N WESLEYAN BLVD ROCKY MOUNT"       445120 1

"CIRCLE K" "217 SALISBURY ST ROCKWELL"              445120 0

"CIRCLE K" "2195 EVANS ST GREENVILLE"               445120 0

"CIRCLE K" "1145 COPPERFIELD BLVD NE CONCORD"       445120 0

"CIRCLE K" "3289 AVENT FERRY RD RALEIGH"            445120 1

"CIRCLE K" "1032 N HARRISON AVE CARY"               445120 1

"CIRCLE K" "1115 RANDOLPH ST THOMASVILLE"           445120 0

"CIRCLE K" "1630 SUNSET AVE ROCKY MOUNT"            445120 0

"CIRCLE K" "2606 CAROLINA COMMERCE DR GOLDSBORO"    445120 0

"CIRCLE K" "700 JONESTOWN RD WINSTON SALEM"         445120 0

"CIRCLE K" "225 CLEVELAND AVE KINGS MOUNTAIN"       445120 0

"CIRCLE K" "2200 S TRYON ST CHARLOTTE"              445120 0

"CIRCLE K" "7910 RAEFORD RD FAYETTEVILLE"           445120 0

"CIRCLE K" "2494 HOPE MILLS RD HOPE MILLS"          445120 0

"CIRCLE K" "2372 ZEPHYR RD DOBSON"                  445120 0

"CIRCLE K" "429 E WEATHERSPOON ST SANFORD"          445120 0

"CIRCLE K" "3602 REHOBETH CHURCH RD GREENSBORO"     445120 0

"CIRCLE K" "1818 N BERKELEY BLVD GOLDSBORO"         445120 0

"CIRCLE K" "2200 FLEMING RD GREENSBORO"             445120 0

"CIRCLE K" "765 VALLEY RD MOCKSVILLE"               445120 0

"CIRCLE K" "2877 WARD BLVD WILSON"                  445120 0

"CIRCLE K" "3739 CAROLINA BEACH RD WILMINGTON"      445120 0

"CIRCLE K" "421 TYVOLA RD CHARLOTTE"                445120 0

"CIRCLE K" "100 W WOODCROFT PKWY DURHAM"            445120 0

"CIRCLE K" "15620 DON LOCHMAN LN CHARLOTTE"         445120 0

"CIRCLE K" "2500 NEW BERN HWY JACKSONVILLE"         445120 0

"CIRCLE K" "10000 N TRYON ST CHARLOTTE"             445120 0

"CIRCLE K" "621 GREEN VALLEY RD GREENSBORO"         445120 0

"CIRCLE K" "6519 BROOKSHIRE BLVD CHARLOTTE"         445120 0

"CIRCLE K" "6648 GORDON RD WILMINGTON"              445120 0

"CIRCLE K" "199 PINE VALLEY RD JACKSONVILLE"        445120 0

"CIRCLE K" "1300 W SUGAR CREEK RD CHARLOTTE"        445120 0

"CIRCLE K" "4050 RIVER POINTE PL HIGH POINT"        445120 0

"CIRCLE K" "3503 WEDDINGTON RD MONROE"              445120 0

"CIRCLE K" "110 W HAGGARD AVE ELON"                 445120 0

"CIRCLE K" "3001 PLEASANT GARDEN RD GREENSBORO"     445120 0

"CIRCLE K" "2434 S NEW HOPE RD GASTONIA"            445120 0

"CIRCLE K" "1910 N MAIN ST MT AIRY"                 445120 0

"CIRCLE K" "1218 STATE FARM RD BOONE"               445120 0

"CIRCLE K" "2350 US HIGHWAY 70 SE HICKORY"          445120 0

"CIRCLE K" "112 ISLAND FORD RD MAIDEN"              445120 0

"CIRCLE K" "1301 ROBESON ST FAYETTEVILLE"           445120 0

"CIRCLE K" "4000 MEMORIAL DR WINTERVILLE"           445120 0

"CIRCLE K" "1101 WALNUT ST CARY"                    445120 0

"CIRCLE K" "2227 ROCKFORD ST MT AIRY"               445120 0

"CIRCLE K" "4400 LOUISBURG RD RALEIGH"              445120 0

"CIRCLE K" "4330 LOUISBURG RD RALEIGH"              445120 0

"CIRCLE K" "3053 CASTLE HAYNE RD CASTLE HAYNE"      445120 0

"CIRCLE K" "6759 CAROLINA BEACH RD WILMINGTON"      445120 0

"CIRCLE K" "812 S HORNER BLVD SANFORD"              445120 0

"CIRCLE K" "101 E KING ST KING"                     445120 0

"CIRCLE K" "4525 MAIN ST SHALLOTTE"                 445120 0

"CIRCLE K" "807 CONOVER BLVD W CONOVER"             445120 0

"CIRCLE K" "11399 US 15 501 N CHAPEL HILL"          445120 0

"CIRCLE K" "9501 UNIVERSITY CITY BLVD CHARLOTTE"    445120 0

"CIRCLE K" "106 HICKORY TREE RD WINSTON SALEM"      445120 0

"CIRCLE K" "2105 TEN TEN RD APEX"                   445120 0

"CIRCLE K" "144 CEDAR CREEK RD FAYETTEVILLE"        445120 0

"CIRCLE K" "873 LONG BRANCH RD DUNN"                445120 1

"CIRCLE K" "1908 US HIGHWAY 117 S GOLDSBORO"        445120 0

"CIRCLE K" "1550 W GATE CITY BLVD GREENSBORO"       445120 0

"CIRCLE K" "2531 NORTH CAROLINA HIGHWAY 87 CAMERON" 445120 0

"CIRCLE K" "1135 PAMALEE DR FAYETTEVILLE"           445120 0

"CIRCLE K" "701 N GRAHAM ST CHARLOTTE"              445120 0

"CIRCLE K" "104 CHERAW RD HAMLET"                   445120 0

"CIRCLE K" "327 CHICKEN FOOT RD HOPE MILLS"         445120 0

"CIRCLE K" "3122 FORT BRAGG RD FAYETTEVILLE"        445120 0

"CIRCLE K" "3102 BRAGG BLVD FAYETTEVILLE"           445120 0

"CIRCLE K" "601 E SOUTH MAIN ST WAXHAW"             445120 0

end

label values duplicateaddress duplicates

label def duplicates 0 "No", modify

label def duplicates 1 "Yes, 2 occurrences total", modify

Some convenience stores located at gas station convenience stores are listed more than once - once as a gas station, and then separately as a convenience store, and likely with different names. They would have the same address, but different NAICScode (445120 for covenience store and 447190 for gas station). I created the duplicateaddress variable with the following code:

duplicates tag address if NAICScode==445120 | NAICScode==447190, gen(duplicateaddress)

I would like a way to identify companies that have an address duplicate (duplicateaddress>0) but different NAICS codes. Any suggestions?

[Aline Campos]

I'm trying to delete the post below to rephrase my question, but it seems like I can't. So here's my rephrased post, hopefully it makes my ask clearer:

I’m working with a dataset that contains information about businesses:

* Example generated by -dataex-. For more info, type help dataex
clear
input str30 company str47 address long NAICScode
"CARING SENIOR SVC"              "5630 SIX FORKS RD # 203 RALEIGH"            621610
"DREAMWORX"                      "217 OAK ISLAND DR CHAPEL HILL"              541921
"CARY TENNIS PARK"               "2727 LOUIS STEPHENS DR CARY"                713940
"APPLE SEEDS PRESCHOOL"          "7300 SUNSET LAKE RD FUQUAY VARINA"          624410
"SMALL ENGINES UNLIMITED"        "3300 CENTURY FARM RD ROLESVILLE"            811411
"BEN CONLEY"                     "687 WOODLAND CHURCH RD ALBERTSON"           238990
"TIFFANY POTEAT INTERIOR DESIGN" "303 N STERLING ST MORGANTON"                541410
"OXFORD HOUSE"                   "95 CHURCH ST ASHEVILLE"                     813319
"STAR NAILS"                     "1987 HENDERSONVILLE RD # D ASHEVILLE"       812113
"MAACO"                          "1659 OLD HAYWOOD RD ASHEVILLE"              811121
"MALLOY/JORDAN EAST WINSTON"     "1110 E 7TH ST WINSTON SALEM"                519120
"STEELE CREEK VOLUNTEER FIRE"    "8700 STEELE CREEK RD CHARLOTTE"             922160
"FEARRINGTON CARES"              "220 FEARRINGTON POST FEARRINGTON VLG"       813319
"BURGER KING"                    "979 US HIGHWAY 70 E NEW BERN"               722511
"WE CARE RESIDENTIAL"            "5293 WHICHARD RD STOKES"                    621610
"NO 7 TOWNSHIP FIRE-RESCUE DEPT" "1705 OLD CHERRY POINT RD NEW BERN"          922160
"WILSON COUNTY SCHOOL BUS GRGE"  "519 WARD BLVD E WILSON"                     485410
"BEAUFORT TOWN PUBLIC WORKS"     "412 HEDRICK ST BEAUFORT"                    921120
"KINSTON TOWERS"                 "511 N QUEEN ST KINSTON"                     921120
"PITT COUNTY SCHOOLS THEATRE"    "600 W ARLINGTON BLVD GREENVILLE"            921190
"FIRST BANK"                     "405 S SYCAMORE ST ROSE HILL"                522110
"HARMONY FIRE DEPT"              "645 OLIN LOOP OLIN"                         922160
"GREENSBORO WATER RESOURCES"     "6269 TOWNSEND RD BROWNS SUMMIT"             921120
"JOHNSTON COUNTY GOVERNMENT"     "309 E MARKET ST SMITHFIELD"                 921190
"COUNTRY LANE"                   "4601 BLANTON RD FAYETTEVILLE"               531190
"CORNERSTONE FREE WILL CHURCH"   "127 FREEWILL LN LUMBERTON"                  813110
"ABSOLUTE DIRECT MARKETING"      "112 BUSINESS PARK DR INDIAN TRAIL"          541613
"SOURCE TRANSPORT"               "700 MATTHEWS MINT HILL RD MATTHEWS"         484230
"HILTON GARDEN INN-FAYETTEVILLE" "4025 SYCAMORE DAIRY RD FAYETTEVILLE"        721110
"CORNER PANTRY"                  "12280 MCCOLL RD LAURINBURG"                 447190
"YOUNG LAW FIRM"                 "1015 ASHES DR # 201 WILMINGTON"             541110
"ATLANTA BREAD"                  "6886 MAIN ST WILMINGTON"                    722511
"PORT CITY CARPET INC"           "1138 SHIPYARD BLVD WILMINGTON"              541410
"BOJANGLES' FAMOUS CHICKEN"      "1816 12TH AVE NE HICKORY"                   722511
"WITS END VACATION RENTALS"      "193 ESTATES DR BOONE"                       531311
"FOOTHILLS AUCTION & REALTY"     "2974 NC 18 US 64 MORGANTON"                 541990
"ALLIED SPRAY FOAM INSULATION"   "2624 AVENT FERRY RD HOLLY SPRINGS"          238310
"G RICHARDSON INVESTIGATIVE SVC" "5617 DEPARTURE DR # 109 RALEIGH"            541990
"NC STATE COLLEGE-VET MEDICINE"  "1052 WILLIAM MOORE DR RALEIGH"              541940
"R L ENT POWER WASHING SVC"      "6605 DEERVIEW DR RALEIGH"                   238190
"COMMUNITY TREE & LANDSCAPE"     "711 CARVER ST DURHAM"                       561730
"KOONCE WOOTEN & HAYWOOD LLP"    "4060 BARRETT DR RALEIGH"                    541211
"INSTANT IMPRINTS"               "5300 ATLANTIC AVE # 105 RALEIGH"            541490
"HENRYS MUFFLER SHOP"            "5211 LACY AVE RALEIGH"                      811111
"WALGREENS"                      "4408 NEW BERN AVE RALEIGH"                  446110
"APEX-CARY PLUMBING INC"         "."                                          238220
"MILNER INC"                     "3800 GATEWAY CENTRE BLVD # 311 MORRISVILLE" 541711
"MERRIT POWERWASHING"            "."                                          238190
"GARDEN & ART LANDSCAPES"        "4909 WOOD VALLEY DR RALEIGH"                561730
"ALLSTATE INSURANCE"             "9204 FALLS OF NEUSE RD # 110 RALEIGH"       524210
"BODY WISDOM CHIROPRACTIC"       "205 W MILLBROOK RD # 205 RALEIGH"           621310
"BRUSH SALON LLC"                "5725 OLEANDER DR # A3 WILMINGTON"           812112
"FLOWERS & DESIGNS BY ERNEST"    "1402 LIVE OAK ST BEAUFORT"                  453110
"ISLANDS CHOICE"                 "3216 CEDAR ISLAND RD CEDAR ISLAND"          445120
"COMMUNITY TREATMENT ALTRNTVS"   "4901 ROSENA DR CHARLOTTE"                   624190
"PROFESSIONAL WOMEN'S HEALTH"    "805 TILGHMAN DR DUNN"                       621111
"DOLLAR GENERAL"                 "11801 STATESVILLE BLVD CLEVELAND"           452990
"UNIWORLD AUTO SALES"            "3512 SPRING GARDEN ST GREENSBORO"           441120
"CASA VALLARTA MEXICAN RSTRNT"   "3915 BATTLEGROUND AVE GREENSBORO"           722511
"M M FOWLER BP"                  "7601 KNIGHTDALE BLVD KNIGHTDALE"            447190
"FAUROT INC"                     "100 HUNTER PL YOUNGSVILLE"                  561611
"CREATIVE STYLES"                "121 E GANNON AVE # C ZEBULON"               812112
"NCO CUSTOM MARBLE & GRANITE"    "8804 GULF CT # E RALEIGH"                   423320
"AFFORDABLE MOBILE STORAGE"      "2900 NATHAN ST NEWTON"                      493110
"OUTLOOK"                        "309 N COLLEGE AVE NEWTON"                   511110
"BRUNSWICK FAMILY DENTISTRY LLC" "20 MEDICAL CAMPUS DR NW # 201 SUPPLY"       621210
"HOWE BARNES"                    "4000 WESTCHASE BLVD # 110 RALEIGH"          523910
"TURNING POINT FAMILY CARE"      "2000 YONKERS RD RALEIGH"                    621111
"ELECTRIC VIOLIN SHOP"           "5314 N CAROLINA HIGHW #102 DURHAM"          451140
"GAME STOP"                      "11088 US 15 501 HWY # 510 ABERDEEN"         451120
"CAT TAILS"                      "6622 BEACH DR SW OCEAN ISLE BEACH"          812910
"MILLERS CREEK CHILD CARE"       "4120 BOONE TRL MILLERS CREEK"               624410
"AMERICAN NAILS"                 "720 E US HIGHWAY 74 # C ROCKINGHAM"         812113
"DOLLAR TREE"                    "722 E US HIGHWAY 74 # L ROCKINGHAM"         452990
"HAMM HEARING AID CTR"           "1608 WELLINGTON AVE WILMINGTON"             446199
"INGLES MARKET"                  "276 NC 9 HWY LAKE LURE"                     445110
"CATAWBA COUNTY CRIMINAL WRRNTS" "100 SOUTHWEST BLVD # B NEWTON"              921120
"SEARCH TEC INC"                 "3125 POPLARWOOD CT # 100 RALEIGH"           541191
"BARRIER ISLAND AVIATION"        "407 AIRPORT RD MANTEO"                      441228
"TERRA GREEN PRECISION LANDSCP"  "7136 WEDDINGTON RD NW # 112 CONCORD"        561730
"WILD BIRDS UNLIMITED"           "8609 CONCORD MILLS BLVD CONCORD"            444220
"LIGHTHOUSE FAMILY CHURCH"       "2028 WESLEY CHAPEL RD INDIAN TRAIL"         813110
"FISHER REALTY"                  "321 WOODSON ST # 28 SALISBURY"              531110
"CHINA GARDEN"                   "111 W CHURCH ST TROUTMAN"                   722511
"DOYLE CHIROPRACTIC-ACUPUNCTURE" "9630 SHERRILL ESTATES RD # B HUNTERSVILLE"  621310
"CARRIAGE CLEANERS"              "13024 EASTFIELD RD # 100 HUNTERSVILLE"      812320
"FAMILY FOOT CARE"               "1022 LEE ANN DR NE CONCORD"                 621111
"FIRST NATIONAL BANK"            "6201 FAIRVIEW RD # 100 CHARLOTTE"           522110
"ESTHETICS CENTER FOR"           "353 CLEMENT AVE CHARLOTTE"                  621111
"ROGERS AUTOMOTIVE"              "160 LOG CABIN RD WAYNESVILLE"               811111
"JIM'S GUN SHOP"                 "609 WOODLAND RD RALEIGH"                    451110
"PANADERIA LA ESPIGA LLC"        "2237 NEW HOPE CHURCH RD RALEIGH"            311811
"MCCALL LAW FIRM"                "2626 GLENWOOD AVE # 390 RALEIGH"            541110
"TOP SOUND PRODUCTIONS"          "PO BOX 99046 RALEIGH"                       512240
"T KC XXXI"                      "5935 CARNEGIE BLVD CHARLOTTE"               722511
"CORNERCAP INVESTMENT COUNSEL"   "6101 CARNEGIE BLVD # 550 CHARLOTTE"         523930
"PIVER AUTOMOTIVE"               "604 STAKE RD TABOR CITY"                    811111
"COASTAL MOBILE DETAILING"       "1537 BROOKDALE AVE CHARLOTTE"               811192
"JERSEY MIKE'S SUBS"             "2309 US HIGHWAY 70 E NEW BERN"              722511
"CYPRESS OF CHARLOTTE"           "3442 CYPRESS CLUB DR CHARLOTTE"             623311
end

Some convenience stores located at gas station convenience stores are listed more than once - once as a gas station, and then separately as a convenience store, and likely with different names. They would have the same address, but different NAICScode (445120 for convenience stores and 447190 for gas stations).

I would like a way to identify companies that have the same address but different NAICS codes, regardless of whether they have the same name or not. Any suggestions?

[Clyde Schechter]

I'm not at all sure I understand what you want. In particular, I'm not sure why it's different from the duplicateaddress variable you already created. But maybe it's this:
[code]
by company address (NAICScode), sort: gen byte wanted = NAICScode[1] != NAICScode[_N]
[/code

Note: It isn't possible to test or demonstrate this code in the example data because in the example data there are no duplicate addresses at all. If what I've posted here doesn't do what you want, when you post back, in addition to a clearer explanation (or perhaps illustrating it concretely), please post a different data example that actually contains some examples of the phenomenon you are trying to capture.

[Aline Campos]

Hi Clyde - thanks so much for your reply. I guess a better way of explaining is that I am only interested in companies that share the same address but have different NAICScode. The duplicateaddress variable that I created also tags companies that have the same NAICScode.

This example data should exemplify what I mean:

* Example generated by -dataex-. For more info, type help dataex
clear
input str30 company str47 address long NAICScode
"BURGER KING"                    "0 FORT BRAGG # SBH FORT BRAGG"          722511
"HOWLING RUN LANDSCAPING LLC"    "0 N MAIN ST GRANITE FALLS"              561730
"STITCH WITCH"                   "0 OLD HAW CREEK RD ASHEVILLE"           236118
""                               "0-1900 FORT BRAGG"                      621340
"CENTRAL UNITED METHODIST CHR"   "1 2ND ST LAURINBURG"                    813110
"FRYE SOUTH CAMPUS"              "1 3RD AVE NW HICKORY"                   621493
"DAVIS FORENSIC GROUP LLC"       "1 ABELIA CT GREENSBORO"                 541380
"CHAMPION CREDIT UNION"          "1 ACADEMY ST CANTON"                    522130
"ASHEVILLE INN"                  "1 ACTON CIR ASHEVILLE"                  721110
"MORGANTON PRESSURE VESSEL"      "1 ALFREDO BAGLIONI DR MARION"           332420
"UNC FSRA TENNIS SHOP"           "1 ALICE INGRAM CIR CHAPEL HILL"         451110
"FACULTY-STAFF RECREATION ASSN"  "1 ALICE INGRAM CIR CHAPEL HILL"         713990
"POOL LINE"                      "1 ALICE INGRAM CIR CHAPEL HILL"         999990
""                               "1 ALL AMERICAN WAY # C-7023 FORT BRAGG" 621111
"PALM VILLAGE"                   "1 ALL SOULS CRES ASHEVILLE"             448120
"ATM"                            "1 AMERICAN LEGION AVE NEWTON"           522110
"AMGEN INC"                      "1 AMGEN CENTER DR CHARLOTTE"            424210
"ANDREW PEARSON DESIGN"          "1 ANDREW PEARSON DR MT AIRY"            337127
"GLASSMASTERS"                   "1 ANDREW PEARSON DR MT AIRY"            337215
"HAS PROPERTIES LLC"             "1 ANDREW PEARSON DR MT AIRY"            531210
"ATM"                            "1 ANGLE ST ASHEVILLE"                   522110
"BILTMORE ESTATE"                "1 ANTLER HILL RD ASHEVILLE"             312130
"ELECTRIC CHARGING STATION"      "1 ANTLER HILL RD ASHEVILLE"             447190
"APPLE VALLEY TRAVEL PARK"       "1 APPLE ORCHARD RD HENDERSONVILLE"      721211
"BILTMORE ESTATE WINERY"         "1 APPROACH RD ASHEVILLE"                312130
"ATM"                            "1 APPROACH RD ASHEVILLE"                522110
"BILTMORE EXECUTIVE SUITES"      "1 APPROACH RD ASHEVILLE"                531312
"LAND ROVER DRIVING SCHOOL"      "1 APPROACH RD ASHEVILLE"                611692
"CARRIAGE & TRAIL RIDE BARNS"    "1 APPROACH RD ASHEVILLE"                713990
"BILTMORE CATERING"              "1 APPROACH RD ASHEVILLE"                722320
"STABLE CAFE"                    "1 APPROACH RD ASHEVILLE"                722511
"DEERPARK RESTAURANT"            "1 APPROACH RD ASHEVILLE"                722511
"YARDSALE ENTERPRISES LLC"       "1 APPROACH RD ASHEVILLE"                999990
"COASTAL HEATING & AIR COND"     "1 ARAGONA BLVD JACKSONVILLE"            238210
"MAGNOLIA PLACE"                 "1 ARIEL LOOP HENDERSONVILLE"            623311
"PRO IMAGE"                      "1 ARMISTEAD ST # 4930 FORT BRAGG"       448190
"WRITER SPEAKS"                  "1 ASCOT POINT CIR ASHEVILLE"            999990
"STARPOINT GLOBAL SVC"           "1 ASHLEY WADE LN #2000 CHAPEL HILL"     493110
"UPSTANDING BICYCLE CO"          "1 ASHLEY WADE LN #7000 CHAPEL HILL"     451110
"ASHLAND DRIVE"                  "1 ASPEN DR GREENSBORO"                  236220
"WESTERN CAROLINA VETERINARY"    "1 ATKINS ST ARDEN"                      541940
"AMERICAN RED CROSS"             "1 B LDG # 1139 FORT BRAGG"              624190
"AUTRY'S MINI-STORAGE"           "1 BAILEY DR JACKSONVILLE"               531130
"SAFELITE AUTO GLASS"            "1 BAILEY DR JACKSONVILLE"               811122
"BAKER FURNITURE"                "1 BAKER WAY CONNELLY SPRINGS"           442110
"BANK OF AMERICA MORTGAGE"       "1 BANK OF AMERICA CTR # 150 CHARLOTTE"  522292
"ANEXIO INC"                     "1 BANK OF AMERICA PLZ 421 FAYE RALEIGH" 999990
"EDNEYVLLE VOLUNTEER FIRE RSC"   "1 BARN HOUSE RD PISGAH FOREST"          922160
"J J S CAPITAL LLC"              "1 BARTRAMS WALK DR ASHEVILLE"           999990
"SKIN SPA ASHEVILLE"             "1 BATTERY PARK AVE # 2 ASHEVILLE"       713940
"HAYWOOD PARK HOTEL & ATRIUM"    "1 BATTERY PARK AVE ASHEVILLE"           721110
"ISA'S FRENCH BISTRO"            "1 BATTERY PARK AVE ASHEVILLE"           722511
"ASHEVILLE CHORAL SOCIETY"       "1 BATTERY PARK AVE ASHEVILLE"           813319
"DOG DOOR"                       "1 BATTLE SQ # 1A ASHEVILLE"             812910
"ASHEVILLE PINBALL MUSEUM"       "1 BATTLE SQ # 1B ASHEVILLE"             712110
"CONUNDRUM"                      "1 BATTLE SQ # 2B ASHEVILLE"                  .
"BATTERY PARK APARTMENTS"        "1 BATTLE SQ ASHEVILLE"                  531110
"BATTLESHIP NORTH CAROLINA"      "1 BATTLESHIP RD WILMINGTON"             712110
"HENDERSONVILLE HIGH SCHOOL"     "1 BEARCAT BLVD HENDERSONVILLE"          611110
"HENDERSON COUNTY BOARD-PUBC ED" "1 BEARCAT BLVD HENDERSONVILLE"          611110
"ANIMAL HOSPITAL OF N ASHEVILLE" "1 BEAVERDAM RD ASHEVILLE"               541940
"ANIMAL HOSPITAL OF N ASHEVILLE" "1 BEAVERDAM RD ASHEVILLE"               541940
"ANIMAL HOSPITAL OF N ASHEVILLE" "1 BEAVERDAM RD ASHEVILLE"               541940
"ANIMAL HOSPITAL-NORTH ASHVLL"   "1 BEAVERDAM RD ASHEVILLE"               541940
"CORNING LIFE SCIENCES"          "1 BECTON CIR DURHAM"                    339112
"CORNING DISCOVER LABS"          "1 BECTON CIR DURHAM"                    423490
""                               "1 BEECH TREE LN ASHEVILLE"              621330
"BISQUE IMPORTS"                 "1 BELMONT AVE BELMONT"                  423990
"B TESNER ELECTRIC LLC"          "1 BETH HILL CT ASHEVILLE"               238210
"BILLY GRAHAM EVANGELISTIC ASSN" "1 BILLY GRAHAM PKWY CHARLOTTE"          813110
"WILLOW COMMUNICATIONS"          "1 BILLY GRAHAM PKWY CHARLOTTE"          813319
"NCF CAROLINAS INC"              "1 BILLY GRAHAM PKWY CHARLOTTE"          999990
"POSANA CAFE"                    "1 BILTMORE AVE ASHEVILLE"               722511
"BILTMORE EQUESTRIAN CTR"        "1 BILTMORE ESTATES DR ASHEVILLE"        713990
""                               "1 BIRD BLDG LN CULLOWHEE"               621399
""                               "1 BIRD BUILDING LANE CULLOWHEE"         621111
"WCU HEALTH SVC"                 "1 BIRD LN CULLOWHEE"                    621111
"WCU HEALTH SVC"                 "1 BIRD LN CULLOWHEE"                    621399
"PISGAH HIGH SCHOOL"             "1 BLACK BEAR DR CANTON"                 611110
"BLACK RIVER VILLAGE APARTMENTS" "1 BLACK RIVER DR ANGIER"                531110
"BLACKBEARD'S CAMPGROUND"        "1 BLACKBEARDS PARK SURF CITY"           721211
"SAVING NATURE INC"              "1 BLAND SPRING PL DURHAM"               999990
"PARAMOUNT ENERGY TECH LLC"      "1 BLEVINS RD WEAVERVILLE"               238220
"TOWN-WRIGHTSVILLE BEACH-REC"    "1 BOB SAWYER DR WRIGHTSVILLE BCH"       921120
"RECREATION DEPARTMENT"          "1 BOB SAWYER DR WRIGHTSVILLE BCH"       921120
"MCPHAUL APPRAISAL"              "1 BOLIN HTS # A CHAPEL HILL"            531320
"HTX TECHNOLOGIES LLC"           "1 BOLIN HTS CHAPEL HILL"                999990
"TOMATO DESIGN GROUP"            "1 BOSTON WAY ASHEVILLE"                 541430
"WNC CHILDREN'S FUND"            "1 BOTANY VIEW CT EXT ASHEVILLE"         813319
"USPS"                           "1 BOYDEN ST BADIN"                      491110
"WEST LOCK & KEY LLC"            "1 BRACKENWOOD CT GREENSBORO"            561622
"BREVARD COLLEGE BOOKSTORE"      "1 BREVARD COLLEGE DR BREVARD"           451211
"JAMES ADDISON JONES LIBRARY"    "1 BREVARD COLLEGE DR BREVARD"           519120
"BREVARD COLLEGE"                "1 BREVARD COLLEGE DR BREVARD"           611310
""                               "1 BREVARD COLLEGE DR BREVARD"           621340
""                               "1 BREVARD COLLEGE DR BREVARD"           621340
"BREVARD COLLEGE BASEBALL FIELD" "1 BREVARD COLLEGE DR BREVARD"           711310
"BREVARD COLLEGE BOARD-TRUSTEES" "1 BREVARD COLLEGE DR BREVARD"                .
"COURTYARD BY MARRIOTT ASHVLL"   "1 BUCKSTONE PL ASHEVILLE"               721110
"NOVOTNY BREAD INC"              "1 BUFFALO AVE NW # 101 CONCORD"         311811
end

See, for example, that there are 3 companies, each with a different NAICS code, at the address 1 ALICE INGRAM CIR CHAPEL HILL - I would like to be able to identify those. In turn, there are 4 companies at the address 1 BEAVERDAM RD ASHEVILLE that all have the same NAICScode - I'm not interested in these.

[Clyde Schechter]

OK, so that's

by address (NAICScode), sort: gen byte wanted = (NAICScode[1] != NAICScode[_N])

[Aline Campos]

That worked, thank you so much!

[Aline Campos]

Ok, I actually need to specify one more thing: companies with NAICScode=445120 that share the same address with companies with NAICScode=447190

Is there a way I could do that?

[Nick Cox]

by address, sort: egen any445120 = max(NAICScode == 445120)  
by address, sort: egen any447190 = max(NAICScode == 447190)  
list address if any445120 & any447190   

On this new question, see https://www.stata.com/support/faqs/d...ble-recording/

On the original question, see https://www.stata.com/support/faqs/d...ions-in-group/

On being unable to delete posts, see https://www.statalist.org/forums/help#closure

[Aline Campos]

Wonderful - thank you very much for the code and resources!