Examples: TIMEPLOT Procedure


Example 1: Plotting a Single Variable

Procedure features:

ID statement

PLOT statement arguments:

  • simple plot request

  • POS=

This example

  • uses a single PLOT statement to plot sales of refrigerators

  • specifies the number of print positions to use for the horizontal axis of the plot

  • provides context for the points in the plot by printing in the listing the values of two variables that are not in the plot.

Program

Set the SAS system options. The NODATE option suppresses the display of the date and time in the output. PAGENO= specifies the starting page number. LINESIZE= specifies the output line length, and PAGESIZE= specifies the number of lines on an output page.

 options nodate pageno=1 linesize=80 pagesize=60; 

Create the SALES data set. SALES contains weekly information on the sales of refrigerators and stoves by two sales representatives.

 data sales;     input Month Week Seller $ Icebox Stove;     datalines;  1 1 Kreitz   3450.94 1312.61  1 1 LeGrange 2520.04  728.13  1 2 Kreitz   3240.67  222.35  1 2 LeGrange 2675.42  184.24  1 3 Kreitz   3160.45 2263.33  1 3 LeGrange 2805.35  267.35  1 4 Kreitz   3400.24 1787.45  1 4 LeGrange 2870.61  274.51  2 1 Kreitz   3550.43 2910.37  2 1 LeGrange 2730.09  397.98  2 2 Kreitz   3385.74  819.69  2 2 LeGrange 2670.93 2242.24  ; 

Plot sales of refrigerators. The plot variable, Icebox, appears in both the listing and the output. POS= provides 50 print positions for the horizontal axis.

 proc timeplot data=sales;     plot icebox / pos=50; 

Label the rows in the listing. The values of the ID variables, Month and Week, are used to uniquely identify each row of the listing.

 id month week; 

Specify the titles.

 title 'Weekly Sales of Iceboxes';     title2 'for the';     title3 'First Six Weeks of the Year';  run; 

Output

The column headers in the listing are the variables names . The plot uses the default plotting symbol, which is the first character of the plot variable s name .

 Weekly Sales of Iceboxes                           1                                for the                      First Six Weeks of the Year  Month Week   Icebox   min                                              max                        2520.04                                      3550.43                        *--------------------------------------------------*  1        1   3450.94                                                I     1        1   2520.04  I                                                   1        2   3240.67                                   I                  1        2   2675.42        I                                             1        3   3160.45                                I                     1        3   2805.35              I                                       1        4   3400.24                                             I        1        4   2870.61                I                                     2        1   3550.43                                                   I  2        1   2730.09          I                                           2        2   3385.74                                            I         2        2   2670.93        I                                                                   *--------------------------------------------------* 

Example 2: Customizing an Axis and a Plotting Symbol

Procedure features:

ID statement

PLOT statement arguments:

  • using a plotting symbol

  • AXIS=

Other features:

LABEL statement

PROC FORMAT

SAS system options:

  • FMTSEARCH=

Data set: SALES on page 1313

This example

  • specifies the character to use as the plotting symbol

  • specifies the minimum and maximum values for the horizontal axis as well as the interval represented by each print position

  • provides context for the points in the plot by printing in the listing the values of two variables that are not in the plot

  • uses a variable s label as a column header in the listing

  • creates and uses a permanent format.

Program

Declare the PROCLIB SAS data library.

 libname proclib '  SAS-data-library  '; 

Set the SAS system options. The NODATE option suppresses the display of the date and time in the output. PAGENO= specifies the starting page number. LINESIZE= specifies the output line length, and PAGESIZE= specifies the number of lines on an output page. FMTSEARCH= adds the SAS data library PROCLIB to the search path that is used to locate formats.

 options nodate pageno=1 linesize=80 pagesize=60          fmtsearch=(proclib); 

Create a format for the Month variable. PROC FORMAT creates a permanent format for Month. The LIBRARY= option specifies a permanent storage location so that the formats are available in subsequent SAS sessions. This format is used for examples throughout this chapter.

 proc format library=proclib;     value monthfmt 1='January'                   2='February';  run; 

Plot sales of refrigerators. The plot variable, Icebox, appears in both the listing and the output. The plotting symbol is R . AXIS= sets the minimum value of the axis to 2500 and the maximum value to 3600. BY 25 specifies that each print position on the axis represents 25 units (in this case, dollars).

 proc timeplot data=sales;     plot icebox='R' / axis=2500 to 3600 by 25; 

Label the rows in the listing. The values of the ID variables, Month and Week, are used to uniquely identify each row of the listing.

 id month week; 

Apply a label to the sales column in the listing. The LABEL statement associates a label with the variable Icebox for the duration of the PROC TIMEPLOT step. PROC TIMEPLOT uses the label as the column header in the listing.

 label icebox='Refrigerator'; 

Apply the MONTHFMT. format to the Month variable. The FORMAT statement assigns a format to use for Month in the report.

 format month monthfmt.; 

Specify the titles.

 title 'Weekly Sales of Refrigerators';     title2 'for the';     title3 'First Six Weeks of the Year';  run; 

