readme.awi Data Group Name: awi (1951-2002) Description: Social Security Average Wage Index Data Source(s): Social Security Administration, "Automatic Increases for the Social Security and Supplemental Security Income Programs" webpage http://www.ssa.gov/OACT/COLA/AWI.html Comments: Average Wage Index: The average amount of total wages for each year after 1950, including wages in noncovered employment and wages in covered employment in excess of the OASDI contribution and benefit base. These amounts are used to index the earnings of most workers first becoming eligible for benefits in 1979 or later, and are automatic adjustments in the contribution and benefit base, bend points, earnings test exempt amounts, and other wage-indexed amounts. Usage: To look up values of these data for a set of key variable values (in SAS): a) In your SAS program, before your data step add: %include 'awi.fmt'; b) set SUPERKEY to the combination of key variable values you want to look up. See "SUPERKEY=" under key variable description below. c) use a formatted put function of SUPERKEY with the data series format (See examples under "Usage" in detailed description of each data series). Key vars: Varname Typ Description YEAR Num Year Min=1951 Max=2002 SUPERKEY =YEAR; Data series [summary]: Varname Fmtname Typ Description ------- ------- --- ----------- AVGWAGEI AVGWAGEI. Num Social Security Average Wage Index ---------------------------- Data series AVGWAGEI---------------------------- Varname Fmtname Typ Description AVGWAGEI AVGWAGEI. Num Social Security Average Wage Index Units= Min=2799.16 Max=33252.09 Mean=12987.9008 N=52 N_Missing=0 How missings handled: There were no missing values Comments: Usage: myvar=put(superkey,AVGWAGEI.); ---------------------------------------------------------------------------- The CONTENTS Procedure Data Set Name: SCRLIB.AWI04 Observations: 52 Member Type: DATA Variables: 2 Engine: V8 Indexes: 0 Created: 14:37 Thursday, May 20, 2004 Observation Length: 16 Last Modified: 14:37 Thursday, May 20, 2004 Deleted Observations: 0 Protection: Compressed: NO Data Set Type: Sorted: NO Label: -----Alphabetic List of Variables and Attributes----- # Variable Type Len Pos Label ------------------------------------------------------------------------- 2 AVGWAGEI Num 8 8 Social Security Average Wage Index 1 YEAR Num 8 0 Year