Notes6 4pp

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 23666.12 PERRY ROBERT A. FLTAT 21957.71 Suppress the Obs column PROC Step proc print data=st.empdata; id JobCode; var EmpID Salary; run; The SAS System Job Code Emp ID Salary PILOT FLTAT FLTAT 0031 0040 0071 50221.62 23666.12 21957.71 When the ID and BY statements specify the same variable, • the Obs column is suppressed • the BY line is suppressed • the ID/BY variable prints in the leftmost column • each ID/BY value only prints at the start of each BY group (and on the subtotal line, if a SUM statement is used). 37 Special BY-Group Formatting 38 Special BY-Group Formatting The SAS System Specify JobCode in the BY and ID statements to change the report format. Job Code LastName FirstName Salary FLTAT proc sort data=st.empdata out=work.empdata; by JobCode; run; proc print data=work.empdata; by JobCode; id JobCode; sum Salary; run; Emp ID 0040 0071 0091 0106 WILLIAMS PERRY SCOTT THACKER ARLENE M. ROBERT A. HARVEY F. DAVID S. 23666.12 21957.71 32278.40 24161.14 --------102063.37 0031 0082 0355 0366 GOLDENBERG MCGWIERMCGWIER-WATTS BELL GLENN DESIREE CHRISTINA THOMAS B. MARTHA S. 50221.62 96387.39 59803.16 120202.38 --------326614.55 ========= 428677.92 ----FLTAT PILOT ----PILOT 39 40 10 Defining Titles and Footnotes Defining Titles and Footnotes • You use titles and footnotes to enhance reports. • General form of the TITLE statement: TITLEn 'text '; Features of titles: • Titles appear at the top of the page. • The default title is The SAS System. The • The value of n can be from 1 to 10. • An unnumbered TITLE is equivalent to TITLE1. • Titles remain in effect until they are changed, cancelled, or you end your SAS session. • The null TITLE statement, title;, cancels all titles. •General form of the FOOTNOTE statement: FOOTNOTEn 'text '; Examples: title1 'Flight Crew Employee Listing'; footnote2 'Employee Review'; 41 Defining Titles and Footnotes 42 Changing Titles and Footnotes Features of footnotes: TITLEn or FOOTNOTEn • replaces a previous title or footnote with the same number • cancels all titles or footnotes with higher numbers. • • • • Footnotes appear at the bottom of the page. No footnote is printed unless one is specified. The value of n can be from 1 to 10. An unnumbered FOOTNOTE is equivalent to FOOTNOTE1. • Footnotes remain in effect until they are changed, cancelled, or you end your SAS session. • The null FOOTNOTE statement, footnote;, cancels all footnotes. 43 44 11 Defining Titles and Footnotes Defining Titles and Footnotes PROC PRINT Code proc print data=work.march; title1 'The First Line'; title2 'The Second Line'; run; Resultant Title(s) PROC PRINT Code proc print data=work.march; title1 'The First Line'; title2 'The Second Line'; run; proc print data=work.march; title2 'The Next Line'; run; proc print data=work.march; title2 'The Next Line'; run; proc print data=work.march; title 'The Top Line'; run; proc print data=work.march; title 'The Top Line'; run; proc print data=work.march; title3 'The Thi...
View Full Document

This note was uploaded on 09/25/2013 for the course STAT 440 taught by Professor Muyot,m during the Fall '08 term at University of Illinois, Urbana Champaign.

Ask a homework question - tutors are online