libname definitions:
icq = industrial compustat quarterly
icqr = industrial compustat research quarterly
Note: icqr has same format as icq.
Data Set Name: ICQ.DATA SAS Engine: v8
Variable Type Description
-----------------------------------------------------------------------------------------------------------
CIC Char CUSIP ISSUE NUMBER AND CHECK DIGIT
CNUM Char CUSIP ISSUER CODE
CUSIP Char CUSIP IDENTIFIER
D1 Num SELLING, GENERAL, AND ADMINISTRATIVE EXPENSES
D2 Num SALES (NET)
D3 Num MINORITY INTEREST (INCOME ACCOUNT)
D4 Num RESEARCH AND DEVELOPMENT EXPENSE
D5 Num DEPRECIATION AND AMORTIZATION
D6 Num INCOME TAXES - TOTAL
D7 Num EARNINGS PER SHARE (FUNNY DILUTED) - INCLUDING EXTRAORDINARY ITEMS
D8 Num INCOME BEFORE EXTRAORDINARY ITEMS
D9 Num EARNINGS PER SHARE (FULLY DILUTED) - EXCLUDING EXTRAORDINARY ITEMS
D10 Num INCOME BEFORE EXTRAORDINARY ITEMS - ADJUSTED FOR COMMON STOCK EQUIVALENTS
D11 Num EARNINGS PER SHARE (PRIMARY) - INCLUDING EXTRAORDINARY ITEMS
D12 Num PRICE - CLOSE- FIRST MONTH OF QUARTER
D13 Num PRICE - CLOSE - SECOND MONTH OF QUARTER
D14 Num PRICE - CLOSE - THIRD MONTH OF QUARTER
D15 Num COMMON SHARES USED TO CALCULATE EARNINGS PER SHARE (PRIMARY)
D16 Num DIVIDENDS PER SHARE - EX-DATE
D17 Num ADJUSTMENT FACTOR (CUMULATIVE) - EX-DATE
D18 Num COMMON SHARES TRADED
D19 Num EARNINGS PER SHARE (PRIMARY) - EXCLUDING EXTRAORDINARY ITEMS
D20 Num DIVIDENDS - COMMON - INDICATED ANNUAL
D21 Num OPERATING INCOME BEFORE DEPRECIATION
D22 Num INTEST EXPENSE
D23 Num PRETAX INCOME
D24 Num DIVIDENDS - PREFERRED
D25 Num INCOME BEFORE EXTRAORDINARY ITEMS - AVAILABLE FOR COMMON
D26 Num EXTRAORDINARY ITEMS AND DISCONTINUED OPERATIONS
D27 Num EARNINGS PER SHARE (PRIMARY) - EXCLUDING EXTRAORDINARY ITEMS - 12 MONTH MOVING
D28 Num COMMON SHARES USED TO CALCULATE EARNINGS PER SHARE - 12 MONTHS MOVING
D29 Num BLANK
D30 Num COST OF GOODS SOLD
D31 Num NONOPERATING INCOME (EXPENSE)
D32 Num SPECIAL ITEMS
D33 Num DISCONTINUED OPERATIONS
D34 Num FOREIGN CURRENCY ADJUSTMENT (INCOME) ACCOUNT
D35 Num DEFERRED TAXES (INCOME ACCOUNT)
D36 Num CASH AND SHORT-TERM INVESTMENTS
D37 Num RECEIVABLES - TOTAL
D38 Num INVENTORIES - TOTAL
D39 Num CURRENT ASSETS - OTHER
D40 Num CURRENT ASSETS - TOTAL
D41 Num DEPRECIATION, DEPLETION, AND AMORTIZATION (ACCUMULATED) (BALANCE SHEET)
D42 Num PROPERTY, PLANT, AND EQUIPMENT - TOTAL (NET)
D43 Num ASSETS - OTHER
D44 Num ASSETS - TOTAL/LIABILITIES AND STOCKHOLDERS' EQUITY - TOTAL
D45 Num DEBT IN CURRENT LIABILITIES
D46 Num ACCOUNTS PAYABLES
D47 Num INCOME TAXES PAYABLE
D48 Num CURRENT LIABILITIES - OTHER
D49 Num CURRENT LIABILITIES - TOTAL
D50 Num LIABILITIES - OTHER
D51 Num LONG-TERM DEBT - TOTAL
D52 Num DEFERRED TAXES AND INVESTMENT TAX CREDIT (BALANCE SHEET)
D53 Num MINORITY INTEREST (BALANCE SHEET)
D54 Num LIABILITIES - TOTAL
D55 Num PREFERRED STOCK - CARRYING VALUE
D56 Num COMMON STOCK
D57 Num CAPITAL SURPLUS
D58 Num RETAINED EARNINGS
D59 Num COMMON EQUITY - TOTAL
D60 Num STOCKHOLDERS' EQUITY - TOTAL
D61 Num COMMON SHARES OUTSTANDING
D62 Num INVESTED CAPITAL - TOTAL
D63 Num PRICE - HIGH - FIRST MONTH OF QUARTER
D64 Num PRICE - HIGH SECOND MONTH OF QUARTER
D65 Num PRICE - HIGH THIRD MONTH OF QUARTER
D66 Num PRICE - LOW - FIRST MONTH OF QUARTER
D67 Num PRICE - LOW - SECOND MONTH OF QUARTER
D68 Num PRICE - LOW - THIRD MONTH OF QUARTER
D69 Num NET INCOME (LOSS)
D70 Num BLANK
D71 Num PREFERRED STOCK - REDEEMABLE
D72 Num DIVIDENDS PER SHARE - PAYABLE DATE
D73 Num WORKING CAPITAL CHANGES - OTHER - INCREASE (DECREASE) (STATEMENT OF CHANGES)
D74 Num CASH AND CASH EQUIVALENTS - INCREASE(DECREASE) (FLOW OF FUNDS STATEMENT)
D75 Num CHANGES IN CURRENT DEBT (FLOW OF FUNDS STATEMENT)
D76 Num INCOME BEFORE EXTRAORDINARY ITEMS (FLOW OF FUNDS STATEMENT)
D77 Num DEPRECIATION AND AMORTIZATION (FLOW OF FUNDS STATEMENT)
D78 Num EXTRAORDINARY ITEMS AND DISCONTINUED OPERATIONS (FLOW OF FUNDS STATEMENT)
D79 Num DEFERRED TAXES (FLOW OF FUNDS STATEMENT)
D80 Num EQUITY IN EARNINGS (FLOW OF FUNDS STATEMENT)
D81 Num FUNDS FROM OEPRATIONS - OTHER (FLOW OF FUNDS STATEMENT)
D82 Num FUNDS FROM OPERATIONS - TOTAL(STATEMENT OF CHANGES)
D83 Num SALE OF PROPERTY, PLANT, AND EQUIPMENT (FLOW OF FUNDS STATEMENT)
D84 Num SALE OF COMMON AND PREFERRED STOCK (FLOW OF FUNDS STAEMENT)
D85 Num SALE OF INVESTMENTS (FLOW OF FUNDS STATEMENT)
D86 Num LONG-TERM DEBT - ISSUANCE (FLOW OF FUNDS STATEMENT)
D87 Num LONG-TERM DEBT - ISSUANCE (FLOW OF FUNDS STATEMENT)
D88 Num SOURCES OF FUNDS - OTHER (STATEMENT OF CHANGES)
D89 Num CASH DIVIDENDS (FLOW OF FUNDS STATEMENT)
D90 Num CAPITAL EXPENDITURES (FLOW OF FUNDS STATEMENT)
D91 Num INCREASE IN INVESTMENTS (FLOW OF FUNDS STATEMENT)
D92 Num LONG-TERM DEBT - REDUCTION (FLOW OF FUNDS STATEMENT)
D93 Num PURCHASE OF COMMON AND PREFERRED STOCK (FLOW OF FUNDS STATEMENT)
D94 Num ACQUISITION (FLOW OF FUNDS STATEMENT)
D95 Num USES OF FUNDS - OTHER (STATEMENT OF CHANGES)
D96 Num USES OF FUNDS - TOTAL (STATEMENT OF CHANGES)
D97 Num BLANK
D98 Num TREASURY STOCK - TOTAL DOLLAR AMOUNT
D99 Num BLANK
D100 Num ADJUSTMENT FACTOR (CUMULATIVE) - PAYABLE DATE
D101 Num WORKING CAPITAL CHANGE - TOTAL (STATEMENT OF CHANGES)
D102 Num SALE OF PROPERTY, PLANT, AND EQUIPMENT AND SALE OF INVESTMENTS - LOSS (GAIN) (FLOW OF FUNDS STATEMENT)
D103 Num ACCOUNTS RECEIVABLE - DECREASE (INCREASE) (STATEMENT OF CASH FLOWS)
D104 Num INVENTORY -DECREASE(INCREASE) (STATEMENT OF CASH FLOWS)
D105 Num ACCOUNTS PAYABLE AND ACCRUED LIABILITIES - INCREASE (DECREASE) (STATEMENT OF CASH FLOWS)
D106 Num INCOME TAXES - ACCRUED - INCREASE(DECREASE) (STATEMENT OF CASH FLOWS)
D107 Num ASSETS AND LIABILITIES - OTHER (NET CHANGE) (STATEMENT OF CASH FLOWS)
D108 Num OPERATING ACTIVITIES - NET CASH FLOWS (STATEMENT OF CASH FLOWS)
D109 Num SHORT-TERM INVESTMENTS - CHANGE (STATEMENT OF CASH FLOWS)
D110 Num INVESTING ACTIVITIES - OTHER (STATEMENT OF CASH FLOWS)
D111 Num INVESTING ACTIVITIES - NET CASH FLOW (STATEMENT OF CASH FLOWS)
D112 Num FINANCING ACTIVITIES - OTHER (STATEMENT OF CASH FLOWS)
D113 Num FINANCING ACTIVITIES - NET CASH FLOW (STATEMENT OF CASH FLOWS)
D114 Num EXCHANGE RATE EFFECT (STATEMENT OF CASH FLOWS)
D115 Num INTEREST PAID - NET (STATEMENT OF CASH FLOWS)
D116 Num INCOME TAXES PAID (STATEMENT OF CASH FLOWS)
D117 Num ACCOUNTING CHANGES - CUMULATIVE EFFECT
D118 Num PROPERTY, PLANT, AND EQUIPMENT - TOTAL(GROSS)
D119 Num EXTRAORDINARY ITEMS
D120 Num COMMON STOCK EQUIVALENTS - DOLLAR SAVINGS
D121 Num CURRENCY TRANSLATION RATE
D122 Num ACCOUNTS PAYABLE
D123-170 Num BLANK
D171 Num PROVISION FOR LOAN/ASSET LOSSES
d172 Num RESERVE FOR LOAN/ASSET LOSSES
D173 Num MET INTERST MARGIN
D174 Num RISK-ADJUSTED CAPITAL RATIO - TIER 1
D175 Num RISK-ADJUSTED CAPITAL RATIO - TOTAL
D176 Num NET CHARGE-OFFS
D177 Num EARNINGS PER SHARE FROM OPERATIONS
D178 Num EARNINGS PER SHARE FROM OPERATIONS - 12 MONTH MOVING
D179-232 Num BLANK
DNUM Num INDUSTRY CLASSIFICATIN CODE
FORMAT Num FLOW OF FUNDS STATEMEENT FORMAT CODE
FTNT1-21 Char SEE "COMPUSTAT USER'S GUIDE"
FYR Num FISCAL YEAR
PFRNT1 Char PERIOD FOOTNOTE1
PFTNT2 Char PERIOD FOOTNOTE2
QTR Num QUARTER
RDOQE Num REPORT DATE OF QUARTERLY EARNINGS (YYDDD)
SOURCE Num SOURCE DOCUMENT CODE
SPBR Num SP LONG TREM DOMESTIC ISSUER CREDIT RATING
SPCOD Num BLANK
SPCPR Num SP SHORT TREM DOMESTIC ISSUER CREDIT RATING
SPCSCQ Num SPCS CALENDAR QUARTER
SPCSCY Num SPCS CALENDAR YEAR
SPCSR Num SP COMMERCIAL STOCK RATING
SPIIC Num SP INDUSTRY INDEX CODE
SPMIC Num SP MAJOR INDEX CODE
SPSBR Num SP SUBORDINATED DEBT CODE
UCODE Num UPDATE CODE
YEAR Num DATA YEAR
===============================================================================================================
Data Set Name: ICQ.MASTER SAS ENGINE: V8
Variable Type Description
-----------------------------------------------------------------------------------------------------------
CIC Char CUSIP ISSUE NUMBER AND CHECK DIGIT
CNUM Char CUSIP ISSUER CODE
CONAME Char COMPANY NAME
COUNTRY Char COMPANY LOCATION - COUNTRY
CUSIP Char CUSIP IDENTIFIRE
DNUM Num INDUSTRY CLASSIFICATION CODE
EIN Char EMPLOYER IDENTIFICATION NUMBER
FINC Num INCORPORATION CODE - FOREIGN
INAME Char INDUSTRY NAME
SINC Num INCORPORATION CODE - STATE
SMBL Char STOCK TICKER SYMBOL
STATE Num COMPANY LOCATION - STATE
STK Num STOCK OWNER SHIP CODE
XREL Num SP INDUSTRY INDEX RELATIVE CODE
ZLIST Num EXCHANGE LISTING AND SP INDEX CODE
NAICS Char NORTH AMERICAN INDUSTRY CLASSIFIATION CODE
===============================================================================================================