| The STANDARD Procedure |
| What Does the STANDARD Procedure Do? |
The STANDARD procedure standardizes variables in a SAS data set to a given mean and standard deviation, and it creates a new SAS data set containing the standardized values.
| Standardizing Data |
The following output shows a simple standardization where the output data set contains standardized student exam scores. The statements that produce the output follow:
proc standard data=score mean=75 std=5 out=stndtest; run; proc print data=stndtest; run;
Standardized Test Scores Using PROC STANDARD
The SAS System 1
Obs Student Test1
1 Capalleti 80.5388
2 Dubose 64.3918
3 Engles 80.9143
4 Grant 68.8980
5 Krupski 75.2816
6 Lundsford 79.7877
7 McBane 73.4041
8 Mullen 78.6612
9 Nguyen 74.9061
10 Patel 71.9020
11 Si 73.4041
12 Tanaka 77.9102
The following output shows a more complex example that uses BY-group processing. PROC STANDARD computes Z scores separately for two BY groups by standardizing life-expectancy data to a mean of 0 and a standard deviation of 1. The data are 1950 and 1993 life expectancies at birth for 16 countries. The birth rates for each country, classified as stable or rapid, form the two BY groups. The statements that produce the analysis also
print statistics for each variable to standardize
replace missing values with the given mean
calculate standardized values using a given mean and standard deviation
print the data set with the standardized values.
For an explanation of the program that produces this output, see Standardizing BY Groups and Replacing Missing Values.
Z Scores for Each BY Group Using PROC STANDARD
Life Expectancies by Birth Rate 2
-------------------- PopulationRate=Stable ---------------------
The STANDARD Procedure
Standard
Name Mean Deviation N
Label
Life50 67.400000 1.854724 5
1950 life expectancy
Life93 74.500000 4.888763 6
1993 life expectancy
--------------------- PopulationRate=Rapid ---------------------
Standard
Name Mean Deviation N
Label
Life50 42.000000 5.033223 8
1950 life expectancy
Life93 59.100000 8.225300 10
1993 life expectancy Standardized Life Expectancies at Birth 3
by a Country's Birth Rate
Population
Rate Country Life50 Life93
Stable France -0.21567 0.51138
Stable Germany 0.32350 0.10228
Stable Japan -1.83316 0.92048
Stable Russia 0.00000 -1.94323
Stable United Kingdom 0.86266 0.30683
Stable United States 0.86266 0.10228
Rapid Bangladesh 0.00000 -0.74161
Rapid Brazil 1.78812 0.96045
Rapid China -0.19868 1.32518
Rapid Egypt 0.00000 0.10942
Rapid Ethiopia -1.78812 -1.59265
Rapid India -0.59604 -0.01216
Rapid Indonesia -0.79472 -0.01216
Rapid Mozambique 0.00000 -1.47107
Rapid Philippines 1.19208 0.59572
Rapid Turkey 0.39736 0.83888
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.