*Northeast_mann whitney U_test_01.10.12.sas

Author: Abt Associates, Inc. Created: 1/10/12 Purpose: SAS code to run Mann-Whitney U tests for statistical differences between mail survey respondents and nonrespondents that participated in the

nonresponse follow-up survey.

*variables tested are (1) gender, (2) educational attainment, (3) employment, (4) importance of aquatic ecosystems, (5) hispanic/latino origin, (6) race, (7) race (minority/non-white), and (8) household income.

*need to manually import the main survey and non-reponse data files separately from excel; *labeled here as main_survey_data and NR_data respectively.;

*keep only the variables that are needed from each data set before merging; Data main_survey_data_2; set main_survey_data;

sample="main"; race=max(q22_1,Q22_2,Q22_3,Q22_4,Q22_5); if race~=5 then race_minor=1; if race=5 then race_minor=2; aquatic=Q2; gender=Q13; education=Q14; employ=Q19; income=Q23; hisp=Q21; drop region version batch Q10_1 Q10_2 Q10_3 Q10_4 Q10_5 Q10_6 Q24 Q240 Q241 Q242 Q243 Q22_1 Q22_2 Q22_3 Q22_4 Q22_5 Q11_1 Q11_2 Q12 Q15 Q16 Q17 Q18_1 Q18_2 Q20 Q2 Q13 Q14 Q19 Q23 Q21;

RUN; Data NR_data_2; set NR_data;

sample="nr"; drop Q_1 mode mail; gender=Q_2; drop Q_2; education=Q_3; drop Q_3; drop Q_4 Q_5 Q_6 Q_7; employ=Q_8; drop Q_8 Q_9; aquatic=Q_10; drop Q_10 Q_11 Q12_1 Q12_2 Q12_3 Q12_4 Q12_5 Q12_6; hisp=Q_15; drop q13 q_14 q_15; race=max(Q_16_1,Q_16_2,Q_16_3,Q_16_4,Q_16_5,Q_16_6); drop Q_16_1 Q_16_2 Q_16_3 Q_16_4 Q_16_5 Q_16_6;

if race~=5 then race_minor=1; if race=5 then race_minor=2; drop q_17_1 q_17_2; income=Q_18; drop q_18; IDx=1*ID; drop ID; rename IDx=ID;

RUN; ***merge together the two data sets; Data NE_combined; set NR_data_2 Main_survey_data_2;

RUN;

************************** RUN mann-whitney U test for gender **************************; PROC NPAR1WAY data=NE_combined wilcoxon; Class sample; Var gender; *Exact; *OPTIONAL;
Run;

****************************** RUN mann-whitney U test for employment Page 1******************************;

PROC NPAR1WAY data=NE_combined wilcoxon; Class sample; Var employ; *Exact; *OPTIONAL;
Run;

********************************************* RUN mann-whitney U test for hispanic or latino origin *********************************************; PROC NPAR1WAY data=NE_combined wilcoxon; Class sample; Var hisp; *Exact; *OPTIONAL;
Run;

********************************************* RUN mann-whitney U test for race(minority/non-white) *********************************************; PROC NPAR1WAY data=NE_combined wilcoxon; Class sample; Var race_minor; *Exact; *OPTIONAL;
Run;

********************************************** RUN mann-whitney U test for educational attainment **********************************************; PROC NPAR1WAY data=NE_combined wilcoxon; Class sample; Var education; *Exact; *OPTIONAL;
Run;

**************************************************** RUN mann-whitney U test for importance of aquatic ecosystems ****************************************************; PROC NPAR1WAY data=NE_combined wilcoxon; Class sample; Var aquatic; *Exact; *OPTIONAL;
Run;

***************************************************** RUN mann-whitney U test for race with all categories included *****************************************************; PROC NPAR1WAY data=NE_combined wilcoxon; Class sample;

Var race; *Exact; *OPTIONAL;
Run;

***************************************************** RUN mann-whitney U test for household income *****************************************************; PROC NPAR1WAY data=NE_combined wilcoxon; Class sample; Var income; *Exact; *OPTIONAL;
Run;

Page 2