The EXPAND Procedure
Functional Summary
The statements and options controlling the EXPAND procedure are summarized in Table 1.
Table 1: Functional Summary
| Description | Statement | Option |
|---|---|---|
| Statements | ||
| Specify options | PROC EXPAND | |
| Specify BY-group processing | BY | |
| Specify conversion options | CONVERT | |
| Specify the ID variable | ID | |
| Data Set Options | ||
| Specify the input data set | PROC EXPAND | DATA= |
| Extrapolate values before or after input series | PROC EXPAND | EXTRAPOLATE |
| Specify the output data set | PROC EXPAND | OUT= |
| Write interpolating functions to a data set | PROC EXPAND | OUTEST= |
| Input and Output Frequencies | ||
| Control the alignment of SAS date values | PROC EXPAND | ALIGN= |
| Specify frequency conversion factor | PROC EXPAND | FACTOR= |
| Specify input frequency | PROC EXPAND | FROM= |
| Specify output frequency | PROC EXPAND | TO= |
| Interpolation Control Options | ||
| Specify interpolation method for all series | PROC EXPAND | METHOD= |
| Specify interpolation method for series | CONVERT | METHOD= |
| Specify observation characteristics for series | PROC EXPAND | OBSERVED= |
| Specify observation characteristics for series | CONVERT | OBSERVED= |
| Specify transformations of the input series | CONVERT | TRANSFORMIN= |
| specify transformations of the output series | CONVERT | TRANSFORMOUT= |
| Graphical Output Control Options | ||
| Specify graphical output | PROC EXPAND | PLOTS= |
The following sections describe the PROC EXPAND statement and then describe the other statements in alphabetical order.
Last updated: December 20, 2021