The DATASOURCE Procedure
- Overview
-
Getting Started
Structure of a SAS Data Set Containing Time Series DataReading Data FilesSubsetting Input Data FilesControlling the Frequency of Data – The INTERVAL= OptionSelecting Time Series Variables – The KEEP and DROP StatementsControlling the Time Range of Data – The RANGE StatementReading in Data Files Containing Cross SectionsObtaining Descriptive Information on Cross SectionsSubsetting a Data File Containing Cross SectionsRenaming Time Series VariablesChanging the Lengths of Numeric Variables -
Syntax
-
Details
-
ExamplesBEA National Income and Product AccountsBLS Consumer Price Index SurveysBLS State and Area Employment, Hours, and Earnings SurveysDRI/McGraw-Hill Format CITIBASE FilesDRI Data Delivery Service DatabasePC Format CITIBASE DatabaseQuarterly COMPUSTAT Data FilesAnnual COMPUSTAT Data Files, V9.2 New Filetype CSAUC3CRSP Daily NYSE/AMEX Combined Stocks
- References
The KEEPEVENT statement specifies which event variables in the data file are to be included in the OUTEVENT= data set. As a result, the KEEPEVENT statement is valid only for data files containing event-oriented time series data. All the BY variables, the time ID variable DATE, and the event-grouping variable EVENT are always included in the OUTEVENT= data set. These variables cannot be referenced in the KEEPEVENT statement. If any of these variables are referenced, a warning message is given and the reference is ignored.
The variable list can contain variable names or name range specifications. See Variable Lists for details.
Only one KEEPEVENT or one DROPEVENT statement can be used. KEEPEVENT and DROPEVENT are mutually exclusive.
You can also use the KEEP= data set option to control which event variables to include in the OUTEVENT= data set. However, the KEEPEVENT statement differs from the KEEP= data set option in several respects:
-
The KEEPEVENT statement selection is applied before variables are read from the data file, while the KEEP= data set option selection is applied after variables are read and as they are written to the OUTEVENT= data set. Therefore, using the KEEPEVENT statement instead of the KEEP= data set option is much more efficient.
-
If the KEEPEVENT statement causes no event variables to be selected, then no observations are output to the OUTEVENT= data set.