Previous Page | Next Page

The PRINT Procedure

Example 5: Summing Numeric Variables with Multiple BY Variables


Procedure features:

PROC PRINT statement options:

N=

NOOBS

STYLE

SUMLABEL

BY statement

SUM statement

Other features:

ODS HTML statement

LABEL statement

FORMAT statement

SORT procedure

TITLE statement

Data set: EXPREV

This example demonstrates the following tasks:


Program: Creating a Listing Report

 Note about code
options nodate pageno=1 linesize=80 pagesize=40;
 Note about code
proc sort data=exprev;
   by sale_type order_date;
run;
 Note about code
proc print data=exprev n noobs sumlabel;
 Note about code
   by sale_type order_date;
   sum price quantity;
 Note about code
   label  sale_type='Sale Type' 
          order_date='Sale Date';
   format price dollar10.2 cost dollar10.2;
   title 'Retail and Quantity Totals for Each Sale Date and Sale Type';
run;

Output: Listing

Summing Numeric Variables with Multiple BY Variables: Listing Output

 Note about figure
          Retail and Quantity Totals for Each Sale Date and Sale Type          1

---------------------- Sale Type=Catalog Sale Date=1/1/08 ----------------------

                              Ship_
   Country         Emp_ID      Date     Quantity         Price          Cost

   Puerto Rico    99999999    1/5/08       14           $51.20        $12.10
   Aruba          99999999    1/4/08       30          $123.70        $59.00
   Bahamas        99999999    1/4/08        8          $113.40        $28.45
   Bermuda        99999999    1/4/08        7           $41.00         $9.25
   -----------                          --------    ----------
   Sale Date                               59          $329.30              

                                     N = 4


---------------------- Sale Type=Catalog Sale Date=1/2/08 ----------------------

                                    Ship_
Country                   Emp_ID     Date    Quantity        Price         Cost

British Virgin Islands   99999999   1/5/08       11         $40.20       $20.20
Canada                   99999999   1/5/08      100         $11.80        $5.00
El Salvador              99999999   1/6/08       21        $266.40       $66.70
Brazil                   120127     1/2/08       12         $73.40       $18.45
French Guiana            120935     1/2/08       15         $96.40       $43.85
Grenada                  120931     1/2/08       19         $56.30       $25.05
Paraguay                 120603     1/2/08       17        $117.60       $58.90
Peru                     120845     1/2/08       12         $93.80       $41.75
----------------------                       --------   ----------
Sale Date                                       207        $755.90             
Sale Type                                       266      $1,085.20             

                                     N = 8
          Retail and Quantity Totals for Each Sale Date and Sale Type          2

--------------------- Sale Type=In Store Sale Date=1/1/08 ----------------------

                                    Ship_
        Country           Emp_ID     Date    Quantity        Price         Cost

 Virgin Islands (U.S.)   99999999   1/4/08      25          $31.10       $15.65

                                     N = 1


--------------------- Sale Type=In Store Sale Date=1/2/08 ----------------------

                                   Ship_
 Country                 Emp_ID     Date    Quantity        Price         Cost

 Belize                 120458     1/2/08        2        $146.40       $36.70
 Cayman Islands         120454     1/2/08       20         $71.00       $32.30
 Guatemala              120931     1/2/08       13        $144.40       $65.70
 Jamaica                99999999   1/4/08       23        $169.80       $38.70
 Mexico                 120127     1/2/08       30        $211.80       $33.65
 Montserrat             120127     1/2/08       19        $184.20       $36.90
 Anguilla               99999999   1/6/08       15        $233.50       $22.25
 Antigua/Barbuda        120458     1/2/08       31         $99.60       $45.35
 Argentina              99999999   1/6/08       42        $408.80       $87.15
 Barbados               99999999   1/6/08       26         $94.80       $42.60
 Bolivia                120127     1/2/08       26         $66.00       $16.60
 Chile                  120447     1/2/08       20         $19.10        $8.75
 Ecuador                121042     1/2/08       11        $100.90       $50.55
 Falkland Islands       120932     1/2/08       15         $61.40       $30.80
 Guyana                 120455     1/2/08       25        $132.80       $30.25
 Martinique             120841     1/3/08       16         $56.30       $31.05
 Netherlands Antilles   99999999   1/6/08       31         $41.80       $19.45
 --------------------                       --------   ----------
 Sale Date                                     365      $2,242.60             
 Sale Type                                     390      $2,273.70             

                                     N = 17
          Retail and Quantity Totals for Each Sale Date and Sale Type          3

