Previous Topic: 6.4 Analytic Technique TutorialNext Topic: 6.6 Case Studies


6.5 Component Operation


This section describes the control parameters for Simple
Regression Analysis inquiries.  These parameters allow you to
define analyses based on simple linear regression,
controlling titles, labels, and the presentation media.  You
can present your analysis on a line printer or on a color
graphics device, however, SAS/GRAPH is a prerequisite for the
color graphics option.

To get to the Simple Regression screen (shown in Figure 6-3).
you must follow a short set of menus that are more fully
described in Section 1.5 of this guide.  The Simple
Regression screen appears after you indicate that you want to
insert a new Simple Regression Analysis inquiry into your
catalog of analysis inquiries.  Two fields on this screen are
filled in on the fourth line when you first see it:  inquiry
name and the inquiry description, separated by a dash.  You
entered data in these fields on the Insert Capacity Planning
Analysis screen when you requested that a new inquiry be
added.

/------------------------  Simple Regression Analysis  -------------------------\
| Command ===>                                                                  |
|                                                                               |
|Composing CA MICS Inquiry:  ______ - ___________________________________       |
|                                                                               |
|Report title ===> ___________________________________________________          |
|                                                                               |
|Selection criteria:                                                            |
|                 Input file ===> ____                                          |
|                 Start date ===> _________ (ddmonyyyy)                         |
|                      SYSID ===> ____                                          |
|                       Zone ===> _________                                     |
|                 No. months ===> ____      (1-9999)                            |
|      Specify CAPAPU Values ===> _         (Y/N)                               |
|                                                                               |
|Plot title                  ===> ________________________________________      |
|Forecast data element       ===> __________                                    |
|Axis label                  ===> _________                                     |
|Forecast length (weeks)     ===> ____      (1-9999)                            |
|                                                                               |
|Plot type                   ===> PRINTER   (COLOR/PRINTER)                     |
|Specify color graphics parms===> N         (Y/N/R)                             |
|  Color graphics format set ===> PENPLOT                                       |
|                                                                               |
|          Create CSV Output ===> N         (Y/N)                               |
\------------------------------------------------------------------------------/

 Figure 6-3.  Simple Regression Control Screen

Some of the parameters on the Simple Regression control
screen shown in Figure 6-3 are required, while others are
optional.  A description of the parameters as they appear in
this figure follows.

Report        The 60-character title field for the Simple
title:        Regression Analysis reports.  No double quotes
              or semicolons (;) may appear within the body of
              the title.

Input file:   The capacity planning database file containing
              the historical observations to use as input to
              the analysis.  If you are uncertain of the
              files or file names available in your capacity
              planning database, type a question mark (?) in
              the field and a selection list will appear.

Start date:   The start date for date range selection.  If
              Start date is specified, only historical
              observations at least as recent as this value
              are included in the analysis.  The discussion
              of the following control parameter describes
              the options for controlling date range
              selection.

SYSID:        The SYSID for which the report will be
              produced.  If the Capacity Planning database
              file was defined as having a composite SYSID,
              this value is automatically supplied.

No. months:   The maximum number of days, weeks, or months of
              historical observations that will be included
              in the analysis.  Note that once you specify
              the input file, the field name will change to
              reflect the timespan of the input file.  When
              used in conjunction with the Start date
              parameter, several options are available for
              date range selection control:

              o  If you specify only Start date, all
                 historical observations at least as recent
                 as the value specified for Start date will
                 be selected.

              o  If you specify both Start date and No.
                 months, the date range for data selection
                 begins with the value specified for Start
                 date and extends for the specified number of
                 days, weeks or months.

              o  If you specify only No. months, the date
                 range for data selection will include only
                 the number of the most recent days, weeks or
                 months.

              o  If you specify neither parameter, then all
                 historical observations are selected.

Zone:         The Zone, Hour, or Dayname to be included in
              the analysis, depending on whether you defined
              the capacity planning database file at the
              Zone, Hour, or Dayname summarization level.  If
              you defined the file as having a composite
              Zone, Hour or Dayname, this value is supplied
              automatically on the screen.  Note that the
              field name will be changed automatically to
              either Zone, Hour or Dayname once you specify
              the input file to reflect the input file
              summarization level.

Specify       Put a Y in this field to specify the CAPAPU
CAPAPU        value(s) to be included in the analysis. The
values:       CAPAPU value is specified on the CAPAPU
              Selection Values screen, shown in Figure 6-4,
              that appears if you enter a Y in this field.
              You may specify it only if the Capacity
              Planning database file is defined as containing
              CAPAPU(s).

