notes6 - Overview of PROC PRINT List reports are typically...

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: Overview of PROC PRINT List reports are typically generated with the PRINT procedure. Notes 6: Producing List Reports and Sorting Data The SAS System Emp ID 0031 0040 0071 0082 0091 0106 0355 0366 Job Code PILOT FLTAT FLTAT PILOT FLTAT FLTAT PILOT PILOT Obs 1 2 3 4 5 6 7 8 LastName GOLDENBERG WILLIAMS PERRY MCGWIERMCGWIER-WATTS SCOTT THACKER BELL GLENN FirstName DESIREE ARLENE M. ROBERT A. CHRISTINA HARVEY F. DAVID S. THOMAS B. MARTHA S. Salary 50221.62 23666.12 21957.71 96387.39 32278.40 24161.14 59803.16 120202.38 1 2 Overview of PROC PRINT You can display titles and footnotes descriptive column headings formatted data values. Salary Report Emp ID 0031 0040 0071 0082 0091 0106 0355 0366 Job Code PILOT FLTAT FLTAT PILOT FLTAT FLTAT PILOT PILOT Annual Salary $50,221.62 $23,666.12 $21,957.71 $96,387.39 $32,278.40 $24,161.14 $59,803.16 $120,202.38 3 Overview of PROC PRINT You can display column totals column subtotals page breaks for each subgroup. The SAS System ------------------------ JobCode=FLTAT ------------------------Emp ID 0040 0071 0091 0106 Obs 1 2 3 4 5 6 7 8 LastName GOLDENBERG WILLIAMS PERRY MCGWIERMCGWIER-WATTS SCOTT THACKER BELL GLENN FirstName DESIREE ARLENE M. ROBERT A. CHRISTINA HARVEY F. DAVID S. THOMAS B. MARTHA S. Obs 1 2 3 4 ------JobCode LastName WILLIAMS PERRY SCOTT THACKER FirstName ARLENE M. ROBERT A. HARVEY F. DAVID S. Salary 23666.12 21957.71 32278.40 24161.14 --------102063.37 4 Overview of PROC PRINT The SAS System ------------------------ JobCode=PILOT ------------------------Emp ID 0031 0082 0355 0366 Creating a Default List Report General form of the PRINT procedure: PROC PRINT DATA=SAS-data-set; PROC PRINT DATA=SAS-data-set; RUN; RUN; Obs 5 6 7 8 ------JobCode LastName GOLDENBERG MCGWIERMCGWIER-WATTS BELL GLENN FirstName DESIREE CHRISTINA THOMAS B. MARTHA S. Salary 50221.62 96387.39 59803.16 120202.38 --------326614.55 ========= 428677.92 Example: libname st 'D:\Stat 440'; proc print data=st.empdata; run; 5 6 1 Printing Selected Variables The VAR statement enables you to select variables to include in the report define the order of the variables in the report. Printing Selected Variables st.empdata EmpID 0031 0040 0071 LastName WILLIAMS PERRY FirstName JobCode PILOT ARLENE M. FLTAT ROBERT A. FLTAT Salary 50221.62 23666.12 21957.71 GOLDENBERG DESIREE PROC Step Select and order proc print data=st.empdata; var JobCode EmpID Salary; variables to print run; The SAS System Job Code PILOT FLTAT FLTAT Emp ID 0031 0040 0071 General form of the VAR statement: VAR variable(s); VAR variable(s); Obs 1 2 3 7 Salary 50221.62 23666.12 21957.71 8 Suppressing the Obs Column The NOOBS option suppresses the row numbers on the left side of the report. General form of the NOOBS option: PROC PRINT DATA=SAS-data-set NOOBS; PROC PRINT DATA=SAS-data-set NOOBS; RUN; RUN; Suppressing the Obs Column st.empdata EmpID 0031 0040 0071 LastName WILLIAMS PERRY FirstName JobCode PILOT ARLENE M. FLTAT ROBERT A. FLTAT Salary 50221.62 23666.12 21957.71 GOLDENBERG DESIREE PROC Step Suppress the proc print data=st.empdata noobs; var JobCode EmpID Salary; Obs column run; The SAS System Job Code PILOT FLTAT FLTAT 9 Emp ID 0031 0040 0071 Salary 50221.62 23666.12 21957.71 10 c04s1d3 Subsetting Data: WHERE Statement The WHERE statement enables you to select observations that meet a certain condition can be used with most SAS procedures. Example: Produce a listing report that displays information for pilots only. Subsetting Data: WHERE Statement General form of the WHERE statement: WHERE where-expression; WHERE where-expression; where-expression is a sequence of operands and operators. Operands include variables constants. 11 12 2 Subsetting Data: WHERE Statement Operators include comparison operators logical operators special operators functions. Comparison Operators Mnemonic Symbol EQ NE = ^= = ~= > < >= <= Definition equal to not equal to GT LT GE LE IN 13 greater than less than greater than or equal to less than or equal to equal to one of a list 14 Comparison Operators Examples: where Salary>25000; where EmpID='0082'; where Salary=.; where LastName=' '; where JobCode in('PILOT','FLTAT'); where JobCode in('PILOT' 'FLTAT'); Character comparisons are case-sensitive. The IN operator allows commas or blanks to separate values. Logical Operators AND if both expressions are true, then the compound expression is true & where JobCode='FLTAT' and Salary>50000; OR if either expression is true, then the | compound expression is true where JobCode='PILOT' or JobCode='FLTAT'; NOT can be combined with other operators to reverse the logic of a comparison. ^ where JobCode not in('PILOT','FLTAT'); 15 16 Special Operators BETWEEN-AND selects observations in which the value of the variable falls within a range of values, inclusively. Special Operators Additional special operators supported by the WHERE statement are LIKE sounds like IS MISSING (or IS NULL). where Salary between 50000 and 70000; CONTAINS selects observations that include the specified substring. ? where LastName ? 'LAM'; (LAMBERT, BELLAMY, and ELAM are selected.) 17 18 3 The following are special operators : LIKE selects observations by comparing character values to specified patterns. A percent sign (%) replaces any number of characters. An underscore (_) replaces one character. where Code like 'E_U%'; Selects observations where the value of Code begins with an E, followed by a single character, followed by a U, followed by any number of characters. 19 Special Operators Special Operators The sounds like (=*) operator selects observations that contain spelling variations of the word or words specified. where Name=*'SMITH'; Selects names like SMYTHE and SMITT. IS NULL or IS MISSING selects observations in which the value of the variable is missing. where Flight is missing; where Flight is null; 20 Printing Selected Observations Use the WHERE statement to control which observations are processed. EmpID 0031 0040 0071 LastName WILLIAMS PERRY FirstName JobCode PILOT ARLENE M. FLTAT Salary 50221.62 23666.12 GOLDENBERG DESIREE Subsetting Data: Data Set Options Data set options are applied to data sets resulting in certain actions such as processing the first or last n observations. FIRSTOBS=n specifies that processing is to start from the nth observation. OBS=n specifies that processing is to stop after the nth observation. These can be used separately or together. 21 22 st.empdata Select rows to print ROBERT A. FLTAT 21957.71 PROC Step proc print data=st.empdata noobs; var JobCode EmpID Salary; where JobCode='PILOT'; run; The SAS System Job Code PILOT PILOT PILOT PILOT Emp ID 0031 0082 0355 0366 Salary 50221.62 96387.39 59803.16 120202.38 Subsetting Data: Data Set Options Syntax: ... Data-set(data-set option) ... ... Data-set(data-set option) ... Requesting Column Totals The SUM statement produces column totals. General form of the SUM statement: SUM variable(s); SUM variable(s); Applied to data sets in a DATA step or PROC step: proc print data=st.empdata(firstobs=2 obs=5); run; The SUM statement also produces subtotals if you print the data in groups. 23 24 4 Requesting Column Totals EmpID 0031 0040 0071 LastName WILLIAMS PERRY FirstName JobCode PILOT ARLENE M. FLTAT Salary 50221.62 23666.12 GOLDENBERG DESIREE Sorting a SAS Data Set To request subgroup totals in PROC PRINT, the observations in the data set must be grouped. st.empdata Produce column totals ROBERT A. FLTAT 21957.71 PROC Step proc print data=st.empdata noobs; var JobCode EmpID Salary; sum Salary; run; The SAS System Job Code PILOT FLTAT FLTAT . . ========= 428677.92 25 The SORT procedure rearranges the observations in a SAS data set can create a new SAS data set containing the rearranged observations can sort on multiple variables can sort in ascending (default) or descending order does not generate printed output treats missing values as the smallest possible value. 26 Emp ID 0031 0040 0071 Salary 50221.62 23666.12 21957.71 Sorting a SAS Data Set General form of the PROC SORT step: PROC SORT DATA=input-SAS-data-set PROC SORT DATA=input-SAS-data-set <OUT=output-SAS-data-set>; <OUT=output-SAS-data-set>; BY <DESCENDING> by-variable(s); BY <DESCENDING> by-variable(s); RUN; RUN; Examples: proc sort data=st.empdata; by Salary; run; proc sort data=st.empdata out=work.jobsal; by JobCode descending Salary; run; 27 Sorting a SAS Data Set st.empdata EmpID 0031 0040 0071 LastName WILLIAMS PERRY FirstName JobCode PILOT ARLENE M. FLTAT ROBERT A. FLTAT Salary 50221.62 23666.12 21957.71 GOLDENBERG DESIREE PROC Step proc sort data=st.empdata out=work.empdata; by JobCode; run; work.empdata EmpID 0040 0071 0031 LastName WILLIAMS PERRY FirstName JobCode ARLENE M. FLTAT ROBERT A. FLTAT PILOT Salary 23666.12 21957.71 50221.62 28 GOLDENBERG DESIREE Printing Subtotals and Grand Totals Print the data set grouped by JobCode with a subtotal for the Salary column for each JobCode. proc sort data=st.empdata out=work.empdata; by JobCode; run; proc print data=work.empdata; by JobCode; sum Salary; run; Using a BY statement and a SUM statement together in a PROC PRINT step produces subtotals and grand totals. 29 Printing Subtotals and Grand Totals The SAS System ------------------------ JobCode=FLTAT ------------------------Obs 1 2 3 4 ------JobCode Emp ID 0040 0071 0091 0106 LastName WILLIAMS PERRY SCOTT THACKER FirstName ARLENE M. ROBERT A. HARVEY F. DAVID S. Salary 23666.12 21957.71 32278.40 24161.14 --------102063.37 ------------------------ JobCode=PILOT ------------------------Obs 5 6 7 8 ------JobCode Emp ID 0031 0082 0355 0366 LastName GOLDENBERG MCGWIERMCGWIER-WATTS BELL GLENN FirstName DESIREE CHRISTINA THOMAS B. MARTHA S. Salary 50221.62 96387.39 59803.16 120202.38 --------326614.55 ========= 428677.92 30 5 Printing the Number of Observations Print the data set grouped by JobCode with the number of observations for each JobCode. proc sort data=st.empdata out=work.empdata; by JobCode; run; proc print data=work.empdata n=`Number of Employees = '; by JobCode; run; Using a BY statement and the N= option (in the PROC PRINT statement) together in a PROC PRINT step prints the number of observation for each group . 31 Printing the Number of Observations The SAS System ------------------------ JobCode=FLTAT ------------------------------Obs 1 2 3 4 Emp ID 0040 0071 0091 0106 LastName WILLIAMS PERRY SCOTT THACKER FirstName ARLENE M. ROBERT A. HARVEY F. DAVID S. Salary 23666.12 21957.71 32278.40 24161.14 Number of Employees = 4 ----------------------------------------- JobCode=PILOT ------------------Emp ID 0031 0082 0355 0366 Obs 5 6 7 8 LastName GOLDENBERG MCGWIER-WATTS BELL GLENN FirstName DESIREE CHRISTINA THOMAS B. MARTHA S. Salary 50221.62 96387.39 59803.16 120202.38 Number of Employees = 4 32 Page Breaks Use the PAGEBY statement to put each subgroup on a separate page. General form of the PAGEBY statement: PAGEBY by-variable; PAGEBY by-variable; proc print data=work.empdata; by JobCode; pageby JobCode; sum Salary; run; The PAGEBY statement must be used with a BY statement. 33 Page Breaks First Page The SAS System 1 ------------------------ JobCode=FLTAT ------------------------Emp ID 0040 0071 0091 0106 Obs 1 2 3 4 ------JobCode LastName WILLIAMS PERRY SCOTT THACKER FirstName ARLENE M. ROBERT A. HARVEY F. DAVID S. Salary 23666.12 21957.71 32278.40 24161.14 --------102063.37 34 Page Breaks Second Page The SAS System 2 ------------------------ JobCode=PILOT ------------------------Emp ID 0031 0082 0355 0366 Identifying Observations The ID statement enables you to suppress the Obs column in the report specify which variable(s) should replace the Obs column. Obs 5 6 7 8 ------JobCode LastName GOLDENBERG MCGWIER-WATTS MCGWIERBELL GLENN FirstName DESIREE CHRISTINA THOMAS B. MARTHA S. Salary 50221.62 96387.39 59803.16 120202.38 --------326614.55 ========= 428677.92 General form of the ID statement: ID variable(s); ID variable(s); 35 36 6 Creating a Default List Report st.empdata EmpID 0031 0040 0071 LastName WILLIAMS PERRY FirstName JobCode PILOT ARLENE M. FLTAT ROBERT A. FLTAT Salary 50221.62 23666.12 21957.71 GOLDENBERG DESIREE Special BY-Group Formatting 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). 38 PROC Step Suppress the Obs column proc print data=st.empdata; id JobCode; var EmpID Salary; run; The SAS System Job Code PILOT FLTAT FLTAT Emp ID 0031 0040 0071 Salary 50221.62 23666.12 21957.71 37 Special BY-Group Formatting Specify JobCode in the BY and ID statements to change the report format. proc sort data=st.empdata out=work.empdata; by JobCode; run; proc print data=work.empdata; by JobCode; id JobCode; sum Salary; run; Special BY-Group Formatting The SAS System Job Code FLTAT Emp ID 0040 0071 0091 0106 LastName WILLIAMS PERRY SCOTT THACKER FirstName ARLENE M. ROBERT A. HARVEY F. DAVID S. Salary 23666.12 21957.71 32278.40 24161.14 --------102063.37 50221.62 96387.39 59803.16 120202.38 --------326614.55 ========= 428677.92 40 ----FLTAT PILOT 0031 0082 0355 0366 GOLDENBERG MCGWIERMCGWIER-WATTS BELL GLENN DESIREE CHRISTINA THOMAS B. MARTHA S. ----PILOT 39 Defining Titles and Footnotes You use titles and footnotes to enhance reports. General form of the TITLE statement: TITLEn 'text '; TITLEn 'text '; Defining Titles and Footnotes Features of titles: Titles appear at the top of the page. The default title is The SAS System. System 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. 41 42 General form of the FOOTNOTE statement: FOOTNOTEn 'text '; FOOTNOTEn 'text '; Examples: title1 'Flight Crew Employee Listing'; footnote2 'Employee Review'; 7 Defining Titles and Footnotes Features of footnotes: 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 Changing Titles and Footnotes TITLEn or FOOTNOTEn replaces a previous title or footnote with the same number cancels all titles or footnotes with higher numbers. 44 Defining Titles and Footnotes 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; title 'The Top Line'; run; proc print data=work.march; title3 'The Third Line'; run; proc print data=work.march; title; run; 45 Defining Titles and Footnotes 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; title 'The Top Line'; run; proc print data=work.march; title3 'The Third Line'; run; proc print data=work.march; title; run; 46 Resultant Title(s) Resultant Title(s) The First Line The Second Line ... Defining Titles and Footnotes 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; title 'The Top Line'; run; proc print data=work.march; title3 'The Third Line'; run; proc print data=work.march; title; run; 47 Defining Titles and Footnotes 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; title 'The Top Line'; run; proc print data=work.march; title3 'The Third Line'; run; proc print data=work.march; title; run; 48 Resultant Title(s) The First Line The Second Line Resultant Title(s) The First Line The Second Line The First Line The Next Line The First Line The Next Line The Top Line ... ... 8 Defining Titles and Footnotes 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; title 'The Top Line'; run; proc print data=work.march; title3 'The Third Line'; run; proc print data=work.march; title; run; 49 Defining Titles and Footnotes 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; title 'The Top Line'; run; proc print data=work.march; title3 'The Third Line'; run; proc print data=work.march; title; run; 50 Resultant Title(s) The First Line The Second Line Resultant Title(s) The First Line The Second Line The First Line The Next Line The Top Line The First Line The Next Line The Top Line The Top Line The Third Line The Top Line The Third Line ... ... Assigning Column Labels General form of the LABEL statement: LABEL variable='label' LABEL variable='label' variable='label'; variable='label'; st.empdata EmpID 0031 0040 0071 LastName WILLIAMS PERRY Assigning Column Labels FirstName JobCode PILOT ARLENE M. FLTAT ROBERT A. FLTAT Salary 50221.62 23666.12 21957.71 GOLDENBERG DESIREE 'label' specifies a label up to 256 characters. Labels are used to replace variable names in SAS output automatically by many procedures by the PRINT procedure when the LABEL or SPLIT= option is specified in the PROC PRINT statement. 51 PROC Step proc print data=st.empdata label; label LastName='Last Name' FirstName='First Name' Salary='Annual Salary'; title1 'Salary Report'; run; Salary Report Emp ID 0031 0040 0071 First Name DESIREE ARLENE M. ROBERT A. Job Code PILOT FLTAT FLTAT Annual Salary 50221.62 23666.12 21957.71 Obs 1 2 3 Last Name GOLDENBERG WILLIAMS PERRY 52 st.empdata EmpID 0031 0040 0071 LastName WILLIAMS PERRY Assigning Column Labels FirstName JobCode PILOT ARLENE M. FLTAT ROBERT A. FLTAT Salary 50221.62 23666.12 21957.71 GOLDENBERG DESIREE Using SAS System Options You can use SAS system options to change the appearance of a report. General form of the OPTIONS statement: OPTIONS option ......;; OPTIONS option PROC Step proc print data=st.empdata split=' '; label LastName='Last Name' FirstName='First Name' Salary='Annual Salary'; title1 'Salary Report'; run; Salary Report Emp ID 0031 0040 0071 Last Name GOLDENBERG WILLIAMS PERRY First Name DESIREE ARLENE M. ROBERT A. Job Code PILOT FLTAT FLTAT Annual Salary 50221.62 23666.12 21957.71 The OPTIONS statement is not usually included in a PROC or DATA step. 53 54 Obs 1 2 3 9 Using SAS System Options Selected SAS system options: DATE (default) NODATE prints the date and time the SAS session began at the top of each page of the SAS output. does not to print the date and time the SAS session began. Using SAS System Options Selected SAS system options: NUMBER (default) NONUMBER PAGENO=n specifies that page numbers be printed on the first line of each page of output. specifies that page numbers not be printed. specifies a beginning page number (n) for the next page of SAS output. LINESIZE=width specifies the line size for the SAS log LS=width and SAS output. PAGESIZE=n PS=n specifies the number of lines (n) that can be printed per page of SAS output. Example: options nodate nonumber ls=72; 56 55 Using SAS Formats Enhance the readability of reports by formatting the data values. Salary Report Emp ID 0031 0040 0071 0082 0091 0106 0355 0366 Last Name GOLDENBERG WILLIAMS PERRY MCGWIERMCGWIER-WATTS SCOTT THACKER BELL GLENN First Name DESIREE ARLENE M. ROBERT A. CHRISTINA HARVEY F. DAVID S. THOMAS B. MARTHA S. Job Code PILOT FLTAT FLTAT PILOT FLTAT FLTAT PILOT PILOT Annual Salary $50,221.62 $23,666.12 $21,957.71 $96,387.39 $32,278.40 $24,161.14 $59,803.16 $120,202.38 57 Using User-defined Formats Create custom formats to recode data values in a report. Salary Report in Categories Emp ID 0031 0040 0071 0082 0091 0106 0355 0366 Last Name GOLDENBERG WILLIAMS PERRY MCGWIERMCGWIER-WATTS SCOTT THACKER BELL GLENN First Name DESIREE ARLENE M. ROBERT A. CHRISTINA HARVEY F. DAVID S. THOMAS B. MARTHA S. Annual Salary 50,000 25,000 25,000 50,000 50,000 25,000 50,000 50,000 JobCode Pilot Flight Flight Pilot Flight Flight Pilot Pilot Obs 1 2 3 4 5 6 7 8 More than Attendant Less than Attendant Less than More than Attendant 25,000 to Attendant Less than More than More than 58 Formatting Data Values You can enhance reports by using SAS formats to format data values. Formatting Data Values To apply a format to a specific SAS variable, use the FORMAT statement. General form of the FORMAT statement: FORMAT variable(s) format; FORMAT variable(s) format; SAS Data Set Format Report Example: proc print data=st.empdata; format Salary dollar11.2; run; 59 60 Values in the SAS data set are not changed. 10 What Is a SAS Format? A format is an instruction that SAS uses to write data values. SAS formats have the following form: <$>format<w>.<d> Indicates a character format Format name Total width (including decimal places and special characters) 61 Selected SAS formats: SAS Formats 12234.21 KATHY Number of decimal places Required delimiter w.d 8.2 $w. $5. COMMAw.d COMMA9.2 DOLLARw.d DOLLAR10. standard numeric format Width=8, 2 decimal places: standard character format Width=5: commas in a number Width=9, 2 decimal places: 12,234.21 dollar signs and commas in a number Width=10, 2 decimal places: $12,234.21 62 SAS Formats If you do not specify a format width large enough to accommodate a numeric value, the displayed value is automatically adjusted to fit into the width. Stored Value 27134.2864 27134.2864 27134.2864 27134.2864 27134.2864 27134.2864 27134.2864 Format COMMA12.2 12.2 DOLLAR12.2 DOLLAR9.2 DOLLAR8.2 DOLLAR5.2 DOLLAR4.2 Displayed Value 27,134.29 27134.29 $27,134.29 $27134.29 27134.29 27134 27E3 63 Formatting Data Values EmpID 0031 0040 0071 LastName WILLIAMS FirstName JobCode PILOT ARLENE M. FLTAT Salary 50221.62 23666.12 GOLDENBERG DESIREE st.empdata PERRY ROBERT A. FLTAT 21957.71 PROC Step proc print data=st.empdata split=' '; label LastName='Last Name' FirstName='First Name' Salary='Annual Salary'; format Salary dollar11.2; title1 'Salary Report'; run; Salary Report Emp ID 0031 0040 0071 Last Name GOLDENBERG WILLIAMS PERRY First Name DESIREE ARLENE M. ROBERT A. Job Code PILOT FLTAT FLTAT Annual Salary $50,221.62 $23,666.12 $21,957.71 Obs 1 2 3 64 SAS Formats Recall that a SAS date is stored as the number of days between 01JAN1960 and the specified date. SAS date formats display SAS date values in standard date forms. Examples: Stored Value 0 0 1 -1 365 366 SAS Formats Format Displayed Value 01/01/60 01/01/1960 02JAN1960 December 31, 1959 31/12/1960 Sunday, January 1, 1961 MMDDYY8. MMDDYY10. DATE9. WORDDATE. DDMMYY10. WEEKDATE. Selected SAS date formats: MMDDYYw. Displayed Format Value MMDDYY6. 101601 MMDDYY8. 10/16/01 MMDDYY10. 10/16/2001 DATEw. Displayed Format Value DATE7. 16OCT01 DATE9. 16OCT2001 65 66 11 Lab Exercises 5 Producing List Reports 67 12 ...
View Full Document

This note was uploaded on 10/31/2011 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