General Information
- What is Compustat?
COMPUSTAT provides more than 300 annual and 100 quarterly
Income Statement, Balance Sheet, Statement of Cash Flows, and supplemental data items, on
approximately 10,000 actively traded companies and 8,000 inactive companies. It is a
product of Standard & Poor's which is a
division of McGraw-Hill, Inc. The industrial annual formats offer both historical and
restated data. The industrial quarterly formats offer restated data as reported by
the company. For most companies, annual information is available for a maximum of 20 years
and quarterly information is available for a maximum of 48 quarters.
- Research Insight is Compustat's PC
application. It provides a
Windows interface for accessing the Compustat data. Research Insight is available
on the W. P. Carey School of Business network. Note- The
variables may not be computed identically between
the two. See the Research
Insight page for more information.
- The Compustat files are available
on the WRDS Unix servers and the School of
Business network as SAS data
sets. To access the WRDS Unix servers, use SSH to
connect to wrds.wharton.upenn.edu . On the School
of Business network, they are located at K:\sas
data .
Compustat File Descriptions
| Industrial
|
Contains the largest companies on the
New York and American Stock exchanges, including all companies comprising the S&P
Industrial Index, and utility subsidiaries that were once S&P 500 constituents.
|
| Full
Coverage |
Contains NASDAQ companies, companies
listed on regional exchanges, publicly held companies trading common stock, and wholly
owned subsidiaries trading preferred stock or debt.
|
| Research
|
Contains companies that have deleted from
the Primary, Supplementary, Tertiary, Over-the-Counter, and Full-Coverage
files due to bankruptcy, acquisition or merger, leveraged buyout, or because they became
private companies.
|
| Business
Information / Industry Segment
|
The Business Information File is a companion to the industrial Annual files.
|
| Canadian
|
Contains more than 700 major Canadian
industrial companies that report in Canadian currency. Canadian companies are available in
Annual, Quarterly, and Prices, Dividends, and Earnings (PDE). COMPUSTAT as an add-on. You
have the choice of receiving Canadian Annual and Canadian Quarterly in the U.S. dollars or
Canadian dollars.
|
| Core
Earnings |
Contains
S&P core corporate earnings
|
| Index
Fundamentals |
Contains
financial data, per share data, and ratios
for the S&P Indexes
|
| Prices,
Dividends, and Earnings |
Contains
market information on all Compustat
industrial companies and more than 600
industry indexes and composites.
|
| Bank
|
Contains
650 banking companies with up to 20 years
and 48 qtrs of data.
|
Compustat data is available through the WRDS web
interface, on the WRDS Unix servers, and on the School of Business
network. The
current data files were created by Compustat on August 2004. Click
on each of the files below to see a listing of the data items available
in that dataset. Click on Data Codes
for a list of codes used in the SAS datasets to represent missing,
combined, insignificant, semi-annual, and annual figures.
Local W. P. Carey School of Business directory:
K:\SAS Data\
WRDS Unix server working directory: /wrds/compustat/sasdata/
| Data
Type |
Contents
|
SAS
Dataset |
| Industrial
|
Industrial
Annual, Combined |
compann.sas7bdat
|
| Industrial Annual,
Current |
ina.sas7bdat
|
| Industrial Annual,
Backdata |
inab1.sas7bdat
|
| Industrial Annual,
Wayback |
inab2.sas7bdat
|
| Industrial Quarterly,
Combined |
compqtr.sas7bdat
|
| Industrial Quarterly,
Current |
inq.sas7bdat
|
| Industrial Quarterly,
Backdata |
inqb1.sas7bdat
|
| Industrial Quarterly,
Wayback 1 |
inqb2.sas7bdat
|
| Industrial Quarterly,
Wayback 2 |
inqb3.sas7bdat
|
| Full
Coverage |
Full Coverage Annual,
Current |
fca.sas7bdat
|
| Full Coverage Annual,
Backdata |
fcab1.sas7bdat
|
| Full Coverage Annual,
Wayback |
fcab2.sas7bdat
|
| Full Coverage Quarterly,
Current |
fcq.sas7bdat
|
| Full Coverage Quarterly,
Backdata |
fcqb1.sas7bdat
|
| Full Coverage Quarterly,
Wayback 1 |
fcqb2.sas7bdat
|
| Full Coverage Quarterly,
Wayback 2 |
fcqb3.sas7bdat
|
| Research |
Research Annual,
Current |
res.sas7bdat
|
| Research Annual,
Backdata |
resb1.sas7bdat
|
| Research Annual,
Wayback |
resb2.sas7bdat
|
| Research Quarterly,
Current |
req.sas7bdat
|
| Research Quarterly,
Backdata |
reqb1.sas7bdat
|
| Research Quarterly,
Wayback 1 |
reqb2.sas7bdat
|
| Research Quarterly,
Wayback 2 |
reqb3.sas7bdat
|
|
Canadian |
Canadian Annual,
Current (in Canadian $) |
cia.sas7bdat
|
| Canadian Quarterly,
Current (in Canadian $) |
ciq.sas7bdat
|
|
Current Business Information
|
Segment Company,
Current |
scmpy.sas7bdat
|
| Segment Company,
Back |
scmpyb.sas7bdat
|
| Segment Company,
Research |
scmpyrb.sas7bdat
|
| Segment Currency
Rate, Current |
scurr.sas7bdat
|
| Segment Customer,
Current |
scust.sas7bdat
|
| Segment Customer,
Back |
scustb.sas7bdat
|
| Segment Customer,
Research |
scustrb.sas7bdat
|
|
Segment
Detail, Current
|
sdtail.sas7bdat
|
|
Segment
Detail, Back
|
sdtailb.sas7bdat
|
|
Segment
Detail, Research
|
sdtailrb.sas7bdat
|
|
Segment Item
Value, Current
|
sitem.sas7bdat
|
|
Segment Item
Value, Back
|
sitemb.sas7bdat
|
|
Segment Item
Value, Research
|
sitemrb.sas7bdat
|
|
Segment NAICS,
Current
|
snaics.sas7bdat
|
|
Segment
NAICS, Back
|
snaicsb.sas7bdat
|
|
Segment NAICS,
Research
|
snaicsrb.sas7bdat
|
|
Segment
Products, Current
|
sprod.sas7bdat
|
|
Segment
Source, Current
|
ssrce.sas7bdat
|
|
Segment
Products, Back
|
ssrceb.sas7bdat
|
|
Segment
Products, Research
|
ssrcerb.sas7bdat
|
|
Segment Geo
Area Codes, Current
|
sgeocd.sas7bdat
|
|
Segment Geo
Area Codes, Back
|
sgeocdb.sas7bdat
|
|
Segment Geo
Area Codes, Research
|
sgeocdrb.sas7bdat
|
|
Core Earnings
|
Core Earnings, Annual
|
coreann.sas7bdat
|
| Expanded Core Earnings,
Annual |
expann.sas7bdat
|
| Core Earnings, Quarterly
|
coreqtr.sas7bdat
|
| Expanded Core Earnings,
Quarterly |
expqtr.sas7bdat
|
|
Index Fundamentals
|
Index Fundamentals,
Annual
|
ifa.sas7bdat
|
| Prices,
Dividends, and Earnings |
PDE
|
pde.sas7bdat
|
|
Bank
|
Bank Annual
|
bna.sas7bdat
|
| Bank Quarterly |
bnq.sas7bdat |
NOTE: The current Compustat SAS dataset
names are based on the WRDS naming convention. This differs
from the default names given to the raw datafiles by
Compustat. For a
table comparing the Compustat file names to the WRDS SAS
file names, click here.
|