W. P. Carey School of Business
 W. P. Carey      ASU
W. P. Carey Undergraduate MBA Masters/Ph.D. Professional Development Departments Faculty/Research
Technology@ W. P. Carey


Contact Info

Technical Assistance Center
Mon - Fri: 7 am - 9 pm
Sat - Sun: Emergency Only
480-965-2400
wpcarey.support@asu.edu

Software & Data - COMPUSTAT

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.



 

For further information, or to request this service, please contact the Technology Assistance Center
Mon - Fri: 7 am - 9 pm
Sat - Sun: Emergency Only
by phone at 480-965-2400 or by e-mail at wpcarey.support@asu.edu.

W. P. Carey Home   |   W. P. Carey Mission   |   Contact Us   |   Web Feedback   |   Sitemap   |   Privacy Policy
Copyright © 2009 ABOR