Plot Title:   An optional second title line for the reports
              if needed.  This is a 40-character field and no
              double quotes (") or semicolons (;) can appear
              within the body of the title.

Forecast      The data element will be the subject of the
data          Simple Regression Analysis.  If you are
element:      uncertain of the correct data element names
              in the input title, type a question mark (?) in
              this field and a selection list of available
              data elements will be presented.

Axis label:   The label for the vertical axis on the simple
              regression plot.  You may specify up to 40
              characters for the label and no double quotes
              (") or semicolons(;) can appear within the body
              of the label.  If you do not specify a label,
              this parameter is automatically filled with the
              forecast data element label that you specified
              when the input file was created.

Forecast      The length of forecast period in days, weeks,
length        or months.  Note that the field name changes
(weeks):      once you specify the input file to reflect the
              timespan of the Input file.  If the file is a
              days level file, the Capacity Planner generates
              a forecast observation every seven days if the
              file uses DAYNAME summarization; otherwise an
              observation is generated for each day.

Plot type:    The specification for the type of plot.  You
              can specify COLOR for a color graphics plot or
              PRINTER for a line printer plot.  Printer
              graphics are always available, however,
              SAS/GRAPH is a prerequisite for color graphics.
              The default is a non-graphics printer.  If you
              indicate that the results are to be presented
              on a color graphics device, you can also
              indicate whether you want to override the
              default color graphics format parameters.  If
              you specify that you do, an additional screen
              appears to give you an opportunity to do this.

Create CSV    Default value is "N" for NO. Specify "Y" for
Output:       YES to create a Q&R formatted CSV that contains
              those data elements used in the analysis.
              Specify "N" for NO to bypass CSV creation.

If you entered a Y in the Specify CAPAPU values field on the
Profile and Trending Analysis screen, the CAPAPU Selection
Values screen appears, as shown in Figure 6-4.  On the
CAPAPU Selection Values screen, you can specify the CAPAPU
values (up to nine) to be included in the analysis.  You may
specify CAPAPUs only if the Capacity Planning database file
is defined as containing the CAPAPU data elements.  (Note
that Simple Regression Analysis does not support wild cards.)

/-------------------------  CAPAPU Selection Values  ---------------------------\
|Command ===>                                                                   |
|                                                                               |
|Composing CA MICS Inquiry:  ______   ________________________________          |
|                                                                               |
|         Rule ----+----1----+----2----+----3----+----4----+----5----+----6---- |
|CAPAPU   ===> ________________________________________________________________ |
|CAPAPU 2 ===> ________________________________________________________________ |
|CAPAPU 3 ===> ________________________________________________________________ |
|CAPAPU 4 ===> ________________________________________________________________ |
|CAPAPU 5 ===> ________________________________________________________________ |
|CAPAPU 6 ===> ________________________________________________________________ |
|CAPAPU 7 ===> ________________________________________________________________ |
|CAPAPU 8 ===> ________________________________________________________________ |
|CAPAPU 9 ===> ________________________________________________________________ |
|                                                                               |
|                                                                               |
\------------------------------------------------------------------------------/

 Figure 6-4. CAPAPU Selection Values Screen

/----------------------  Color Graphics Format Parameters  ----------------------\
|Command ===>                                              Format set: PENPLOT   |
|                                                                                |
|Inquiry step:  Simple Regression Analysis                                       |
|                                                                                |
|Title print font        ===> SWISSB     Title color             ===> BLUE       |
|Draw border around plot ===> N   (Y/N)  Background color        ===> ________   |
|Axis color              ===> BLACK      Area inside axis color  ===> ________   |
|Text color              ===> BLACK                                              |
|                                                                                |
|Actual values:      Symbol ===> STAR      Line type ===> SOLID                  |
|                    Color  ===> BLUE                                            |
|                                                                                |
|Regression values:  Symbol ===> PLUS      Line type ===> DASHED                 |
|                    Color  ===> GREEN                                           |
|                                                                                |
|Forecast values:    Symbol ===> DIAMOND   Line type ===> DOTTED                 |
|                    Color  ===> RED                                             |
|                                                                                |
|                                                                                |
|Symbol (NONE,PLUS,STAR,TRIANGLE,DIAMOND,HASH,SQUARE,A-Z,0-9,or SAS/GRAPH value) |
|Line   (SOLID,DASHED,DOTTED,1-32)                                               |
|Color  (May be any color available on your graphics device.)                    |
\------------------------------------------------------------------------------/

 Figure 6-5.  Color Graphics Format Parameters Screen

The screen shown in Figure 6-5 allows you to define the
color graphics parameters that will determine the appearance
of your Simple Regression Analysis color plot.  The following
parameters are available:

Title print   The character format (font) for the title
font:         line(s).  Character font names are one to nine
              characters in length.  Refer to the SAS/GRAPH
              Software Volume 1 for a list of valid character
              fonts.

Title color:  The color of the title line(s).

Draw border   The specification to frame the graph with a
around plot:  border (that is, draw a line around the outside
              of the display).

Background    The specification to generate the graph on a
color:        colored background (that is, fill the entire
              graph with a color).

Axis color:   The  color of the x-axis and y-axis.

Area inside   The specification to draw the plot lines on a
axis color:   colored background (only the area inside the
              axis is filled.

Text color:   The color of all text words except the titles
              and labels.

Symbol:       The symbol for plotting the data values.  See
              the SAS/GRAPH Software Volume 1 for the
              available symbols.

Line type:    The line type for plotting the data values.
              See the SAS/GRAPH Software Volume 1 for the
              available line types.

Color:        The color for plotting the data values.  See
              the SAS/GRAPH Software Volume 1 for the
              available colors.