Providing software solutions since 1976
Sample 25427: Report writing using PUT statement (I)
 |  |  |  |  |
These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.
This sample is from the SAS Sample Library. For additional information refer to SAS Help and Online Documentation.
/****************************************************************/
/* S A S S A M P L E L I B R A R Y */
/* */
/* NAME: REPORT3 */
/* TITLE: Report Writing Using PUT Statement (I) */
/* PRODUCT: SAS */
/* SYSTEM: ALL */
/* KEYS: REPO DATASTEP MEANS PRINT SET BY FIRST. LAST. SUM */
/* FUNCTION FILE PUT DSOPTION IN= */
/* PROCS: MEANS */
/* DATA: */
/* */
/* SUPPORT: UPDATE: */
/* REF: */
/* MISC: */
/* */
/****************************************************************/
DATA SALES;
INPUT MONTH SUNITS GSALES RETURN DISCOUNT MFG_COST ROYALTY DIST
ADVTSNG PROMO1-PROMO6 PRODUCT $;
CARDS;
1 285 296 24 4 33 . 4 . . . . 40 3 . SOMATOL
2 225 234 19 3 26 . 3 . . . . 36 . . SOMATOL
3 291 301 25 4 33 . 3 . . . . 36 . . SOMATOL
4 158 164 14 2 18 . 2 . . . . 24 . . SOMATOL
5 140 145 12 2 16 . 2 . . . . 24 . . SOMATOL
6 109 113 9 2 12 . 2 . . . . 24 . . SOMATOL
7 84 86 7 1 10 . 1 . . . 20 21 9 . SOMATOL
8 125 130 11 2 14 . 1 . . . 20 22 6 . SOMATOL
9 167 174 14 3 19 . 2 . . . 5 42 6 . SOMATOL
10 204 213 18 3 23 . 3 . . . 5 44 5 . SOMATOL
11 208 216 18 4 24 . 3 . . . 5 44 5 . SOMATOL
12 105 110 9 2 12 . 2 . . . 5 44 5 . SOMATOL
1 219 212 17 4 21 . 2 . . . . . . . ZENATRIL
2 176 170 14 4 21 . 2 . . . . . . . ZENATRIL
3 238 228 19 3 21 . 3 . . . . . . . ZENATRIL
4 100 97 8 2 10 . 1 . . . . . . . ZENATRIL
5 93 89 7 1 9 . 1 . . . . . . . ZENATRIL
6 70 68 6 1 7 . 1 . . . . . . . ZENATRIL
7 59 58 5 1 5 . 1 . . . . . . . ZENATRIL
8 122 118 10 2 12 . 1 . . . . . . . ZENATRIL
9 157 150 12 2 15 . 2 . . . . . . . ZENATRIL
10 177 171 14 2 18 . 2 . . . . . . . ZENATRIL
11 173 167 14 2 16 . 2 . . . . . . . ZENATRIL
12 174 167 14 1 17 . 2 . . . . . . . ZENATRIL
;
PROC PRINT;
RUN;
DATA SALES;
SET SALES;
QUARTER = INT((MONTH+2)/3);
AGSALES = SUM(GSALES,-RETURN);
NSALES = SUM(AGSALES,-DISCOUNT);
TCOST = SUM(MFG_COST,ROYALTY);
MARGIN = SUM(NSALES,-TCOST);
TPROMO = SUM(OF PROMO1-PROMO6);
REDUCT = SUM(DIST,ADVTSNG,TPROMO);
PC = SUM(MARGIN,-REDUCT);
DROP REDUCT;
RUN;
PROC MEANS; * NOPRINT;
BY PRODUCT QUARTER;
VAR SUNITS GSALES RETURN AGSALES DISCOUNT NSALES MFG_COST
ROYALTY TCOST MARGIN DIST ADVTSNG PROMO1-PROMO6 TPROMO PC;
OUTPUT OUT=SUMS
SUM=SUNITS GSALES RETURN AGSALES DISCOUNT NSALES MFG_COST
ROYALTY TCOST MARGIN DIST ADVTSNG PROMO1-PROMO6 TPROMO PC;
RUN;
DATA SALES;
SET SALES SUMS(IN=S);
BY PRODUCT QUARTER;
IF S THEN COLUMN = 4*QUARTER;
ELSE COLUMN = MONTH + QUARTER - 1;
RUN;
PROC MEANS DATA=SUMS;
BY PRODUCT;
VAR SUNITS GSALES RETURN AGSALES DISCOUNT NSALES MFG_COST
ROYALTY TCOST MARGIN DIST ADVTSNG PROMO1-PROMO6 TPROMO PC;
OUTPUT OUT=TOTAL
SUM=SUNITS GSALES RETURN AGSALES DISCOUNT NSALES MFG_COST
ROYALTY TCOST MARGIN DIST ADVTSNG PROMO1-PROMO6 TPROMO PC;
RUN;
DATA SALES;
SET SALES TOTAL(IN=T);
BY PRODUCT;
IF T THEN COLUMN = 17;
RUN;
PROC PRINT;
RUN;
OPTIONS MISSING='_' LS=132;
DATA _NULL_;
SET SALES;
BY PRODUCT;
FILE PRINT N=PS NOTITLES;
IF FIRST.PRODUCT THEN LINK FORM;
C = 25 + 6*(COLUMN-1);
PUT #15 @C SUNITS 6. // @C GSALES 6. // @C RETURN 6. ///
@C AGSALES 6. // @C DISCOUNT 6. // @C NSALES 6. ////
@C MFG_COST 6. // @C ROYALTY 6. // @C TCOST 6. ////
@C MARGIN 6. ////
@C DIST 6. // @C ADVTSNG 6. //
(PROMO1-PROMO6) (@C 6. /) //
@C TPROMO 6. ////
@C PC 6. ;
RETURN;
FORM: PUT _PAGE_;
PUT// @52 'CRYSTAL-BRAMBLE DRUG COMPANY' //
@47 '1977 PRODUCT CONTRIBUTION WORKSHEET' //
@1 'PRODUCT: ' PRODUCT $ //
@25 +18 ' 1ST' + 18 ' 2ND' + 18 ' 3RD' + 18 ' 4TH'
' TOTAL' /
@25 ' JAN FEB MAR QTR APR MAY JUN QTR'
' JUL AUG SEP QTR OCT NOV DEC QTR YEAR'/
@25 17*' ___';
PUT #15 'SALES UNITS' // 'GROSS SALES' // ' RETURNS' ///
'ADJ. GROSS SALES' // ' CASH DISCOUNT' //
'NET SALES ' //// ' MGF. COST AT STD.'//
' ROYALTIES ' // 'TOTAL COST OF GOODS SOLD'////
'GROSS MARGIN' ////
' DISTRIBUTION' // ' ADVERTISING ' //
' AGENCY FEES' / ' FLAT MAIL' / ' SAMPLE MAIL'/
' SALESMEN''S SAMPLES' / ' PRODUCT LITERATURE ' /
' MISC. PROMOTION' // ' TOTAL PROMOTION' ////
'PRODUCT CONTRIBUTION ';
RETURN;
RUN;
These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.
SALES
OBS MONTH SUNITS GSALES RETURN DISCOUNT MFG_COST ROYALTY DIST ADVTSNG PROMO1 PROMO2 PROMO3 PROMO4 PROMO5 PROMO6 PRODUCT
1 1 285 296 24 4 33 _ 4 _ _ _ _ 40 3 _ SOMATOL
2 2 225 234 19 3 26 _ 3 _ _ _ _ 36 _ _ SOMATOL
3 3 291 301 25 4 33 _ 3 _ _ _ _ 36 _ _ SOMATOL
4 4 158 164 14 2 18 _ 2 _ _ _ _ 24 _ _ SOMATOL
5 5 140 145 12 2 16 _ 2 _ _ _ _ 24 _ _ SOMATOL
6 6 109 113 9 2 12 _ 2 _ _ _ _ 24 _ _ SOMATOL
7 7 84 86 7 1 10 _ 1 _ _ _ 20 21 9 _ SOMATOL
8 8 125 130 11 2 14 _ 1 _ _ _ 20 22 6 _ SOMATOL
9 9 167 174 14 3 19 _ 2 _ _ _ 5 42 6 _ SOMATOL
10 10 204 213 18 3 23 _ 3 _ _ _ 5 44 5 _ SOMATOL
11 11 208 216 18 4 24 _ 3 _ _ _ 5 44 5 _ SOMATOL
12 12 105 110 9 2 12 _ 2 _ _ _ 5 44 5 _ SOMATOL
13 1 219 212 17 4 21 _ 2 _ _ _ _ _ _ _ ZENATRIL
14 2 176 170 14 4 21 _ 2 _ _ _ _ _ _ _ ZENATRIL
15 3 238 228 19 3 21 _ 3 _ _ _ _ _ _ _ ZENATRIL
16 4 100 97 8 2 10 _ 1 _ _ _ _ _ _ _ ZENATRIL
17 5 93 89 7 1 9 _ 1 _ _ _ _ _ _ _ ZENATRIL
18 6 70 68 6 1 7 _ 1 _ _ _ _ _ _ _ ZENATRIL
19 7 59 58 5 1 5 _ 1 _ _ _ _ _ _ _ ZENATRIL
20 8 122 118 10 2 12 _ 1 _ _ _ _ _ _ _ ZENATRIL
21 9 157 150 12 2 15 _ 2 _ _ _ _ _ _ _ ZENATRIL
22 10 177 171 14 2 18 _ 2 _ _ _ _ _ _ _ ZENATRIL
23 11 173 167 14 2 16 _ 2 _ _ _ _ _ _ _ ZENATRIL
24 12 174 167 14 1 17 _ 2 _ _ _ _ _ _ _ ZENATRIL
PRODUCT=SOMATOL
The MEANS Procedure
Variable N Mean Std Dev Minimum Maximum
-----------------------------------------------------------------------------
SUNITS 4 525.2500000 193.5327276 376.0000000 801.0000000
GSALES 4 545.5000000 200.8191558 390.0000000 831.0000000
RETURN 4 45.0000000 16.3095064 32.0000000 68.0000000
AGSALES 4 500.5000000 184.5146787 358.0000000 763.0000000
DISCOUNT 4 8.0000000 2.4494897 6.0000000 11.0000000
NSALES 4 492.5000000 182.1803136 352.0000000 752.0000000
MFG_COST 4 60.0000000 22.4350916 43.0000000 92.0000000
ROYALTY 0 _ _ _ _
TCOST 4 60.0000000 22.4350916 43.0000000 92.0000000
MARGIN 4 432.5000000 159.7466745 309.0000000 660.0000000
DIST 4 7.0000000 2.5819889 4.0000000 10.0000000
ADVTSNG 0 _ _ _ _
PROMO1 0 _ _ _ _
PROMO2 0 _ _ _ _
PROMO3 2 30.0000000 21.2132034 15.0000000 45.0000000
PROMO4 4 100.2500000 26.9366541 72.0000000 132.0000000
PROMO5 3 13.0000000 9.1651514 3.0000000 21.0000000
PROMO6 0 _ _ _ _
TPROMO 4 125.0000000 40.6366009 72.0000000 162.0000000
PC 4 300.5000000 163.6306817 154.0000000 535.0000000
-----------------------------------------------------------------------------
PRODUCT=ZENATRIL
Variable N Mean Std Dev Minimum Maximum
-----------------------------------------------------------------------------
SUNITS 4 439.5000000 169.3487526 263.0000000 633.0000000
GSALES 4 423.7500000 162.9527027 254.0000000 610.0000000
RETURN 4 35.0000000 13.3416641 21.0000000 50.0000000
AGSALES 4 388.7500000 149.6136692 233.0000000 560.0000000
DISCOUNT 4 6.2500000 3.2015621 4.0000000 11.0000000
NSALES 4 382.5000000 146.9886617 229.0000000 549.0000000
MFG_COST 4 43.0000000 17.0684895 26.0000000 63.0000000
ROYALTY 0 _ _ _ _
TCOST 4 43.0000000 17.0684895 26.0000000 63.0000000
MARGIN 4 339.5000000 129.9448601 203.0000000 486.0000000
DIST 4 5.0000000 1.8257419 3.0000000 7.0000000
ADVTSNG 0 _ _ _ _
PROMO1 0 _ _ _ _
PROMO2 0 _ _ _ _
PROMO3 0 _ _ _ _
PROMO4 0 _ _ _ _
PROMO5 0 _ _ _ _
PROMO6 0 _ _ _ _
TPROMO 0 _ _ _ _
PC 4 334.5000000 128.1210365 200.0000000 479.0000000
-----------------------------------------------------------------------------
SALES
D M
I F R A P Q A
S G R S G O D P P P P P P R U G N M T _ _ C
M U S E C _ Y V R R R R R R O A S S T A P T F O
O N A T O C A D T O O O O O O D R A A C R R Y R L
O N I L U U O L I S M M M M M M U T L L O G O P E U
B T T E R N S T S N O O O O O O C E E E S I M P E Q M
S H S S N T T Y T G 1 2 3 4 5 6 T R S S T N O C _ _ N
1 1 285 296 24 4 33 _ 4 _ _ _ _ 40 3 _ SOMATOL 1 272 268 33 235 43 188 _ _ 1
2 2 225 234 19 3 26 _ 3 _ _ _ _ 36 _ _ SOMATOL 1 215 212 26 186 36 147 _ _ 2
3 3 291 301 25 4 33 _ 3 _ _ _ _ 36 _ _ SOMATOL 1 276 272 33 239 36 200 _ _ 3
4 _ 801 831 68 11 92 _ 10 _ _ _ _ 112 3 _ SOMATOL 1 763 752 92 660 115 535 0 3 4
5 4 158 164 14 2 18 _ 2 _ _ _ _ 24 _ _ SOMATOL 2 150 148 18 130 24 104 _ _ 5
6 5 140 145 12 2 16 _ 2 _ _ _ _ 24 _ _ SOMATOL 2 133 131 16 115 24 89 _ _ 6
7 6 109 113 9 2 12 _ 2 _ _ _ _ 24 _ _ SOMATOL 2 104 102 12 90 24 64 _ _ 7
8 _ 407 422 35 6 46 _ 6 _ _ _ _ 72 _ _ SOMATOL 2 387 381 46 335 72 257 0 3 8
9 7 84 86 7 1 10 _ 1 _ _ _ 20 21 9 _ SOMATOL 3 79 78 10 68 50 17 _ _ 9
10 8 125 130 11 2 14 _ 1 _ _ _ 20 22 6 _ SOMATOL 3 119 117 14 103 48 54 _ _ 10
11 9 167 174 14 3 19 _ 2 _ _ _ 5 42 6 _ SOMATOL 3 160 157 19 138 53 83 _ _ 11
12 _ 376 390 32 6 43 _ 4 _ _ _ 45 85 21 _ SOMATOL 3 358 352 43 309 151 154 0 3 12
13 10 204 213 18 3 23 _ 3 _ _ _ 5 44 5 _ SOMATOL 4 195 192 23 169 54 112 _ _ 13
14 11 208 216 18 4 24 _ 3 _ _ _ 5 44 5 _ SOMATOL 4 198 194 24 170 54 113 _ _ 14
15 12 105 110 9 2 12 _ 2 _ _ _ 5 44 5 _ SOMATOL 4 101 99 12 87 54 31 _ _ 15
16 _ 517 539 45 9 59 _ 8 _ _ _ 15 132 15 _ SOMATOL 4 494 485 59 426 162 256 0 3 16
17 _ 2101 2182 180 32 240 _ 28 _ _ _ 60 401 39 _ SOMATOL _ 2002 1970 240 1730 500 1202 0 4 17
18 1 219 212 17 4 21 _ 2 _ _ _ _ _ _ _ ZENATRIL 1 195 191 21 170 _ 168 _ _ 1
19 2 176 170 14 4 21 _ 2 _ _ _ _ _ _ _ ZENATRIL 1 156 152 21 131 _ 129 _ _ 2
20 3 238 228 19 3 21 _ 3 _ _ _ _ _ _ _ ZENATRIL 1 209 206 21 185 _ 182 _ _ 3
21 _ 633 610 50 11 63 _ 7 _ _ _ _ _ _ _ ZENATRIL 1 560 549 63 486 _ 479 0 3 4
22 4 100 97 8 2 10 _ 1 _ _ _ _ _ _ _ ZENATRIL 2 89 87 10 77 _ 76 _ _ 5
23 5 93 89 7 1 9 _ 1 _ _ _ _ _ _ _ ZENATRIL 2 82 81 9 72 _ 71 _ _ 6
24 6 70 68 6 1 7 _ 1 _ _ _ _ _ _ _ ZENATRIL 2 62 61 7 54 _ 53 _ _ 7
25 _ 263 254 21 4 26 _ 3 _ _ _ _ _ _ _ ZENATRIL 2 233 229 26 203 _ 200 0 3 8
26 7 59 58 5 1 5 _ 1 _ _ _ _ _ _ _ ZENATRIL 3 53 52 5 47 _ 46 _ _ 9
27 8 122 118 10 2 12 _ 1 _ _ _ _ _ _ _ ZENATRIL 3 108 106 12 94 _ 93 _ _ 10
28 9 157 150 12 2 15 _ 2 _ _ _ _ _ _ _ ZENATRIL 3 138 136 15 121 _ 119 _ _ 11
29 _ 338 326 27 5 32 _ 4 _ _ _ _ _ _ _ ZENATRIL 3 299 294 32 262 _ 258 0 3 12
30 10 177 171 14 2 18 _ 2 _ _ _ _ _ _ _ ZENATRIL 4 157 155 18 137 _ 135 _ _ 13
31 11 173 167 14 2 16 _ 2 _ _ _ _ _ _ _ ZENATRIL 4 153 151 16 135 _ 133 _ _ 14
32 12 174 167 14 1 17 _ 2 _ _ _ _ _ _ _ ZENATRIL 4 153 152 17 135 _ 133 _ _ 15
33 _ 524 505 42 5 51 _ 6 _ _ _ _ _ _ _ ZENATRIL 4 463 458 51 407 _ 401 0 3 16
34 _ 1758 1695 140 25 172 _ 20 _ _ _ _ _ _ _ ZENATRIL _ 1555 1530 172 1358 _ 1338 0 4 17
Output from DATA _NULL_
CRYSTAL-BRAMBLE DRUG COMPANY
1977 PRODUCT CONTRIBUTION WORKSHEET
PRODUCT: SOMATOL
1ST 2ND 3RD 4TH TOTAL
JAN FEB MAR QTR APR MAY JUN QTR JUL AUG SEP QTR OCT NOV DEC QTR YEAR
___ ___ ___ ___ ___ ___ ___ ___ ___ ___ ___ ___ ___ ___ ___ ___ ___
SALES UNITS 285 225 291 801 158 140 109 407 84 125 167 376 204 208 105 517 2101
GROSS SALES 296 234 301 831 164 145 113 422 86 130 174 390 213 216 110 539 2182
RETURNS 24 19 25 68 14 12 9 35 7 11 14 32 18 18 9 45 180
ADJ. GROSS SALES 272 215 276 763 150 133 104 387 79 119 160 358 195 198 101 494 2002
CASH DISCOUNT 4 3 4 11 2 2 2 6 1 2 3 6 3 4 2 9 32
NET SALES 268 212 272 752 148 131 102 381 78 117 157 352 192 194 99 485 1970
MGF. COST AT STD. 33 26 33 92 18 16 12 46 10 14 19 43 23 24 12 59 240
ROYALTIES _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
TOTAL COST OF GOODS SOLD 33 26 33 92 18 16 12 46 10 14 19 43 23 24 12 59 240
GROSS MARGIN 235 186 239 660 130 115 90 335 68 103 138 309 169 170 87 426 1730
DISTRIBUTION 4 3 3 10 2 2 2 6 1 1 2 4 3 3 2 8 28
ADVERTISING _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
AGENCY FEES _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
FLAT MAIL _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
SAMPLE MAIL _ _ _ _ _ _ _ _ 20 20 5 45 5 5 5 15 60
SALESMEN'S SAMPLES 40 36 36 112 24 24 24 72 21 22 42 85 44 44 44 132 401
PRODUCT LITERATURE 3 _ _ 3 _ _ _ _ 9 6 6 21 5 5 5 15 39
MISC. PROMOTION _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
TOTAL PROMOTION 43 36 36 115 24 24 24 72 50 48 53 151 54 54 54 162 500
PRODUCT CONTRIBUTION 188 147 200 535 104 89 64 257 17 54 83 154 112 113 31 256 1202
CRYSTAL-BRAMBLE DRUG COMPANY
1977 PRODUCT CONTRIBUTION WORKSHEET
PRODUCT: ZENATRIL
1ST 2ND 3RD 4TH TOTAL
JAN FEB MAR QTR APR MAY JUN QTR JUL AUG SEP QTR OCT NOV DEC QTR YEAR
___ ___ ___ ___ ___ ___ ___ ___ ___ ___ ___ ___ ___ ___ ___ ___ ___
SALES UNITS 219 176 238 633 100 93 70 263 59 122 157 338 177 173 174 524 1758
GROSS SALES 212 170 228 610 97 89 68 254 58 118 150 326 171 167 167 505 1695
RETURNS 17 14 19 50 8 7 6 21 5 10 12 27 14 14 14 42 140
ADJ. GROSS SALES 195 156 209 560 89 82 62 233 53 108 138 299 157 153 153 463 1555
CASH DISCOUNT 4 4 3 11 2 1 1 4 1 2 2 5 2 2 1 5 25
NET SALES 191 152 206 549 87 81 61 229 52 106 136 294 155 151 152 458 1530
MGF. COST AT STD. 21 21 21 63 10 9 7 26 5 12 15 32 18 16 17 51 172
ROYALTIES _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
TOTAL COST OF GOODS SOLD 21 21 21 63 10 9 7 26 5 12 15 32 18 16 17 51 172
GROSS MARGIN 170 131 185 486 77 72 54 203 47 94 121 262 137 135 135 407 1358
DISTRIBUTION 2 2 3 7 1 1 1 3 1 1 2 4 2 2 2 6 20
ADVERTISING _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
AGENCY FEES _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
FLAT MAIL _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
SAMPLE MAIL _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
SALESMEN'S SAMPLES _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
PRODUCT LITERATURE _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
MISC. PROMOTION _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
TOTAL PROMOTION _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
PRODUCT CONTRIBUTION 168 129 182 479 76 71 53 200 46 93 119 258 135 133 133 401 1338
This example demonstrates how to write a report using PUT statement.
| Type: | Sample |
| Topic: | SAS Reference ==> DATA Step Query and Reporting ==> Creating Reports ==> Non Graphical |
| Date Modified: | 2005-12-08 11:34:46 |
| Date Created: | 2005-05-23 13:53:02 |
Operating System and Release Information
| Product Family | Product | Host | SAS Release | |
| Starting | Ending | |||
| SAS System | Base SAS | All | n/a | n/a |