--------------------- Sale Type=Internet Sale Date=1/1/08 ----------------------

                              Ship_
     Country       Emp_ID      Date     Quantity         Price          Cost

    Antarctica    99999999    1/7/08        2           $92.60        $20.70

                                     N = 1


--------------------- Sale Type=Internet Sale Date=1/2/08 ----------------------

                                    Ship_
 Country                 Emp_ID     Date     Quantity        Price         Cost

 Costa Rica             99999999   1/6/08        31         $53.00       $26.60
 Cuba                   121044     1/2/08        12         $42.40       $19.35
 Dominican Republic     121040     1/2/08        13         $48.00       $23.95
 Haiti                  121059     1/2/08         5         $47.90       $23.45
 Honduras               120455     1/2/08        20         $66.40       $30.25
 Nicaragua              120932     1/2/08        16        $122.00       $28.75
 Panama                 99999999   1/6/08        20         $88.20       $38.40
 Saint Kitts/Nevis      99999999   1/6/08        20         $41.40       $18.00
 St. Helena             120360     1/2/08        19         $94.70       $47.45
 St. Pierre/Miquelon    120842     1/16/08       16        $103.80       $47.25
 Turks/Caicos Islands   120372     1/2/08        10         $57.70       $28.95
 United States          120372     1/2/08        20         $88.20       $38.40
 Colombia               121059     1/2/08        28        $361.40       $90.45
 Dominica               121043     1/2/08        35        $121.30       $57.80
 Guadeloupe             120445     1/2/08        21        $231.60       $48.70
 St. Lucia              120845     1/2/08        19         $64.30       $28.65
 --------------------                        --------   ----------
 Sale Date                                      305      $1,632.30             

                                     N = 16
          Retail and Quantity Totals for Each Sale Date and Sale Type          4

--------------------- Sale Type=Internet Sale Date=1/3/08 ----------------------

                            Ship_
      Country     Emp_ID     Date     Quantity         Price          Cost

     Suriname     120538    1/3/08        22         $110.80        $29.35
     ---------                        --------    ----------
     Sale Type                           329       $1,835.70              
                                      ========    ==========
                                         985       $5,194.60              

                                    N = 1
                              Total N = 48

Program: Creating an HTML Report

options nodate pageno=1 linesize=80 pagesize=40 obs=10;

 Note about code
ods html file='your_file.html';
proc sort data=exprev;
   by sale_type order_date;
run;

proc print data=exprev n noobs sumlabel;
   by sale_type order_date;
   sum price quantity;

   label  sale_type='Sale Type' order_date='Sale Date';
   format price dollar10.2 cost dollar10.2;
   title 'Retail and Quantity Totals for Each Sale Date and Sale Type';
run;

 Note about code
ods html close;

Output: HTML

The following three displays comprise the output that creates default HTML output.

Summing Numeric Variables with Multiple BY Variables: Catalog Sales: Default HTML Output

[Summing Numeric Variables with Multiple BY Variables: Catalog Sales: Default HTML Output]

Summing Numeric Variables with Multiple BY Variables: In Store Sales: Default HTML Output

[Summing Numeric Variables with Multiple BY Variables: In Store Sales: Default HTML Output]

Summing Numeric Variables with Multiple BY Variables: Internet Sales: Default HTML Output

[Summing Numeric Variables with Multiple BY Variables: Internet Sales: Default HTML Output]


Program: Creating an HTML Report with the STYLE Option

options nodate pageno=1 linesize=80 pagesize=40 obs=10

ods html file='your_file.html';

proc sort data=exprev;
   by sale_type order_date;
run;

proc print data=exprev n noobs sumlabel;

 Note about code
   by sale_type order_date;
sum price / style(GRANDTOTAL) = [background =white color=blue];
sum quantity / style(TOTAL) = [background =dark blue color=white];
   label  sale_type='Sale Type' order_date='Sale Date';
   format price dollar10.2 cost dollar10.2;
   title 'Retail and Quantity Totals for Each Sale Date and Sale Type';
run;

ods html close;


Output: HTML with Styles

The following three displays comprise the output that creates styles in the HTML output.

Summing Numeric Variables with Multiple BY Variables: Catalog Sales: HTML Output Using Styles

[Summing Numeric Variables with Multiple BY Variables: Catalog Sales: HTML Output Using Styles]

Summing Numeric Variables with Multiple BY Variables: In Store Sales: HTML Output Using Styles

[Summing Numeric Variables with Multiple BY Variables: In Store Sales: HTML Output Using Styles]

Summing Numeric Variables with Multiple BY Variables: Internet Sales: HTML Output Using Styles

[Summing Numeric Variables with Multiple BY Variables: Internet Sales: HTML Output Using Styles]

Previous Page | Next Page | Top of Page