Counting the number of business segments/geographic segments

[Remy Dalmulder]

Hello everyone,

I have some trouble with counting the total number of business / geographic segments from my dataset. For my regression: Log (FEE) = β₀ + β₁CFO_Inc + β₂Log(Assets) + β₃Log(Busseg) + β₄Log(Geoseg) + β₅Inventory + β₆ Receivables + β₇Debt + β₈Income + β₉Loss + β₁₀Audit Opinion + β₁₁ICO + β₁₂Big4 i need to identify the business segments and geographical segments. I have the following dataset but still i dont know how to count the number of business and geographical segments per company ( this is only for microsoft)

* Example generated by -dataex-. To install: ssc install dataex
clear
input str6 gvkey str8 stype double(sid capxs ias intseg nis ops sales) long datadate str6(naicsh naicss1 naicss2) str4(sics1 sics2) str244 snms str8 soptp1 str4 sic str6 naics
"012141" "GEOSEG" 14 . . . .     .     . 20635 "511210" ""       ""       ""     ""     "Finland"                     "MARKET"  "7372" "511210"
"012141" "GEOSEG" 12 . . 0 .     . 44742 20635 "511210" ""       ""       ""     ""     "Other Countries"             "MARKET"  "7372" "511210"
"012141" "GEOSEG"  1 . . 0 .     . 40578 20635 "511210" ""       ""       ""     ""     "United States"               "MARKET"  "7372" "511210"
"012141" "BUSSEG" 29 . . 0 .  7252 40460 20635 "511210" "511210" "339930" "7372" "3944" "More Personal Computing"     "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 27 . . 0 . 12461 26487 20635 "511210" "511210" "519130" "7372" "7375" "Productivity and Business"   "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 21 . . 0 . -7779 -6669 20635 "511210" ""       ""       ""     ""     "Corporate & Other"           "PD_SRVC" "7372" "511210"
"012141" "GEOSEG" 14 . . . .     .     . 20269 "511210" ""       ""       ""     ""     "Finland"                     "MARKET"  "7372" "511210"
"012141" "GEOSEG" 13 . . . .     .     . 20269 "511210" ""       ""       ""     ""     "Luxembourg"                  "MARKET"  "7372" "511210"
"012141" "GEOSEG" 12 . . 0 .     . 50639 20269 "511210" ""       ""       ""     ""     "Other Countries"             "MARKET"  "7372" "511210"
"012141" "GEOSEG"  1 . . 0 .     . 42941 20269 "511210" ""       ""       ""     ""     "United States"               "MARKET"  "7372" "511210"
"012141" "BUSSEG" 29 . . 0 . 14678 43160 20269 "511210" "511210" "339930" "7372" "3944" "More Personal Computing"     "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 27 . . 0 . 13359 26430 20269 "511210" "511210" "519130" "7372" "7375" "Productivity and Business"   "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 21 . . 0 . -9736   275 20269 "511210" ""       ""       ""     ""     "Corporate & Other"           "PD_SRVC" "7372" "511210"
"012141" "GEOSEG" 14 . . . .     .     . 19904 "511210" ""       ""       ""     ""     "Finland"                     "MARKET"  "7372" "511210"
"012141" "GEOSEG" 12 . . 0 .     . 43359 19904 "511210" ""       ""       ""     ""     "Other Countries"             "MARKET"  "7372" "511210"
"012141" "GEOSEG"  1 . . 0 .     . 43474 19904 "511210" ""       ""       ""     ""     "United States"               "MARKET"  "7372" "511210"
"012141" "BUSSEG" 29 . . 0 .  5732 38460 19904 "511210" "511210" "339930" "7372" "3944" "More Personal Computing"     "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 27 . . 0 . 14173 26976 19904 "511210" "511210" "519130" "7372" "7375" "Productivity and Business"   "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 21 . . 0 .  -465  -338 19904 "511210" ""       ""       ""     ""     "Corporate & Other"           "PD_SRVC" "7372" "511210"
"012141" "GEOSEG" 14 . . . .     .     . 20269 "511210" ""       ""       ""     ""     "Finland"                     "MARKET"  "7372" "511210"
"012141" "GEOSEG" 13 . . . .     .     . 20269 "511210" ""       ""       ""     ""     "Luxembourg"                  "MARKET"  "7372" "511210"
"012141" "GEOSEG" 12 . . 0 .     . 50639 20269 "511210" ""       ""       ""     ""     "Other Countries"             "MARKET"  "7372" "511210"
"012141" "GEOSEG"  1 . . 0 .     . 42941 20269 "511210" ""       ""       ""     ""     "United States"               "MARKET"  "7372" "511210"
"012141" "BUSSEG" 26 . . 0 .     . 10836 20269 "511210" "541512" "519130" "7379" "7375" "Commercial - Other"          "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 24 . . 0 .     .  8825 20269 "511210" "511210" "519130" "7372" "7375" "D & C - Other"               "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 23 . . 0 .     .  7524 20269 "511210" "334210" ""       "3661" ""     "D & C - Phone Hardware"      "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 22 . . 0 .     . 14969 20269 "511210" "511210" ""       "7372" ""     "D & C - Licensing"           "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 20 . . 0 .     . 10183 20269 "511210" "339930" "511210" "3944" "7372" "D & C - Computing & Gaming"  "PD_SRVC" "7372" "511210"
"012141" "GEOSEG" 14 . . . .     .     . 19904 "511210" ""       ""       ""     ""     "Finland"                     "MARKET"  "7372" "511210"
"012141" "GEOSEG" 13 . . . .     .     . 19904 "511210" ""       ""       ""     ""     "Luxembourg"                  "MARKET"  "7372" "511210"
"012141" "GEOSEG"  1 . . 0 .     . 43474 19904 "511210" ""       ""       ""     ""     "United States"               "MARKET"  "7372" "511210"
"012141" "BUSSEG" 26 . . 0 .     .  7546 19904 "511210" "541512" "519130" "7379" "7375" "Commercial - Other"          "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 25 . . 0 .     . 42085 19904 "511210" "511210" "519130" "7372" "7375" "Commercial - Licensing"      "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 24 . . 0 .     .  7014 19904 "511210" "511210" "519130" "7372" "7375" "D & C - Other"               "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 23 . . 0 .     .  1982 19904 "511210" "334210" ""       "3661" ""     "D & C - Phone Hardware"      "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 22 . . 0 .     . 19528 19904 "511210" "511210" ""       "7372" ""     "D & C - Licensing"           "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 21 . . 0 . -4422  -415 19904 "511210" ""       ""       ""     ""     "Corporate & Other"           "PD_SRVC" "7372" "511210"
"012141" "GEOSEG" 14 . . . .     .     . 19539 "511210" ""       ""       ""     ""     "Finland"                     "MARKET"  "7372" "511210"
"012141" "GEOSEG" 13 . . . .     .     . 19539 "511210" ""       ""       ""     ""     "Luxembourg"                  "MARKET"  "7372" "511210"
"012141" "GEOSEG" 12 . . 0 .     . 36505 19539 "511210" ""       ""       ""     ""     "Other Countries"             "MARKET"  "7372" "511210"
"012141" "BUSSEG" 26 . . 0 .     .  5661 19539 "511210" "541512" "519130" "7379" "7375" "Commercial - Other"          "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 25 . . 0 .     . 39778 19539 "511210" "511210" "519130" "7372" "7375" "Commercial - Licensing"      "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 24 . . 0 .     .  6431 19539 "511210" "511210" "519130" "7372" "7375" "D & C - Other"               "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 22 . . 0 .     . 19427 19539 "511210" "511210" ""       "7372" ""     "D & C - Licensing"           "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 21 . . 0 . -3789   403 19539 "511210" ""       ""       ""     ""     "Corporate & Other"           "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 20 . . 0 .     .  6149 19539 "511210" "339930" "511210" "3944" "7372" "D & C - Computing & Gaming"  "PD_SRVC" "7372" "511210"
"012141" "GEOSEG" 14 . . . .     .     . 19904 "511210" ""       ""       ""     ""     "Finland"                     "MARKET"  "7372" "511210"
"012141" "GEOSEG" 13 . . . .     .     . 19904 "511210" ""       ""       ""     ""     "Luxembourg"                  "MARKET"  "7372" "511210"
"012141" "GEOSEG" 12 . . 0 .     . 43359 19904 "511210" ""       ""       ""     ""     "Other Countries"             "MARKET"  "7372" "511210"
"012141" "GEOSEG"  1 . . 0 .     . 43474 19904 "511210" ""       ""       ""     ""     "United States"               "MARKET"  "7372" "511210"
"012141" "BUSSEG" 25 . . 0 .     . 42027 19904 "511210" "511210" "519130" "7372" "7375" "Commercial - Licensing"      "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 24 . . 0 .     .  7258 19904 "511210" "511210" "519130" "7372" "7375" "D & C - Other"               "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 23 . . 0 .     .  1985 19904 "511210" "334210" ""       "3661" ""     "D & C - Phone Hardware"      "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 21 . . 0 . -4422  -415 19904 "511210" ""       ""       ""     ""     "Corporate & Other"           "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 20 . . 0 .     .  9628 19904 "511210" "339930" "511210" "3944" "7372" "D & C - Computing & Gaming"  "PD_SRVC" "7372" "511210"
"012141" "GEOSEG" 14 . . . .     .     . 19539 "511210" ""       ""       ""     ""     "Finland"                     "MARKET"  "7372" "511210"
"012141" "GEOSEG" 12 . . 0 .     . 36505 19539 "511210" ""       ""       ""     ""     "Other Countries"             "MARKET"  "7372" "511210"
"012141" "GEOSEG"  1 . . 0 .     . 41344 19539 "511210" ""       ""       ""     ""     "United States"               "MARKET"  "7372" "511210"
"012141" "BUSSEG" 26 . . 0 .     .  5660 19539 "511210" "541512" "519130" "7379" "7375" "Commercial - Other"          "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 25 . . 0 .     . 39686 19539 "511210" "511210" "519130" "7372" "7375" "Commercial - Licensing"      "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 24 . . 0 .     .  6618 19539 "511210" "511210" "519130" "7372" "7375" "D & C - Other"               "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 23 . . 0 .     .     0 19539 "511210" "334210" ""       "3661" ""     "D & C - Phone Hardware"      "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 22 . . 0 .     . 19021 19539 "511210" "511210" ""       "7372" ""     "D & C - Licensing"           "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 20 . . 0 .     .  6461 19539 "511210" "339930" "511210" "3944" "7372" "D & C - Computing & Gaming"  "PD_SRVC" "7372" "511210"
"012141" "GEOSEG" 14 . . . .     .     . 19174 "511210" ""       ""       ""     ""     "Finland"                     "MARKET"  "7372" "511210"
"012141" "GEOSEG" 13 . . . .     .     . 19174 "511210" ""       ""       ""     ""     "Luxembourg"                  "MARKET"  "7372" "511210"
"012141" "GEOSEG"  1 . . 0 .     . 38846 19174 "511210" ""       ""       ""     ""     "United States"               "MARKET"  "7372" "511210"
"012141" "BUSSEG" 26 . . 0 .     .  4644 19174 "511210" "541512" "519130" "7379" "7375" "Commercial - Other"          "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 25 . . 0 .     . 37126 19174 "511210" "511210" "519130" "7372" "7375" "Commercial - Licensing"      "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 23 . . 0 .     .     0 19174 "511210" "334210" ""       "3661" ""     "D & C - Phone Hardware"      "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 22 . . 0 .     . 19495 19174 "511210" "511210" ""       "7372" ""     "D & C - Licensing"           "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 21 . . 0 . -4266  -485 19174 "511210" ""       ""       ""     ""     "Corporate & Other"           "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 20 . . 0 .     .  6740 19174 "511210" "339930" "511210" "3944" "7372" "D & C - Computing & Gaming"  "PD_SRVC" "7372" "511210"
"012141" "GEOSEG" 13 . . 0 .     .     0 19539 "511210" "511210" "339930" "7372" "3944" "Luxembourg"                  "MARKET"  "7372" "511210"
"012141" "GEOSEG" 12 . . 0 .     . 36505 19539 "511210" "511210" "339930" "7372" "3944" "Other Countries"             "MARKET"  "7372" "511210"
"012141" "GEOSEG"  1 . . 0 .     . 41344 19539 "511210" "511210" "339930" "7372" "3944" "United States"               "MARKET"  "7372" "511210"
"012141" "BUSSEG" 20 . . 0 .   888 10213 19539 "511210" "339930" "511210" "3944" "7372" "Entertainment & Devices"     "DIV"     "7372" "511210"
"012141" "BUSSEG" 19 . . 0 . 16189 24738 19539 "511210" "511210" ""       "7372" ""     "Microsoft Business Division" "DIV"     "7372" "511210"
"012141" "BUSSEG" 18 . . 0 . -1298  3284 19539 "511210" "511210" ""       "7372" ""     "Online Services Division"    "DIV"     "7372" "511210"
"012141" "BUSSEG" 21 . . 0 . -5377   639 19539 "511210" ""       ""       ""     ""     "Corporate & Other"           "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 12 . . 0 .  8152 20295 19539 "511210" "511210" ""       "7372" ""     "Server and Tools"            "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 11 . . 0 .  8943 18680 19539 "511210" "511210" ""       "7372" ""     "Windows Division"            "DIV"     "7372" "511210"
"012141" "GEOSEG" 13 . . . .     .     . 19174 "511210" "511210" "339930" "7372" "3944" "Luxembourg"                  "MARKET"  "7372" "511210"
"012141" "GEOSEG" 12 . . 0 .     . 34877 19174 "511210" "511210" "339930" "7372" "3944" "Other Countries"             "MARKET"  "7372" "511210"
"012141" "GEOSEG"  1 . . 0 .     . 38846 19174 "511210" "511210" "339930" "7372" "3944" "United States"               "MARKET"  "7372" "511210"
"012141" "BUSSEG" 21 . . 0 . -5565  -272 19174 "511210" ""       ""       ""     ""     "Corporate & Other"           "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 20 . . 0 .   381  9590 19174 "511210" "339930" "511210" "3944" "7372" "Entertainment & Devices"     "DIV"     "7372" "511210"
"012141" "BUSSEG" 19 . . 0 . 15803 24082 19174 "511210" "511210" ""       "7372" ""     "Microsoft Business Division" "DIV"     "7372" "511210"
"012141" "BUSSEG" 24 . . 0 .     .  6203 19174 "511210" "511210" "519130" "7372" "7375" "D & C - Other"               "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 18 . . 0 . -8117  2935 19174 "511210" "511210" ""       "7372" ""     "Online Services Division"    "DIV"     "7372" "511210"
"012141" "BUSSEG" 12 . . 0 .  7256 18544 19174 "511210" "511210" ""       "7372" ""     "Server and Tools"            "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 11 . . 0 . 12005 18844 19174 "511210" "511210" ""       "7372" ""     "Windows Division"            "DIV"     "7372" "511210"
"012141" "GEOSEG" 12 . . 0 .     . 31935 18808 "511210" "511210" "339930" "7372" "3944" "Other Countries"             "MARKET"  "7372" "511210"
"012141" "GEOSEG" 12 . . 0 .     . 34877 19174 "511210" ""       ""       ""     ""     "Other Countries"             "MARKET"  "7372" "511210"
"012141" "GEOSEG"  1 . . 0 .     . 38008 18808 "511210" "511210" "339930" "7372" "3944" "United States"               "MARKET"  "7372" "511210"
"012141" "BUSSEG" 21 . . 0 . -4128   574 18808 "511210" ""       ""       ""     ""     "Corporate & Other"           "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 21 . . 0 . -3789   403 19539 "511210" ""       ""       ""     ""     "Corporate & Other"           "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 20 . . 0 .  1299  8896 18808 "511210" "339930" "511210" "3944" "7372" "Entertainment & Devices"     "DIV"     "7372" "511210"
"012141" "BUSSEG" 19 . . 0 . 14467 22407 18808 "511210" "511210" ""       "7372" ""     "Microsoft Business Division" "DIV"     "7372" "511210"
"012141" "BUSSEG" 18 . . 0 . -2649  2680 18808 "511210" "511210" ""       "7372" ""     "Online Services Division"    "DIV"     "7372" "511210"
end
format %d datadate

