Code:
* Example generated by -dataex-. For more info, type help dataex clear input str80 CompanyName float freq "Kfhp of The Mid-Atlantic States Inc" 70001 "Kfim LLC" 70002 "Kforce Flexible Solutions LLC" 70003 "Kforce Government Solutions Inc" 70004 "Kforce Inc" 70005 "Kgi Bridgeport Co" 70006 "Khan Enterprises Inc" 70007 "Khan Funds Management America Inc" 70008 "Khan Hotels Inc" 70009 "Khan Resources BV" 70010 "Khedouri Ezair Corp" 70011 "Khosla Ventures Associates III LLC" 70012 "Khosla Ventures LLC" 70013 "Khou-TV Inc" 70014 "Khronos LLC" 70015 "Ki Mobility LLC" 70016 "KiOR Inc" 70017 "Kia Corp" 70018 "Kia Motors America Inc" 70019 "Kia Motors Manufacturing Georgia Inc" 70020 "Kiawah Island Utility Inc" 70021 "Kibar Dis Ticaret AS" 70022 "Kibar Holding AS" 70023 "Kibbi LLC" 70024 "Kibble & Prentice Holding Co" 70025 "Kibo Software Inc" 70026 "Kice Industries Inc" 70027 "Kichler Lighting LLC" 70028 "Kickert School Bus Line Inc" 70029 "Kickstarter PBC" 70030 "Kid Brands Inc" 70031 "Kid Gloves Productions Inc" 70032 "Kid-Systeme GmbH" 70033 "KidCo Inc" 70034 "Kidd Management Inc" 70035 "Kidde Fire Protection Inc" 70036 "Kidde Inc" 70037 "Kidde PLC Inc" 70038 "Kidde Technologies Inc" 70039 "Kidde-Fenwal Inc" 70040 "Kidder Peabody & Co Inc" 70041 "Kiddesigns Inc" 70042 "Kiddie Kandids LLC" 70043 "Kidizen Inc" 70044 "Kidkraft Inc" 70045 "Kidneylife Foundation Inc" 70046 "Kido Industrial Co Ltd" 70047 "Kids 'R' Kids Inc" 70048 "Kids Behavioral Health of Montana Inc" 70049 "Kids II Inc" 70050 "Kids Line LLC" 70051 "Kids Station Toys International Ltd" 70052 "Kids Wish Network Inc" 70053 "Kids v Cancer" 70054 "KidsPeace Corp" 70055 "KidsPeace National Centers Inc" 70056 "Kidz Bop LLC" 70057 "Kiebler Slippery Rock LLC" 70058 "Kieft Brothers Inc" 70059 "Kiekert AG" 70060 "Kien Huat Realty III Ltd" 70061 "Kierland Crossing LLC" 70062 "Kierland Greenway LLC" 70063 "Kiesewetter Wise Kaplan Prather PLC" 70064 "Kiesler Police Supply Inc" 70065 "Kiewit Building Group Inc" 70066 "Kiewit Construction Group Inc" 70067 "Kiewit Constructors Inc" 70068 "Kiewit Corp" 70069 "Kiewit Energy Co" 70070 "Kiewit Infrastructure South Co" 70071 "Kiewit Infrastructure West Co" 70072 "Kiewit Louisiana Co" 70073 "Kiewit Mining Group Inc" 70074 "Kiewit Offshore Services Ltd" 70075 "Kiewit Pacific Co" 70076 "Kiewit Power Constructors Co" 70077 "Kiewit Southwest Co" 70078 "Kiewit Western Co" 70079 "Kifco Inc" 70080 "Kii Inc" 70081 "Kik Interactive Inc" 70082 "Kikiktagruk Inupiat Corp" 70083 "Kikkerland Design Inc" 70084 "Kiko Foods Inc" 70085 "Kiko SpA" 70086 "Kiku Merger Co Inc" 70087 "Kilbourne Medical Laboratories Inc" 70088 "Kilda Group LLC" 70089 "Kildeer Advisors Inc" 70090 "Kilgore Flares Co LLC" 70091 "Kilim Mobilya Kanepe Sanayi Ve Ticaret AS" 70092 "Kill Cliff Inc" 70093 "Killam Oil Co Ltd" 70094 "Killbuck Savings Bank Co/The" 70095 "Killer Creek Harley Davidson Inc" 70096 "Killpack Trucking Inc" 70097 "Kiln Underwriting Ltd" 70098 "Kiloo A/S" 70099 "Kilopass Technology Inc" 70100 end
I hope you are having a great Easter day.
While inspecting my dataset on Companies using legal services,
I have noticed that some CompanyNames seem to be referring to one parent company, albeit with slightly different labels:
"Kiewit Building Group Inc" 70066
"Kiewit Construction Group Inc" 70067
"Kiewit Constructors Inc" 70068
"Kiewit Corp" 70069
"Kiewit Energy Co" 70070
"Kiewit Infrastructure South Co" 70071
"Kiewit Infrastructure West Co" 70072
"Kiewit Louisiana Co" 70073
"Kiewit Mining Group Inc" 70074
"Kiewit Offshore Services Ltd" 70075
"Kiewit Pacific Co" 70076
"Kiewit Power Constructors Co" 70077
"Kiewit Southwest Co" 70078
"Kiewit Western Co" 70079
I want to assign them an identical group identifier for these subsidiary firms under allegedly one parent firm.
Can anyone advise me on how to approach this issue?
Given the high number of observations (140k+ observations), I could use some algorithmic help to assign the group identifiers.
Thank you!
