The EXPAND Procedure
- Overview
-
Getting Started
Converting to Higher Frequency SeriesAggregating to Lower Frequency SeriesCombining Time Series with Different FrequenciesInterpolating Missing ValuesRequesting Different Interpolation MethodsUsing the ID StatementSpecifying Observation CharacteristicsConverting Observation CharacteristicsCreating New VariablesTransforming Series -
Syntax
-
Details
-
Examples
- References
Statistical procedures use ODS Graphics to create graphs as part of their output. ODS Graphics is described in detail in Chapter 21: Statistical Graphics Using ODS in SAS/STAT 12.3 User's Guide.
Before you create graphs, ODS Graphics must be enabled (for example, with the ODS GRAPHICS ON statement). For more information about enabling and disabling ODS Graphics, see the section “Enabling and Disabling ODS Graphics” in that chapter.
The overall appearance of graphs is controlled by ODS styles. Styles and other aspects of using ODS Graphics are discussed in the section “A Primer on ODS Statistical Graphics” in that chapter.
This section describes the use of ODS for creating graphics with the EXPAND procedure. To request these graphs, you must specify the PLOTS= option in the PROC EXPAND statement.
PROC EXPAND assigns a name to each graph it creates using ODS. You can use these names to reference the graphs when using ODS. The names are listed in Table 15.2.
Table 15.2: ODS Graphics Produced by PROC EXPAND
|
ODS Graph Name |
Plot Description |
PLOTS= Options |
|---|---|---|
|
ConvertedSeriesPlot |
Converted Series Plot |
CONVERTED OUTPUT ALL |
|
CrossInputSeriesPlot |
Cross Input Series Plot |
CROSSINPUT |
|
CrossOutputSeriesPlot |
Cross Output Series Plot |
CROSSOUTPUT |
|
InputSeriesPlot |
Input Series Plot |
INPUT JOINTINPUT ALL |
|
JointInputSeriesPlot |
Joint Input Series Plot |
JOINTINPUT |
|
JointOutputSeriesPlot |
Joint Output Series Plot |
JOINTOUTPUT |
|
OutputSeriesPlot |
Output Series Plot |
SERIES|OUTPUT |
|
TransformedInputSeriesPlot |
Transformed Input Series Plot |
TRANSFORMIN OUTPUT ALL |
|
TransformedOutputSeriesPlot |
Transformed Output Series Plot |
TRANSFORMOUT OUTPUT ALL |
Some plots are produced for a series only if the relevant options are also specified. For example, if PLOTS=TRANSFORMIN is specified, then the TRANSFORMIN plot is not produced for a variable unless the TRANSFORMIN= option is specified in a CONVERT statement for that variable. The PLOTS=TRANSFORMIN option plots the series after the input transformation (TRANSFORMIN= option) is applied.
The PLOTS=CONVERTED option plots the series after the input transformation (TRANSFORMIN= option) is applied and after frequency conversion (METHOD= option). If there is no frequency conversion for an output variable, the converted series plot is not produced.
The PLOTS=TRANSFORMOUT option plots the series after the output transformation (TRANSFORMOUT= option) is applied. If the TRANFORMOUT= option is not specified in the CONVERT statement for an output variable, the output transformation plot is not produced.
The PLOTS=OUTPUT option plots the series after it has undergone input transformation (TRANSFORMIN= option), frequency conversion (METHOD= option), and output transformation (TRANSFORMOUT= option) if these CONVERT statement options were specified.
The PLOTS= option values CROSSINPUT and CROSSOUTPUT produce graphs that overlay plots of two series by using two Y axes and with each of the two plots shown at a separate scale. These plots are called cross plots.
The PLOTS= option values JOINTINPUT and JOINTOUTPUT produce graphs that overlay plots of two series by using a single Y axis and with both of the plots shown on the same scale. These plots are called joint plots. The joint graphics options (PLOTS=JOINTINPUT or PLOTS=JOINTOUTPUT) plot the (input or converted) series and the transformed series on the same scale; therefore if the transformation changes, the range of the series these plots might be hard to visualize.
The PLOTS=CROSSINPUT option plots both the input series and the series after the input transformation (TRANSFORMIN= option) is applied. The left vertical axis refers to the input series, while the right vertical axis refers to the series after the transformation. If the TRANFORMIN= option is not specified in the CONVERT statement for an output variable, then the cross input plot is not produced for that variable.
The PLOTS=JOINTINPUT option jointly plots both the input series and the series after the input transformation (TRANSFORMIN= option) is applied. If the TRANSFORMIN= option is not specified in the CONVERT statement for an output variable, then the joint input plot is not produced for that variable.
The PLOTS=CROSSOUTPUT option plots both the converted series and the converted series after the output transformation (TRANSFORMOUT= option) is applied. The left vertical axis refers to the input series, while the right vertical axis refers to the series after the transformation. If the TRANSFORMOUT= option is not specified in the CONVERT statement for an output variable, then the cross output plot is not produced for that variable.
The PLOTS=JOINTOUTPUT option jointly plots both the converted series and the converted series after the output transformation (TRANSFORMOUT= option) is applied. If the TRANSFORMOUT= option is not specified in the CONVERT statement for an output variable, then the joint output plot is not produced for that variable.