i am using Stata 14.2 and i picked microsoft to make it somewhat easier to comprehend.

It would be very helpfull if someone has some suggestions and i hope i followed the structure that is advised in the FAQ.

Kind regards,

Remy Dalmulder
University of Amsterdam - student

[Nick Cox]

Thanks for the data example, but otherwise I can't make sense of this.

I understand the words "Business" "Geographic" and "Segment" but not what "Business Segment" and "Geographic Segment" mean here or why each observation is one or the other. Nor can I relate your data example to your regression as neither busseg nor geoseg is a variable in your data example. If it's a matter of being one or the other, then that would be a single indicator variable and logarithms would not be used.

When people ask broadly similar questions, one answer is to direct them to this series, which

search distinct, sj

will reveal.

SJ-15-3 dm0042_2  . . . . . . . . . . . . . . . . Software update for distinct
        (help distinct if installed)  . . . . . .  N. J. Cox and G. M. Longton
        Q3/15   SJ 15(3):899
        improved table format and display of large numbers of
        observations

SJ-12-2 dm0042_1  . . . . . . . . . . . . . . . . Software update for distinct
        (help distinct if installed)  . . . . . .  N. J. Cox and G. M. Longton
        Q2/12   SJ 12(2):352
        options added to restrict output to variables with a minimum
        or maximum of distinct values

