Depending on your sample of companies, you can use:
- CompuStat Segments: available in Wharton Research Data Service under the link CompuStat. This database has only data for North American companies.
You have to select the kind of segment (Business, Geographic, Operating or State) you are looking for. Don’t forget to mark the items under Segment Description and Segment Industry codes.
- WorldScope: available in the Excel add-in of Datastream.
When you use the Datastream Excel add-in, select datatypes choose equities “WorldScope” and use the search term “Product segments”. Then you can select Product Segment 1 Description, Product Segment 1 SIC, Product Segment 1 Sales etc. There are 10 product segments, but most companies don’t have that many segments.
In both cases you can’t select the SIC-codes yourself, the companies are always the startpoint.