This sample is from the SAS Sample Library. For additional information refer to "SAS Output Delivery System: User's Guide".
/****************************************************************/
/* S A S S A M P L E L I B R A R Y */
/* */
/* NAME: ODSTPL4 */
/* TITLE: Demonstrates ODS and Data Step using PROC TEMPLATE */
/* PRODUCT: BASE */
/* SYSTEM: ALL */
/* KEYS: ODS HTML PATH TEMPLATE */
/* PROCS: TEMPLATE */
/* DATA: */
/* SUPPORT: UPDATE: */
/* REF: */
/* MISC: */
/* */
/****************************************************************/
option linesize=100;
/* The Data Step will generate Monospace Listing Output. */
data ssn;
length lname $15 fname $10;
input lname fname ssn;
lname = substr(lname,1,(length(lname)-1));
cards;
Malone, Eric 791387737
Cappy, Jim 416616782
Gosselin, Jason 131175969
Dalness, Judy 813507045
Miller, Connie 012627035
Boone, Jerry 491137152
Parker, Slava 321693100
Austin, Jim 060333333
Berryman, Mandy 219316284
Turnley, Robin 543467735
Cole, Kent 064455555
Adams, Kevin 816637197
Stallmann, Anna 539134092
O'Connor, Todd 641112399
Ryals, Gloria 922756262
Knittle, Tammy 524196394
Tindall, Daniel 941035041
Ragland, Nancy 023016047
Thies, Jim 025896724
Agnew, Wei 289033423
Antle, Joseph 462822222
Heffner, Tony 848902408
Saunders, Ronnie 622596389
Mortensen, Mike 945733019
Kushner, Paul 215656505
Fiala, Pat 415611111
Pendergrass, Mark 943533774
Quattlebaum, David 613496606
Weathers, Charles 530385671
Valmassoi, Lisa 891577562
Ripperton, Donna 607747616
Angeli, Bruce 647922153
DeBoskey, Virgil 216857117
O'Connor, Charles 816806785
Taylor, Peter 015386729
Rausch, Michael 999999999
Chandler, Jerry 213266915
Sherron, Kenneth 621506318
Wu, Teresa 412607099
Hunley, Martha 838944115
Hilburger, Mike 719447766
Tawiah, Harriet 208227137
McKenzie, Nancy 613487157
McLeod, Terri 543545565
Stevenson, Stuart 606307666
Nelson, Tom 702387517
Womble, Rick 432432434
Katz, Al 125544444
Bravo, David 926677120
Dunbar, Tamara 141085263
Lohela, Deanna 219556645
Gould, Randy 711406871
Bloom, Tom 320226114
Bestelmeyer, Susan 327336614
Robinson, Allen 047932351
Whitehead, Vicki 092277961
Heffner, Bobby 085597677
Secosky, Beth 214127714
Moore, Gwen 703327711
White, Michelle 612117444
Cohen, John 818396646
Rubes, Walter 402577531
Whitcher, John 945124861
Coggins, William 102777642
;
run;
/* Sorting the Data Set. */
proc sort data=ssn;
by lname fname ssn;
run;
/* Redirect location of template stores so that ODS will */
/* find our Customized Template first. */
ods path work.template(update) sashelp.tmplmst(read);
/* Now lets Customize the Template !!! */
proc template;
define table datastep.ssn;
column name ssn;
header sptitle1;
panels=2;
define name;
header = 'Last, First Name' format=$20.;
end;
define ssn;
header = 'SSN' format=ssn.;
end;
define sptitle1;
text "Student Social Security Numbers";
underline;
end;
end;
run;
/* Now lets see Data Step Output using the Customized */
/* Template. */
ods listing;
title2 'SSN Data Step Example - Customized Table Template';
data empssn;
length name $30;
file print ods=(template='datastep.ssn');
set ssn;
name = trim(lname) || ', ' || fname;
put _ods_;
run;
/* What would the output look like without the */
/* Customized Template? */
title2 'SSN Data Step Example - Default Table Template';
data empssn;
length name $30;
file print ods;
set ssn;
name = trim(lname) || ', ' || fname;
put _ods_;
run;
/* Remove the Customized Template for the Data Step. */
proc template;
delete datastep.ssn;
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.
SSN Data Step Example - Customized Table Template
Student Social Security Numbers
----------------------------------------------------------------------------------------------------
Last, First Name SSN Last, First Name SSN
Adams, Kevin 816-63-7197 Sherron, Kenneth 621-50-6318
Agnew, Wei 289-03-3423 Stallmann, Anna 539-13-4092
Angeli, Bruce 647-92-2153 Stevenson, Stuart 606-30-7666
Antle, Joseph 462-82-2222 Tawiah, Harriet 208-22-7137
Austin, Jim 060-33-3333 Taylor, Peter 015-38-6729
Berryman, Mandy 219-31-6284 Thies, Jim 025-89-6724
Bestelmeyer, Susan 327-33-6614 Tindall, Daniel 941-03-5041
Bloom, Tom 320-22-6114 Turnley, Robin 543-46-7735
Boone, Jerry 491-13-7152 Valmassoi, Lisa 891-57-7562
Bravo, David 926-67-7120 Weathers, Charles 530-38-5671
Cappy, Jim 416-61-6782 Whitcher, John 945-12-4861
Chandler, Jerry 213-26-6915 White, Michelle 612-11-7444
Coggins, William 102-77-7642 Whitehead, Vicki 092-27-7961
Cohen, John 818-39-6646 Womble, Rick 432-43-2434
Cole, Kent 064-45-5555 Wu, Teresa 412-60-7099
Dalness, Judy 813-50-7045
DeBoskey, Virgil 216-85-7117
Dunbar, Tamara 141-08-5263
Fiala, Pat 415-61-1111
Gosselin, Jason 131-17-5969
Gould, Randy 711-40-6871
Heffner, Bobby 085-59-7677
Heffner, Tony 848-90-2408
Hilburger, Mike 719-44-7766
Hunley, Martha 838-94-4115
Katz, Al 125-54-4444
Knittle, Tammy 524-19-6394
Kushner, Paul 215-65-6505
Lohela, Deanna 219-55-6645
Malone, Eric 791-38-7737
McKenzie, Nancy 613-48-7157
McLeod, Terri 543-54-5565
Miller, Connie 012-62-7035
Moore, Gwen 703-32-7711
Mortensen, Mike 945-73-3019
Nelson, Tom 702-38-7517
O'Connor, Charles 816-80-6785
O'Connor, Todd 641-11-2399
Parker, Slava 321-69-3100
Pendergrass, Mark 943-53-3774
Quattlebaum, David 613-49-6606
Ragland, Nancy 023-01-6047
Rausch, Michael 999-99-9999
Ripperton, Donna 607-74-7616
Robinson, Allen 047-93-2351
Rubes, Walter 402-57-7531
Ryals, Gloria 922-75-6262
Saunders, Ronnie 622-59-6389
Secosky, Beth 214-12-7714
SSN Data Step Example - Default Table Template
name lname fname ssn
Adams, Kevin Adams Kevin 816637197
Agnew, Wei Agnew Wei 289033423
Angeli, Bruce Angeli Bruce 647922153
Antle, Joseph Antle Joseph 462822222
Austin, Jim Austin Jim 60333333
Berryman, Mandy Berryman Mandy 219316284
Bestelmeyer, Susan Bestelmeyer Susan 327336614
Bloom, Tom Bloom Tom 320226114
Boone, Jerry Boone Jerry 491137152
Bravo, David Bravo David 926677120
Cappy, Jim Cappy Jim 416616782
Chandler, Jerry Chandler Jerry 213266915
Coggins, William Coggins William 102777642
Cohen, John Cohen John 818396646
Cole, Kent Cole Kent 64455555
Dalness, Judy Dalness Judy 813507045
DeBoskey, Virgil DeBoskey Virgil 216857117
Dunbar, Tamara Dunbar Tamara 141085263
Fiala, Pat Fiala Pat 415611111
Gosselin, Jason Gosselin Jason 131175969
Gould, Randy Gould Randy 711406871
Heffner, Bobby Heffner Bobby 85597677
Heffner, Tony Heffner Tony 848902408
Hilburger, Mike Hilburger Mike 719447766
Hunley, Martha Hunley Martha 838944115
Katz, Al Katz Al 125544444
Knittle, Tammy Knittle Tammy 524196394
Kushner, Paul Kushner Paul 215656505
Lohela, Deanna Lohela Deanna 219556645
Malone, Eric Malone Eric 791387737
McKenzie, Nancy McKenzie Nancy 613487157
McLeod, Terri McLeod Terri 543545565
Miller, Connie Miller Connie 12627035
Moore, Gwen Moore Gwen 703327711
Mortensen, Mike Mortensen Mike 945733019
Nelson, Tom Nelson Tom 702387517
O'Connor, Charles O'Connor Charles 816806785
O'Connor, Todd O'Connor Todd 641112399
Parker, Slava Parker Slava 321693100
Pendergrass, Mark Pendergrass Mark 943533774
Quattlebaum, David Quattlebaum David 613496606
Ragland, Nancy Ragland Nancy 23016047
Rausch, Michael Rausch Michael 999999999
Ripperton, Donna Ripperton Donna 607747616
Robinson, Allen Robinson Allen 47932351
Rubes, Walter Rubes Walter 402577531
Ryals, Gloria Ryals Gloria 922756262
Saunders, Ronnie Saunders Ronnie 622596389
Secosky, Beth Secosky Beth 214127714
Sherron, Kenneth Sherron Kenneth 621506318
Stallmann, Anna Stallmann Anna 539134092
Stevenson, Stuart Stevenson Stuart 606307666
Tawiah, Harriet Tawiah Harriet 208227137
Taylor, Peter Taylor Peter 15386729
Thies, Jim Thies Jim 25896724
Tindall, Daniel Tindall Daniel 941035041
Turnley, Robin Turnley Robin 543467735
Valmassoi, Lisa Valmassoi Lisa 891577562
Weathers, Charles Weathers Charles 530385671
Whitcher, John Whitcher John 945124861
White, Michelle White Michelle 612117444
Whitehead, Vicki Whitehead Vicki 92277961
Womble, Rick Womble Rick 432432434
Wu, Teresa Wu Teresa 412607099