|
Software & Data - COMPUSTAT Data Files
| WRDS uses a unique naming convention for its SAS Compustat data files. These names differ from those used by Compustat for the data files they provide. Below is a table listing the WRDS names and the equivalent Compustat names.
| Data Type |
Contents |
WRDS Name
(CURRENT data)
|
OLD Compustat file name (2001 data) |
OLD Compustat Cross-section Name (2001 data) |
| Industrial |
Industrial Annual, Combined |
compann.sas7bdat |
(none) |
(none) |
| Industrial Annual, Current (1982-Current) |
ina.sas7bdat |
pstann.sas7bdat |
pstannx.sas7bdat |
| Industrial Annual, Backdata (1963-1982) |
inab1.sas7bdat |
pstanbak.sas7bdat |
pstanbakx.sas7bdat |
| Industrial Annual, Wayback (1950-1969) |
inab2.sas7bdat |
pstanway.sas7bdat
|
pstanwayx.sas7bdat
|
| Industrial Quarterly, Combined |
compqtr.sas7bdat |
(none) |
(none) |
| Industrial Quarterly, Current (1992-Current) |
inq.sas7bdat |
pstqtr.sas7bdat
|
pstqtrx.sas7bdat
|
| Industrial Quarterly, Backdata (1981-1992) |
inqb1.sas7bdat |
(none) |
(none) |
| Industrial Quarterly, Wayback 1 (1970-1981) |
inqb2.sas7bdat |
(none) |
(none) |
| Industrial Quarterly, Wayback 2 (1962-1973) |
inqb3.sas7bdat |
(none) |
(none) |
| Full Coverage |
Full Coverage Annual, Current |
fca.sas7bdat |
fullann.sas7bdat
|
fullannx.sas7bdat
|
| Full Coverage Annual, Backdata |
fcab1.sas7bdat |
fulanbak.sas7bdat
|
fulanbakx.sas7bdat |
| Full Coverage Annual, Wayback |
fcab2.sas7bdat |
fulanway.sas7bdat
|
fulanwayx.sas7bdat
|
| Full Coverage Quarterly, Current |
fcq.sas7bdat |
fullqtr.sas7bdat
|
fullqtrx.sas7bdat
|
| Full Coverage Quarterly, Backdata |
fcqb1.sas7bdat |
(none) |
(none) |
| Full Coverage Quarterly, Wayback 1 |
fcqb2.sas7bdat |
(none) |
(none) |
| Full Coverage Quarterly, Wayback 2 |
fcqb3.sas7bdat |
(none) |
(none) |
| Research |
Research Annual, Current |
res.sas7bdat |
mrgannr.sas7bdat |
mrgannrx.sas7bdat |
| Research Annual, Backdata |
resb1.sas7bdat |
resanbak.sas7bdat |
resanbakx.sas7bdat |
| Research Annual, Wayback |
resb2.sas7bdat |
resanway.sas7bdat |
resanwayx.sas7bdat |
| Research Quarterly, Current |
req.sas7bdat |
(none) |
(none) |
| Research Quarterly, Backdata |
reqb1.sas7bdat |
(none) |
(none) |
| Research Quarterly, Wayback 1 |
reqb2.sas7bdat |
(none) |
(none) |
| Research Quarterly, Wayback 2 |
reqb3.sas7bdat |
(none) |
(none) |
| Canadian |
Canadian Annual, Current (in Canadian $) |
cia.sas7bdat |
cdnann.sas7bdat
|
cdnannx.sas7bdat
|
| Canadian Quarterly, Current (in Canadian $) |
ciq.sas7bdat |
cdnqtr.sas7bdat
|
cdnqtrx.sas7bdat
|
| Current Business Information |
Segment Company, Current |
scmpy.sas7bdat |
scmpy.sas7bdat |
(none) |
| Segment Company, Back |
scmpyb.sas7bdat |
(none) |
(none) |
| Segment Company, Research |
scmpyrb.sas7bdat |
(none) |
(none) |
| Segment Currency Rate, Current |
scurr.sas7bdat |
scurr.sas7bdat |
(none) |
| Segment Customer, Current |
scust.sas7bdat |
scust.sas7bdat |
(none) |
| Segment Customer, Back |
scustb.sas7bdat |
(none) |
(none) |
| Segment Customer, Research |
scustrb.sas7bdat |
(none) |
(none) |
| Segment Detail, Current |
sdtail.sas7bdat |
sdtail.sas7bdat |
(none) |
| Segment Detail, Back |
sdtailb.sas7bdat |
(none) |
(none) |
| Segment Detail, Research |
sdtailrb.sas7bdat |
(none) |
(none) |
| Segment Item Value, Current |
sitem.sas7bdat |
sitem.sas7bdat |
(none) |
| Segment Item Value, Back |
sitemb.sas7bdat |
(none) |
(none) |
| Segment Item Value, Research |
sitemrb.sas7bdat |
(none) |
(none) |
| Segment NAICS, Current |
snaics.sas7bdat |
snaics.sas7bdat |
(none) |
| Segment NAICS, Back |
snaicsb.sas7bdat |
(none) |
(none) |
| Segment NAICS, Research |
snaicsrb.sas7bdat |
(none) |
(none) |
| Segment Products, Current |
sprod.sas7bdat |
sprod.sas7bdat |
(none) |
| Segment Source, Current |
ssrce.sas7bdat |
ssrce.sas7bdat |
(none) |
| Segment Products, Back |
ssrceb.sas7bdat |
(none) |
(none) |
| Segment Products, Research |
ssrcerb.sas7bdat |
(none) |
(none) |
| Segment Geo Area Codes, Current |
sgeocd.sas7bdat |
sgeocd.sas7bdat |
(none) |
| Segment Geo Area Codes, Back |
sgeocdb.sas7bdat |
(none) |
(none) |
| Segment Geo Area Codes, Research |
sgeocdrb.sas7bdat |
(none) |
(none) |
| Core Earnings |
Core Earnings, Annual |
coreann.sas7bdat |
(none) |
(none) |
| Expanded Core Earnings, Annual |
expann.sas7bdat |
(none) |
(none) |
| Core Earnings, Quarterly |
coreqtr.sas7bdat |
(none) |
(none) |
| Expanded Core Earnings, Quarterly |
expqtr.sas7bdat |
(none) |
(none) |
| Index Fundamentals |
Index Fundamentals, Annual |
ifa.sas7bdat |
(none) |
(none) |
| Prices, Dividends, and Earnings |
PDE |
pde.sas7bdat |
(none) |
(none) |
| Bank |
Bank Annual |
bna.sas7bdat |
(none) |
(none) |
| Bank Quarterly |
bnq.sas7bdat |
(none) |
(none) |
|
|
|