SJ-8-4  dm0042  . . . . . . . . . . . .  Speaking Stata: Distinct observations
        (help distinct if installed)  . . . . . .  N. J. Cox and G. M. Longton
        Q4/08   SJ 8(4):557--568
        shows how to answer questions about distinct observations
        from first principles; provides a convenience command

Here the last 2008 reference is accessible at http://www.stata-journal.com/sjpdf.h...iclenum=dm0042 and the software should be installed from the latest 2015 reference if it seems helpful.

[Remy Dalmulder]

My regression is a copy from

Alali, F. (2011). Audit fees and discretionary accruals: compensation structure effect. Managerial Auditing Journal, 26(2), 90-113.

Within this paper she clarifies that the complexity of a a firm is calculated through the log of total assets, log of the business segments ( busseg) and the log of geographical assets ( geoseg).

[Remy Dalmulder]

And thanks for the code, i will look into that.

[Nick Cox]

Sorry, but I am not much wiser. Perhaps you should be aggregating somehow. Perhaps people nearer to your field than I am can work out what you should be doing.

[Remy Dalmulder]

Sorry for the inconvenience. I just started working with Stata as my university first learned us to work with SPSS... Thus, resulting in these incomprehensive questions:P

Thank you for your time

[Remy Dalmulder]

Oke, i hope this helps. I used the annual report of microsoft and i found the following:

