Hi Hi,
I have dataset:
I need to determine how many establishments, each firm has. (Number of establishments).
Firms' identifiers: NPC_FIC
Establishment ID: ESTAB_ID
If the firm is Headquarter, Sede= 2 (N)
If the firm is not Headquarter, Sede= 1 (S)
Number of observations: 3,432,821
Appreciate any help.
Paris
I have dataset:
Code:
* Example generated by -dataex-. For more info, type help dataex clear input double(NPC_FIC ESTAB_ID) long Sede 500000001 -8146170000 2 500000001 -8146170000 2 500000001 -8146170000 2 500000002 794390 2 500000002 794390 2 500000002 794390 2 500000002 794390 2 500000002 794390 2 500000033 725800 2 500000033 725800 2 500000050 5 2 500000050 5 2 500000083 8 2 500000104 721748 2 500000104 721748 2 500000119 766713 2 500000119 766713 2 500000119 766713 2 500000119 766713 2 500000119 766713 2 500000119 766713 2 500000119 766713 2 500000119 766713 2 500000121 649554 2 500000121 649554 2 500000156 932332 2 500000156 932332 2 500000157 18 2 500000157 18 2 500000157 18 2 500000165 671147 2 500000165 671147 2 500000165 671147 2 500000180 21 2 500000198 732861 2 500000198 732861 2 500000198 732861 2 500000201 736025 2 500000204 25 2 500000204 25 2 500000212 722107 2 500000215 798536 2 500000215 798536 2 500000215 798536 2 500000215 798536 2 500000240 33 2 500000240 33 2 500000276 38 2 500000279 785658 2 500000284 42 2 500000284 42 2 500000284 42 2 500000284 42 2 500000305 646194 2 500000324 882387 1 500000334 737994 2 500000341 52 2 500000341 52 2 500000346 929162 2 500000346 929162 2 500000346 929162 2 500000346 929162 2 500000346 929162 2 500000376 55 1 500000376 56 1 500000376 55 1 500000376 56 1 500000376 54 2 500000376 56 1 500000376 54 2 500000376 55 1 500000376 55 1 500000395 57 2 500000395 57 2 500000395 57 2 500000395 57 2 500000395 57 2 500000395 57 2 500000465 761201 2 500000465 761201 2 500000465 761201 2 500000470 895709 2 500000470 895709 2 500000478 653463 2 500000525 65 2 500000543 846232 2 500000543 846232 2 500000565 817918 2 500000583 636304 1 500000583 636303 2 500000600 71 1 500000600 71 1 500000633 75 2 500000633 75 2 500000675 439022 2 500000709 624582 2 500000748 79 2 500000757 796083 2 500000761 779588 1 500000761 779588 1 end label values Sede Sede label def Sede 1 "N", modify label def Sede 2 "S", modify
Firms' identifiers: NPC_FIC
Establishment ID: ESTAB_ID
If the firm is Headquarter, Sede= 2 (N)
If the firm is not Headquarter, Sede= 1 (S)
Number of observations: 3,432,821
Appreciate any help.
Paris
Comment