Beaumont sally t london 1132 e00525 pilot1 72000 1151

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: RT 1163 • E00802 PILOT2 81000 12MAY1985 BERGAMASCO CHRISTOPHER CARY 04AUG1988 BETHEA Distribution of proc freq data=crew; run; Distribution of HireDate Salary Distribution of Distribution of LastName JobCode Distribution of FirstName Distribution of Distribution of Distribution of Location Phone •Use the TABLES statement to limit the variables included in the frequency counts. These are typically variables that have a limited number of distinct values. •General form of a PROC FREQ step with a TABLES statement: PROC FREQ DATA=SAS-data-set; TABLES SAS-variables < / options >; RUN; EmpID 13 Creating a Frequency Report proc freq data=crew; tables JobCode; title 'Distribution of Job Code Values'; run; Distribution of Job Code Values The FREQ Procedure 14 Displaying the Number of Levels Use the NLEVELS option in the PROC FREQ statement to display the number of levels for the variables included in the frequency counts. proc freq data=crew nlevels; tables Location; title 'Distribution of Location Values'; run; Job Cumulative Cumulative Code Frequency Percent Frequency Percent ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ FLTAT1 14 20.29 14 20.29 FLTAT2 18 26.09 32 46.38 FLTAT3 12 17.39 44 63.77 PILOT1 8 11.59 52 75.36 PILOT2 9 13.04 61 88.41 PILOT3 8 11.59 69 100.00 15 16 4 Creating a Frequency Report Analyzing Categories of Values Distribution of Location Values International Airlines wants to use formats to categorize the flight crew by job code. The FREQ Procedure Number of Variable Levels Stored values Variable Levels ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ Location 3 Formatted values PILOT1 PILOT2 PILOT3 FLTAT1 FLTAT2 FLTAT3 Cumulative Cumulative Location Frequency Percent Frequency Percent ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ CARY 27 39.13 27 39.13 FRANKFURT 19 27.54 46 66.67 LONDON 23 33.33 69 100.00 Pilot Flight Attendant 17 Analyzing Categories of Values proc format; value $codefmt 'FLTAT1'-'FLTAT3'='Flight Attendant' 'PILOT1'-'PILOT3'='Pilot'; run; proc freq data = crew; format JobCode $codefmt.; tables JobCode; run; 19 18 Analyzing Categories of Values • Distribution of Job Code Values The FREQ Procedure Cumulative Cumulative Percent JobCode Frequency Percent Frequency ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ 63.77 Flight Attendant 44 63.77 44 Pilot 25 36.23 69 100.00 20 5 Crosstabular Frequency Reports Crosstabular Frequency Reports •A two-way, or crosstabular, frequency report analyzes all possible combinations of the distinct values of two variables. •The asterisk (*) operator in the TABLES statement is used to cross variables. •General form of the FREQ procedure to create a crosstabular report: proc format; value $codefmt 'FLTAT1'-'FLTAT3'='Flight Attendant' 'PILOT1'-'PILOT3'='Pilot';...
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