The DATASOURCE Procedure
- Overview
-
Getting Started
Structure of a SAS Data Set Containing Time Series Data Reading Data Files Subsetting Input Data Files Controlling the Frequency of Data – The INTERVAL= Option Selecting Time Series Variables – The KEEP and DROP Statements Controlling the Time Range of Data – The RANGE Statement Reading in Data Files Containing Cross Sections Obtaining Descriptive Information on Cross Sections Subsetting a Data File Containing Cross Sections Renaming Time Series Variables Changing the Lengths of Numeric Variables -
Syntax
-
Details
-
Examples
BEA National Income and Product Accounts BLS Consumer Price Index Surveys BLS State and Area Employment, Hours, and Earnings Surveys DRI/McGraw-Hill Format CITIBASE Files DRI Data Delivery Service Database PC Format CITIBASE Database Quarterly COMPUSTAT Data Files Annual COMPUSTAT Data Files, V9.2 New Filetype CSAUC3 CRSP Daily NYSE/AMEX Combined Stocks
- References
| RENAME Statement |
The RENAME statement is used to change the names of variables in the output data sets. Any number of variables can be renamed in a single RENAME statement. The most recent RENAME specification overrides any previous ones for a given variable. The new-name is limited to 32 characters.
Renaming of variables is done at the output stage. Therefore, you need to use the old variable names in all other PROC DATASOURCE statements. For example, the series variable names DATA1-DATA350 used with annual COMPUSTAT files are not very descriptive, so you may choose to rename them to reflect the financial aspect they represent. You may rename "DATA51" as "INVESTTAX" with the RENAME statement
rename data51=investtax;
since it contains investment tax credit data. However, in all other DATASOURCE statements, you must use the old name, DATA51.