SAS/Ets User's Guide 64. Provides detailed reference material for using SAS/ETS software and guides you through the analysis and forecasting of features such as univariate and multivariate time series, cross-sectional time series, seasonal adjustments, multiequational nonlinear models, discrete choice models, limited dependent variable models, portfolio analysis, and generation of financial reports, with introductory and advanced examples for each procedure. You can also find complete information about two easy-to-use point-and-click applications: the Time Series Forecasting System, for automatic and interactive time series modeling and forecasting, and the Investment Analysis System, for time-value of money analysis of a variety of investments | 622 F Chapter 11 The DATASOURCE Procedure Example Annual COMPUSTAT Data Files New Filetype CSAUC3 Annual COMPUSTAT data in Universal Character format is read for PRICES since the year 2002 so that the desired output show the PRICE HIGH PRICE LOW and PRICE CLOSE for each company. filename datafile RECFM F LRECL 13612 ---------------------------------------------------------------- create OUT csauy3 data set with ASCII 2003 Industrial Data compare it with the OUT csauc data set created by DATA STEP --------------------------------------------------------------- proc datasource filetype csaucy3 ascii infile datafile interval year outselect on outkey y3key out csauy3 keep data197-data199 label range from 2002 run proc sort data csauy3 out csauy3 by dnum cnum cic file zlist smbl xrel stk run title1 Price High Low and Close for Range from 2002 proc contents data csauy3 run proc print data csauy3 run Output shows information on the contents of the CSAUY3 dataset while Output shows a listing of the CSAUY3 data set. Example Annual COMPUSTAT Data Files New Filetype CSAUC3 F 623 Output Listing of the CONTENTS of OUT CSAUY3 Data Set Price High Low and Close for Range from 2002 The CONTENTS Procedure Alphabetic List of Variables and Attributes Variable Type Len Format Label 3 CIC Char 3 2 CNUM Char 6 11 COUNTY Num 5 13 CPSPIN Char 1 15 CSSPII Char 1 14 CSSPIN Char 2 18 DATA197 Num 5 Price - Fiscal Year - High c NA 19 DATA198 Num 5 Price - Fiscal Year - Low c NA 20 DATA199 Num 5 Price - Close - Fiscal Year-End c NA 17 DATE Num 4 YEAR4. Date of Observation 1 DNUM Num 5 9 DUPFILE Num 5 16 EIN Char 10 4 FILE Num 5 12 FINC Num 5 6 SMBL Char 8 10 STATE Num 5 8 STK Num 5 7 XREL Num 5 5 ZLIST Num 5 624 F Chapter 11 The DATASOURCE Procedure Output Listing of the OUT CSAUY3 Data Set Price High Low and Close for Range from 2002 Obs DNUM CNUM CIC FILE ZLIST SMBL XREL STK DUPFILE STATE COUNTY FINC 1 3089 899896 104 11 1 TUP 444 0 0