Year Ended June 30,	2016		2015		2014
Revenue
Productivity and Business Processes	$26,487		$26,430		$26,976
Intelligent Cloud	25,042		23,715		21,735
More Personal Computing	40,460		43,160		38,460
Corporate and Other	(6,669)		275		(338)
Total revenue	$85,320		$93,580		$86,833

This means there are a total of 4 business segments. From compustat i have the following:

* Example generated by -dataex-. To install: ssc install dataex
clear
input str6 gvkey str8 stype double(sid capxs ias intseg nis ops sales) long(datadate srcdate) str6(naicsh naicss1 naicss2) str4(sics1 sics2) str244 snms str8 soptp1 str4 sic str6 naics
"012141" "GEOSEG" 14 . . . .      .     . 20635 20635 "511210" ""       ""       ""     ""     "Finland"                    "MARKET"  "7372" "511210"
"012141" "GEOSEG" 12 . . 0 .      . 44742 20635 20635 "511210" ""       ""       ""     ""     "Other Countries"            "MARKET"  "7372" "511210"
"012141" "GEOSEG"  1 . . 0 .      . 40578 20635 20635 "511210" ""       ""       ""     ""     "United States"              "MARKET"  "7372" "511210"
"012141" "BUSSEG" 29 . . 0 .   7252 40460 20635 20635 "511210" "511210" "339930" "7372" "3944" "More Personal Computing"    "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 28 . . 0 .   9358 25042 20635 20635 "511210" "511210" "519130" "7372" "7375" "Intelligent Cloud"          "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 27 . . 0 .  12461 26487 20635 20635 "511210" "511210" "519130" "7372" "7375" "Productivity and Business"  "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 21 . . 0 .  -7779 -6669 20635 20635 "511210" ""       ""       ""     ""     "Corporate & Other"          "PD_SRVC" "7372" "511210"
"012141" "GEOSEG" 14 . . . .      .     . 20269 20635 "511210" ""       ""       ""     ""     "Finland"                    "MARKET"  "7372" "511210"
"012141" "GEOSEG" 12 . . 0 .      . 50639 20269 20635 "511210" ""       ""       ""     ""     "Other Countries"            "MARKET"  "7372" "511210"
"012141" "GEOSEG"  1 . . 0 .      . 42941 20269 20635 "511210" ""       ""       ""     ""     "United States"              "MARKET"  "7372" "511210"
"012141" "BUSSEG" 29 . . 0 .  14678 43160 20269 20635 "511210" "511210" "339930" "7372" "3944" "More Personal Computing"    "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 27 . . 0 .  13359 26430 20269 20635 "511210" "511210" "519130" "7372" "7375" "Productivity and Business"  "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 21 . . 0 .  -9736   275 20269 20635 "511210" ""       ""       ""     ""     "Corporate & Other"          "PD_SRVC" "7372" "511210"
"012141" "GEOSEG" 14 . . . .      .     . 20269 20269 "511210" ""       ""       ""     ""     "Finland"                    "MARKET"  "7372" "511210"
"012141" "GEOSEG" 12 . . 0 .      . 50639 20269 20269 "511210" ""       ""       ""     ""     "Other Countries"            "MARKET"  "7372" "511210"
"012141" "GEOSEG"  1 . . 0 .      . 42941 20269 20269 "511210" ""       ""       ""     ""     "United States"              "MARKET"  "7372" "511210"
"012141" "BUSSEG" 26 . . 0 .      . 10836 20269 20269 "511210" "541512" "519130" "7379" "7375" "Commercial - Other"         "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 24 . . 0 .      .  8825 20269 20269 "511210" "511210" "519130" "7372" "7375" "D & C - Other"              "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 23 . . 0 .      .  7524 20269 20269 "511210" "334210" ""       "3661" ""     "D & C - Phone Hardware"     "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 22 . . 0 .      . 14969 20269 20269 "511210" "511210" ""       "7372" ""     "D & C - Licensing"          "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 20 . . 0 .      . 10183 20269 20269 "511210" "339930" "511210" "3944" "7372" "D & C - Computing & Gaming" "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 21 . . 0 . -13567   204 20269 20269 "511210" ""       ""       ""     ""     "Corporate & Other"          "PD_SRVC" "7372" "511210"
"012141" "BUSSEG" 25 . . 0 .      . 41039 20269 20269 "511210" "511210" "519130" "7372" "7375" "Commercial - Licensing"     "PD_SRVC" "7372" "511210"
"012141" "GEOSEG" 13 . . . .      .     . 20269 20269 "511210" ""       ""       ""     ""     "Luxembourg"                 "MARKET"  "7372" "511210"
"012141" "BUSSEG" 28 . . 0 .   9871 23715 20269 20635 "511210" "511210" "519130" "7372" "7375" "Intelligent Cloud"          "PD_SRVC" "7372" "511210"
"012141" "GEOSEG" 13 . . . .      .     . 20269 20635 "511210" ""       ""       ""     ""     "Luxembourg"                 "MARKET"  "7372" "511210"
"012141" "GEOSEG" 13 . . . .      .     . 20635 20635 "511210" ""       ""       ""     ""     "Luxembourg"                 "MARKET"  "7372" "511210"
end
format %d datadate
format %d srcdate

You can clearly see the sales matching between the annual report and compustat. I want to extract that in 2016 there where a total of 4 business segments.

Kind regards,

Remy