Original Program from program editor.
***************************************;
*** Data from Freund & Wilson, 1997 ***;
*** TABLE 1.2 - HOUSES DATA ***;
***************************************;
OPTIONS NOCENTER NODATE NONUMBER LS=99 PS=256;
DATA ONE; INFILE CARDS MISSOVER;
TITLE1 'Analysis of house sale price data';
TITLE2 'Table 1.1 from Freund & Wilson, 1997';
INPUT OBS QUALITY $ EXTERIOR $ DSQF SP;
CARDS; RUN;
1 POOR FRAME 0.816 19.000
2 POOR FRAME 0.907 19.800
3 POOR FRAME 0.938 15.000
4 POOR FRAME 1.032 18.900
5 POOR FRAME 1.100 25.500
6 POOR FRAME 1.180 25.900
7 MEDIUM BRICK 1.278 33.500
8 MEDIUM BRICK 1.289 36.500
9 MEDIUM BRICK 1.320 38.500
10 MEDIUM BRICK 1.328 37.000
11 GOOD BRICK 1.337 34.555
12 MEDIUM BRICK 1.366 35.500
13 POOR FRAME 1.382 22.000
14 MEDIUM BRICK 1.387 39.500
15 MEDIUM BRICK 1.426 43.600
16 MEDIUM BRICK 1.436 39.100
17 MEDIUM BRICK 1.440 37.000
18 GOOD BRICK 1.447 39.000
19 MEDIUM BRICK 1.450 36.800
20 GOOD BRICK 1.498 42.800
21 GOOD BRICK 1.530 46.600
22 GOOD BRICK 1.612 43.750
23 GOOD BRICK 1.616 49.900
24 GOOD BRICK 1.675 35.000
25 MEDIUM BRICK 1.694 44.500
26 MEDIUM BRICK 1.704 48.300
27 MEDIUM BRICK 1.708 42.900
28 MEDIUM BRICK 1.711 43.500
29 MEDIUM BRICK 1.716 49.600
30 MEDIUM BRICK 1.731 54.000
31 MEDIUM BRICK 1.740 48.500
32 MEDIUM BRICK 1.741 49.900
33 MEDIUM BRICK 1.741 48.900
34 MEDIUM BRICK 1.764 39.500
35 GOOD BRICK 1.833 55.500
36 MEDIUM BRICK 1.934 46.000
37 MEDIUM BRICK 1.977 47.900
38 GOOD BRICK 2.012 52.800
39 GOOD BRICK 2.049 56.350
40 GOOD BRICK 2.054 58.500
41 GOOD BRICK 2.207 61.350
42 GOOD FRAME 2.233 75.000
;
PROC PRINT DATA=ONE; RUN;
PROC UNIVARIATE DATA=ONE PLOT; VAR SP;
TITLE3 'Proc Univariate of house sales price'; RUN;
PROC MEANS DATA=ONE N Mean Var StdDev Min Max; VAR SP;
TITLE3 'Proc Univariate of house sales price'; RUN;
PROC SORT DATA=ONE; BY QUALITY; RUN;
PROC MEANS DATA=ONE N Mean Var StdDev Min Max; BY QUALITY; VAR SP;
TITLE3 'Proc Univariate of house sales price'; RUN;
PROC FREQ DATA=ONE; TABLE EXTERIOR;
TITLE3 'Frequency table of house Exterior (F&W Table 1.3)'; RUN;
PROC FREQ DATA=ONE; TABLE QUALITY;
TITLE3 'Frequency table of house Quality (F&W Table 1.4)'; RUN;
OPTIONS PS=40;
PROC CHART DATA=ONE; VBAR QUALITY;
TITLE3 'Frequency table of house Quality (F&W Fig 1.3)'; RUN;
PROC CHART DATA=ONE; VBAR EXTERIOR;
TITLE3 'Bar chart of house Exterior (F&W Fig 1.1)'; RUN;
PROC CHART DATA=ONE; VBAR SP;
TITLE3 'Bar chart of house Sale Price (F&W Fig 1.2)'; RUN;
PROC CHART DATA=ONE; HBAR QUALITY;
TITLE3 'Bar chart of house Quality (F&W Fig 1.3)'; RUN;
OPTIONS PS=99;
Below is output from the SAS log (bold) and output from the SAS Output window.
1 ***************************************;
2 *** Data from Freund & Wilson, 1997 ***;
3 *** TABLE 1.2 - HOUSES DATA ***;
4 ***************************************;
5 OPTIONS NOCENTER NODATE NONUMBER LS=99 PS=256;
6 TITLE1 'Introductory SAS example';
7
8
9 DATA ONE; INFILE CARDS MISSOVER;
10 TITLE2 'Analysis of house sale price data';
11 TITLE3 'Table 1.1 from Freund & Wilson, 1997';
12 INPUT OBS QUALITY $ EXTERIOR $ DSQF SP;
13 CARDS;
NOTE: The data set WORK.ONE has 42 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds
13 ! RUN;
56 ;
57 PROC PRINT DATA=ONE; RUN;
NOTE: There were 42 observations read from the data set WORK.ONE.
NOTE: The PROCEDURE PRINT printed page 1.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.10 seconds
cpu time 0.04 seconds
Introductory SAS example
Analysis of house sale price data
Table 1.1 from Freund & Wilson, 1997
Obs OBS QUALITY EXTERIOR DSQF SP
1 1 POOR FRAME 0.816 19.000
2 2 POOR FRAME 0.907 19.800
3 3 POOR FRAME 0.938 15.000
4 4 POOR FRAME 1.032 18.900
5 5 POOR FRAME 1.100 25.500
6 6 POOR FRAME 1.180 25.900
7 7 MEDIUM BRICK 1.278 33.500
8 8 MEDIUM BRICK 1.289 36.500
9 9 MEDIUM BRICK 1.320 38.500
10 10 MEDIUM BRICK 1.328 37.000
11 11 GOOD BRICK 1.337 34.555
12 12 MEDIUM BRICK 1.366 35.500
13 13 POOR FRAME 1.382 22.000
14 14 MEDIUM BRICK 1.387 39.500
15 15 MEDIUM BRICK 1.426 43.600
16 16 MEDIUM BRICK 1.436 39.100
17 17 MEDIUM BRICK 1.440 37.000
18 18 GOOD BRICK 1.447 39.000
19 19 MEDIUM BRICK 1.450 36.800
20 20 GOOD BRICK 1.498 42.800
21 21 GOOD BRICK 1.530 46.600
22 22 GOOD BRICK 1.612 43.750
23 23 GOOD BRICK 1.616 49.900
24 24 GOOD BRICK 1.675 35.000
25 25 MEDIUM BRICK 1.694 44.500
26 26 MEDIUM BRICK 1.704 48.300
27 27 MEDIUM BRICK 1.708 42.900
28 28 MEDIUM BRICK 1.711 43.500
29 29 MEDIUM BRICK 1.716 49.600
30 30 MEDIUM BRICK 1.731 54.000
31 31 MEDIUM BRICK 1.740 48.500
32 32 MEDIUM BRICK 1.741 49.900
33 33 MEDIUM BRICK 1.741 48.900
34 34 MEDIUM BRICK 1.764 39.500
35 35 GOOD BRICK 1.833 55.500
36 36 MEDIUM BRICK 1.934 46.000
37 37 MEDIUM BRICK 1.977 47.900
38 38 GOOD BRICK 2.012 52.800
39 39 GOOD BRICK 2.049 56.350
40 40 GOOD BRICK 2.054 58.500
41 41 GOOD BRICK 2.207 61.350
42 42 GOOD FRAME 2.233 75.000
58
59 PROC UNIVARIATE DATA=ONE PLOT; VAR SP;
60 TITLE4 'Proc Univariate of house sales price'; RUN;
NOTE: The PROCEDURE UNIVARIATE printed page 2.
NOTE: PROCEDURE UNIVARIATE used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
Introductory SAS example
Analysis of house sale price data
Table 1.1 from Freund & Wilson, 1997
Proc Univariate of house sales price
The UNIVARIATE Procedure
Variable: SP
Moments
N 42 Sum Weights 42
Mean 41.3739286 Sum Observations 1737.705
Std Deviation 12.446944 Variance 154.926414
Skewness -0.0453816 Kurtosis 0.48640491
Uncorrected SS 78247.6655 Corrected SS 6351.98298
Coeff Variation 30.0840273 Std Error Mean 1.92060515
Basic Statistical Measures
Location Variability
Mean 41.37393 Std Deviation 12.44694
Median 42.85000 Variance 154.92641
Mode 37.00000 Range 60.00000
Interquartile Range 13.40000
NOTE: The mode displayed is the smallest of 3 modes with a count of 2.
Tests for Location: Mu0=0n
Test -Statistic- -----p Value------
Student's t t 21.54213 Pr > |t| <.0001
Sign M 21 Pr >= |M| <.0001
Signed Rank S 451.5 Pr >= |S| <.0001
Quantiles (Definition 5)
Quantile Estimate
100% Max 75.00
99% 75.00
95% 58.50
90% 55.50
75% Q3 48.90
50% Median 42.85
25% Q1 35.50
10% 22.00
5% 19.00
1% 15.00
0% Min 15.00
Extreme Observations
----Lowest---- ----Highest----
Value Obs Value Obs
15.0 3 55.50 35
18.9 4 56.35 39
19.0 1 58.50 40
19.8 2 61.35 41
22.0 13 75.00 42
Stem Leaf Boxplot
7 5 1 0
7
6
6 1 1 |
5 668 3 |
5 00034 5 |
4 678889 6 +-----+
4 00334444 8 *--+--*
3 5566777899 10 +-----+
3 4 1 |
2 66 2 |
2 02 2 |
1 599 3 0
----+----+----+----+
Multiply Stem.Leaf by 10**+1
Normal Probability Plot
77.5+ *
| +++
| ++++
| +++*
| +*+**
| +++**
47.5+ ******
| +****
| ***+***
| **++
| ++**
| ++++ *
17.5+ *+++* **
+----+----+----+----+----+----+----+----+----+----+
-2 -1 0 +1 +2
61
62 PROC MEANS DATA=ONE N Mean Var StdDev Min Max; VAR SP;
63 TITLE4 'Mean of house sales price'; RUN;
NOTE: There were 42 observations read from the data set WORK.ONE.
NOTE: The PROCEDURE MEANS printed page 3.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.07 seconds
cpu time 0.00 seconds
Introductory SAS example
Analysis of house sale price data
Table 1.1 from Freund & Wilson, 1997
Mean of house sales price
The MEANS Procedure
Analysis Variable : SP
N Mean Variance Std Dev Minimum Maximum
----------------------------------------------------------------------------------
42 41.3739286 154.9264141 12.4469440 15.0000000 75.0000000
----------------------------------------------------------------------------------
64
65 PROC SORT DATA=ONE; BY QUALITY; RUN;
NOTE: There were 42 observations read from the data set WORK.ONE.
NOTE: The data set WORK.ONE has 42 observations and 5 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.07 seconds
cpu time 0.03 seconds
66 PROC MEANS DATA=ONE N Mean Var StdDev Min Max; BY QUALITY; VAR SP;
67 TITLE4 'Mean of house sales price by house quality'; RUN;
NOTE: There were 42 observations read from the data set WORK.ONE.
NOTE: The PROCEDURE MEANS printed page 4.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
Introductory SAS example
Analysis of house sale price data
Table 1.1 from Freund & Wilson, 1997
Mean of house sales price by house quality
QUALITY=GOOD
The MEANS Procedure
Analysis Variable : SP
N Mean Variance Std Dev Minimum Maximum
----------------------------------------------------------------------------------
13 50.0850000 132.6176333 11.5159730 34.5550000 75.0000000
----------------------------------------------------------------------------------
QUALITY=MEDIUM
Analysis Variable : SP
N Mean Variance Std Dev Minimum Maximum
----------------------------------------------------------------------------------
22 42.7500000 33.2845238 5.7692741 33.5000000 54.0000000
----------------------------------------------------------------------------------
QUALITY=POOR
Analysis Variable : SP
N Mean Variance Std Dev Minimum Maximum
----------------------------------------------------------------------------------
7 20.8714286 15.1657143 3.8943182 15.0000000 25.9000000
----------------------------------------------------------------------------------
68
69 PROC FREQ DATA=ONE; TABLE EXTERIOR;
70 TITLE4 'Frequency table of house Exterior'; RUN;
NOTE: There were 42 observations read from the data set WORK.ONE.
NOTE: The PROCEDURE FREQ printed page 5.
NOTE: PROCEDURE FREQ used (Total process time):
real time 0.04 seconds
cpu time 0.01 seconds
Introductory SAS example
Analysis of house sale price data
Table 1.1 from Freund & Wilson, 1997
Frequency table of house Exterior
The FREQ Procedure
Cumulative Cumulative
EXTERIOR Frequency Percent Frequency Percent
-------------------------------------------------------------
BRICK 34 80.95 34 80.95
FRAME 8 19.05 42 100.00
72 PROC FREQ DATA=ONE; TABLE QUALITY;
73 TITLE4 'Frequency table of house Quality'; RUN;
NOTE: There were 42 observations read from the data set WORK.ONE.
NOTE: The PROCEDURE FREQ printed page 6.
NOTE: PROCEDURE FREQ used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
Introductory SAS example
Analysis of house sale price data
Table 1.1 from Freund & Wilson, 1997
Frequency table of house Quality
The FREQ Procedure
Cumulative Cumulative
QUALITY Frequency Percent Frequency Percent
------------------------------------------------------------
GOOD 13 30.95 13 30.95
MEDIUM 22 52.38 35 83.33
POOR 7 16.67 42 100.00
74
75 OPTIONS PS=40;
76 PROC CHART DATA=ONE; VBAR QUALITY;
77 TITLE4 'Frequency table of house Quality'; RUN;
NOTE: The PROCEDURE CHART printed page 7.
NOTE: PROCEDURE CHART used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
Introductory SAS example
Analysis of house sale price data
Table 1.1 from Freund & Wilson, 1997
Frequency table of house Quality
Frequency
| *****
| *****
20 + *****
| *****
| *****
| *****
| *****
15 + *****
| *****
| ***** *****
| ***** *****
| ***** *****
10 + ***** *****
| ***** *****
| ***** *****
| ***** ***** *****
| ***** ***** *****
5 + ***** ***** *****
| ***** ***** *****
| ***** ***** *****
| ***** ***** *****
| ***** ***** *****
--------------------------------------------
GOOD MEDIUM POOR
QUALITY
78
79 PROC CHART DATA=ONE; VBAR EXTERIOR;
80 TITLE4 'Bar chart of house Exterior'; RUN;
NOTE: The PROCEDURE CHART printed page 8.
NOTE: PROCEDURE CHART used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
Introductory SAS example
Analysis of house sale price data
Table 1.1 from Freund & Wilson, 1997
Bar chart of house Exterior
Frequency
| *****
| *****
30 + *****
| *****
| *****
| *****
| *****
20 + *****
| *****
| *****
| *****
| *****
10 + *****
| ***** *****
| ***** *****
| ***** *****
| ***** *****
--------------------------------
BRICK FRAME
EXTERIOR
81
82 PROC CHART DATA=ONE; VBAR SP;
83 TITLE4 'Bar chart of house Sale Price'; RUN;
NOTE: The PROCEDURE CHART printed page 9.
NOTE: PROCEDURE CHART used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
Introductory SAS example
Analysis of house sale price data
Table 1.1 from Freund & Wilson, 1997
Bar chart of house Sale Price
Frequency
| *****
| *****
| *****
15 + *****
| *****
| *****
| *****
| ***** *****
10 + ***** *****
| ***** *****
| ***** *****
| ***** *****
| ***** ***** *****
5 + ***** ***** ***** *****
| ***** ***** ***** *****
| ***** ***** ***** *****
| ***** ***** ***** *****
| ***** ***** ***** ***** ***** *****
--------------------------------------------------------------------------------
18 30 42 54 66 78
SP Midpoint
84
85 PROC CHART DATA=ONE; HBAR QUALITY;
86 TITLE4 'Bar chart of house Quality'; RUN;
NOTE: The PROCEDURE CHART printed page 10.
NOTE: PROCEDURE CHART used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
87 OPTIONS PS=99;
Introductory SAS example
Analysis of house sale price data
Table 1.1 from Freund & Wilson, 1997
Bar chart of house Quality
QUALITY Cum. Cum.
Freq Freq Percent Percent
|
GOOD |************************** 13 13 30.95 30.95
|
MEDIUM |******************************************** 22 35 52.38 83.33
|
POOR |************** 7 42 16.67 100.00
|
----+---+---+---+---+---+---+---+---+---+---+
2 4 6 8 10 12 14 16 18 20 22
Frequency
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 6.29 seconds
cpu time 0.45 seconds