Output

The column headers in the listing are the variables' names (for Month and Week, which have no labels) and the variable's label (for Icebox, which has a label). The plotting symbol is R (for Refrigerator).

 Weekly Sales of Refrigerators                       1                                      for the                            First Six Weeks of the Year    Month   Week    Refrigerator  min                                        max                                  2500                                      3600                                 *---------------------------------------------*  January      1        3450.94                                       R         January      1        2520.04   R                                             January      2        3240.67                                R                January      2        2675.42         R                                       January      3        3160.45                             R                   January      3        2805.35            R                                    January      4        3400.24                                      R          January      4        2870.61              R                                  February     1        3550.43                                             R   February     1        2730.09         R                                       February     2        3385.74                                     R           February     2        2670.93        R                                                                       *---------------------------------------------* 

Example 3: Using a Variable for a Plotting Symbol

Procedure features:

ID statement

PLOT statement arguments:

  • using a variable as the plotting symbol

  • JOINREF

  • NPP

  • REF=

  • REFCHAR=

Data set: SALES on page 1313

Formats: MONTHFMT. on page 1316

This example

  • specifies a variable to use as the plotting symbol to distinguish between points for each of two sales representatives

  • suppresses the printing of the values of the plot variable in the listing

  • draws a reference line to a specified value on the axis and specifies the character to use to draw the line

  • connects the leftmost and rightmost symbols on each line of the plot. Program

Declare the PROCLIB SAS data library.

 libname proclib '  SAS-data-library  '; 

Set the SAS system options. The NODATE option suppresses the display of the date and time in the output. PAGENO= specifies the starting page number. LINESIZE= specifies the output line length, and PAGESIZE= specifies the number of lines on an output page. FMTSEARCH= adds the SAS data library PROCLIB to the search path that is used to locate formats.

 options nodate pageno=1 linesize=80 pagesize=60          fmtsearch=(proclib); 

Plot sales of stoves. The PLOT statement specifies both the plotting variable, Stove, and a symbol variable, Seller. The plotting symbol is the first letter of the formatted value of the Seller (in this case, L or K ).

 proc timeplot data=sales;     plot stove=seller / 

Suppress the appearance of the plotting variable in the listing. The values of the Stove variable will not appear in the listing.

 npp 

Create a reference line on the plot. REF= and REFCHAR= draw a line of colons at the sales target of $1500.

 ref=1500 refchar=':' 

Draw a line between the symbols on each line of the plot. In this plot, JOINREF connects each plotting symbol to the reference line.

 joinref 

Customize the horizontal axis. AXIS= sets the minimum value of the horizontal axis to 100 and the maximum value to 3000. BY 50 specifies that each print position on the axis represents 50 units (in this case, dollars).

 axis=100 to 3000 by 50; 

Label the rows in the listing. The values of the ID variables, Month and Week, are used to identify each row of the listing.

 id month week; 

Apply the MONTHFMT. format to the Month variable. The FORMAT statement assigns a format to use for Month in the report.

 format month monthfmt.; 

Specify the titles.

 title 'Weekly Sales of Stoves';     title2 'Compared to Target Sales of 00';     title3 'K for Kreitz; L for LeGrange';  run; 

Output

The plot uses the first letter of the value of Seller as the plotting symbol.

 Weekly Sales of Stoves                             1                     Compared to Target Sales of 00                        K for Kreitz; L for LeGrange    Month  Week    min                                                      max                   100                                                     3000                  *-----------------------------------------------------------*  January     1                           K---:                                January     1                L--------------:                                January     2     K-------------------------:                                January     2     L-------------------------:                                January     3                               :--------------K                 January     3      L------------------------:                                January     4                               :-----K                          January     4      L------------------------:                                February    1                               :---------------------------K    February    1         L---------------------:                                February    2                 K-------------:                                February    2                               :--------------L                                 *-----------------------------------------------------------* 

Example 4: Superimposing Two Plots

Procedure features:

PROC TIMEPLOT statement options:

  • MAXDEC=

PLOT statement arguments:

  • using two types of plot requests

  • OVERLAY

  • REF=MEAN( variable(s) )

  • REVERSE

Data set: SALES on page 1313

This example

  • superimposes two plots on one set of axes

  • specifies a variable to use as the plotting symbol for one plot and a character to use as the plotting symbol for the other plot

  • draws a reference line to the mean value of each of the two variables plotted

  • reverses the labeling of the axis so that the largest value is at the far left of the plot.

Program

Set the SAS system options. The NODATE option suppresses the display of the date and time in the output. PAGENO= specifies the starting page number. LINESIZE= specifies the output line length, and PAGESIZE= specifies the number of lines on an output page.

 options nodate pageno=1 linesize=80 pagesize=60; 

Specify the number of decimal places to display. MAXDEC= specifies the number of decimal places to display in the listing.

 proc timeplot data=sales maxdec=0; 

Plot sales of both stoves and refrigerators. The PLOT statement requests two plots. One plot uses the first letter of the formatted value of Seller to plot the values of Stove. The other uses the letter R (to match the label Refrigerators) to plot the value of Icebox.

 plot stove=seller icebox='R' / 

