*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