Print both plots on the same set of axes.

 overlay 

Create two reference lines on the plot. REF= draws two reference lines: one perpendicular to the mean of Stove, the other perpendicular to the mean of Icebox.

 ref=mean(stove icebox) 

Order the values on the horizontal axis from largest to smallest.

 reverse; 

Apply a label to the sales column in the listing. The LABEL statement associates a label with the variable Icebox for the duration of the PROC TIMEPLOT step. PROC TIMEPLOT uses the label as the column header in the listing.

 label icebox='Refrigerators'; 

Specify the titles.

 title 'Weekly Sales of Stoves and Refrigerators';     title2 'for the';     title3 'First Six Weeks of the Year';  run; 

Output

The column header for the variable Icebox in the listing is the variable's label (Refrigerators). One plot uses the first letter of the value of Seller as the plotting symbol. The other plot uses the letter R .

 Weekly Sales of Stoves and Refrigerators                                 1                                               for the                                   First Six Weeks of the Year    Stove      Refrigerators         max                                                      min                                     3550.43                                               184.24                                     *----------------------------------------------------------*     1313               3451         R                                      K                      728               2520                          R                              L             222               3241               R                                               K       184               2675                        R                                       L     2263               3160                R               K                                      267               2805                     R                                         L      1787               3400          R                            K                               275               2871                   R                                           L      2910               3550         R         K                                                   398               2730                       R                                    L          820               3386          R                                             K             2242               2671                         R      L                                                                     *----------------------------------------------------------* 

Example 5: Showing Multiple Observations on One Line of a Plot

Procedure features:

  • CLASS statement

  • PLOT statement arguments:

    • creating multiple plots

    • NOSYMNAME

    • OVPCHAR=

Data set: SALES on page 1313

Formats: MONTHFMT. on page 1316

This example

  • groups observations for the same month and week so that sales for the two sales representatives for the same week appear on the same line of the plot

  • specifies a variable to use as the plotting symbol

  • suppresses the name of the plotting variable from one plot

  • specifies a size for the plots so that they both occupy the same amount of space.

Program

Declare the PROCLIB SAS data library.

 libname proclib '  SAS-data-library  '; 

Set the SAS system options. The NODATE option suppresses the display of the date and time in the output. PAGENO= specifies the starting page number. LINESIZE= specifies the output line length, and PAGESIZE= specifies the number of lines on an output page. FMTSEARCH= adds the SAS data library PROCLIB to the search path that is used to locate formats.

 options nodate pageno=1 linesize=80 pagesize=60          fmtsearch=(proclib); 

Specify subgroups for the analysis. The CLASS statement groups all observations with the same values of Month and Week into one line in the output. Using the CLASS statement with a symbol variable produces in the listing one column of the plot variable for each value of the symbol variable.

 proc timeplot data=sales;     class month week; 

Plot sales of stoves and refrigerators. Each PLOT statement produces a separate plot. The plotting symbol is the first character of the formatted value of the symbol variable: K for Kreitz; L for LeGrange. POS= specifies that each plot uses 25 print positions for the horizontal axis. OVPCHAR= designates the exclamation point as the plotting symbol when the plotting symbols coincide. NOSYMNAME suppresses the name of the symbol variable Seller from the second listing.

 plot stove=seller  / pos=25 ovpchar='!';  plot icebox=seller / pos=25 ovpchar='!' nosymname; 

Apply formats to values in the listing. The FORMAT statement assigns formats to use for Stove, Icebox, and Month in the report. The TITLE statement specifies a title.

 format stove icebox dollar10.2 month monthfmt.; 

Specify the title.

 title 'Weekly Appliance Sales for the First Quarter';  run; 

Output

 Weekly Appliance Sales for the First Quarter                        1                    Seller :Kreitz   Seller :LeGrange     Month    Week             Stove            Stove        min                        max                                                             4.24              ,910.37                                                             *----------------------------*  January        1     ,312.61         8.13                   L       K               January        2       2.35         4.24             !                             January        3     ,263.33         7.35              L                   K        January        4     ,787.45         4.51              L               K            February       1     ,910.37         7.98                L                       K  February       2       9.69       ,242.24                    K             L                                                                   *----------------------------* 
 Weekly Appliance Sales for the First Quarter                   2                             Kreitz           LeGrange     Month    Week           Icebox             Icebox       min                    max                                                              ,520.04        ,550.43                                                             *--------------------------*  January        1     ,450.94       ,520.04             L                       K   January        2     ,240.67       ,675.42                    L           K        January        3     ,160.45       ,805.35                     L         K         January        4     ,400.24       ,870.61                       L            K    February       1     ,550.43       ,730.09                   L                  K  February       2     ,385.74       ,670.93                    L               K                                                               *--------------------------* 



Base SAS 9.1.3 Procedures Guide (Vol. 1)
Base SAS 9.1 Procedures Guide, Volumes 1, 2, 3 and 4
ISBN: 1590472047
EAN: 2147483647
Year: 2004
Pages: 260

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net