BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
joebacon
Pyrite | Level 9

Hi all,

 

It's been a while and I missed you guys!

 

I have survey data and was wondering if it is possible to call upon data values using their format?

 

I am attempting to code all missing values appropriately. As such, I want to change all the "I choose not to answer" to .P and all the "Don't know." to .D.

 

I know that to do this I would use an array like the following:

 

 

data rds.redcap_character_clean;
set rds.redcap_character_clean;
array Nums[*] _numeric_ ;
do i=1 to dim(Nums);
if Nums(i) = 888 then q(i) = .P;
end;
run;

However, I have formatted the values to show "I choose not the answer" as each variable has a different value for the "I choose not to answer". I was wondering if I could call upon the formatted text (if it is the same) to change those responses to missing?

 

My data looks like the following:

 

DATA2DATASTEP DSN CLEAN_DUMMY
DATA2DATASTEP FILE create_WORK_CLEAN_DUMMY_data.sas
DATA2DATASTEP FMT YES
DATA2DATASTEP FMTLIST record_id BEST32. icf ICF_. dob YYMMDD10. gender GENDER_. race RACE_. hispanic_latino HISPANIC_LATINO_. marital_status MARITAL_STATUS_. number_children BEST12. level_education LEVEL_EDUCATION_. yearly_income YEARLY_INCOME_. 
household_income HOUSEHOLD_INCOME_. public_benefit_1 PUBLIC_BENEFIT_1_. public_benefit_2 PUBLIC_BENEFIT_2_. public_benefit_3 PUBLIC_BENEFIT_3_. public_benefit_4 PUBLIC_BENEFIT_4_. public_benefit_5 PUBLIC_BENEFIT_5_. young_adult_you_know BEST12. 
young_adults_live_near BEST12. young_adult_interacted BEST12. yng_adlt_interact_online BEST12. age_first_drink AGE_FIRST_DRINK_. age_first_intoxicated AGE_FIRST_INTOXICATED_. drink_days_past30 DRINK_DAYS_PAST30_. drinks_per_drink_day BEST12. 
treatment_intervention___1 TREATMENT_INTERVENTION___1_. treatment_intervention___2 TREATMENT_INTERVENTION___2_. treatment_intervention___3 TREATMENT_INTERVENTION___3_. treatment_intervention___4 TREATMENT_INTERVENTION___4_. treatment_intervention___5 
2                                                                                                                        The SAS System                                                                                           10:55 Thursday, March 21, 2019

TREATMENT_INTERVENTION___5_. treatment_intervention___6 TREATMENT_INTERVENTION___6_. current_tobacco_use CURRENT_TOBACCO_USE_. lifetime_illicit_drug LIFETIME_ILLICIT_DRUG_. lifetime_prscrptn_drugs LIFETIME_PRSCRPTN_DRUGS_. lifetime_alc_drug_mix 
LIFETIME_ALC_DRUG_MIX_. yaacqb_1 YAACQB_1_. yaacqb_2 YAACQB_2_. yaacqb_3 YAACQB_3_. yaacqb_4 YAACQB_4_. yaacqb_5 YAACQB_5_. yaacqb_6 YAACQB_6_. yaacqb_7 YAACQB_7_. yaacqb_8 YAACQB_8_. yaacqb_9 YAACQB_9_. yaacqb_10 YAACQB_10_. yaacqb_11 YAACQB_11_. 
yaacqb_12 YAACQB_12_. yaacqb_13 YAACQB_13_. yaacqb_14 YAACQB_14_. yaacqb_15 YAACQB_15_. yaacqb_16 YAACQB_16_. yaacqb_17 YAACQB_17_. yaacqb_18 YAACQB_18_. yaacqb_19 YAACQB_19_. yaacqb_20 YAACQB_20_. yaacqb_21 YAACQB_21_. yaacqb_22 YAACQB_22_. yaacqb_23 
YAACQB_23_. yaacqb_24 YAACQB_24_. dd_1 DD_1_. dd_2 DD_2_. dd_3 DD_3_. dd_4 DD_4_. dd_5 DD_5_. dd_6 DD_6_. dd_7 DD_7_. dd_8 DD_8_. dd_9 DD_9_. dd_10 DD_10_. dd_11 DD_11_. dd_12 DD_12_. dd_13 DD_13_. dd_14 DD_14_. dd_15 DD_15_. dd_16 DD_16_. dd_17 DD_17_. 
apt_1 BEST12. apt_2 BEST12. apt_3 BEST12. apt_4 BEST12. apt_5 BEST12. apt_6 BEST12. apt_7 BEST12. apt_8 BEST12. apt_9 BEST12. apt_10 BEST12. apt_11 BEST12. apt_12 BEST12. apt_13 BEST12. apt_14 BEST12. apt_15 BEST12. apt_16 BEST12. apt_17 BEST12. apt_18 
BEST12. rdea_index_1 BEST12. rdea_index_2 BEST12. past30_savings BEST12. ac_lvl_wod_freq1 AC_LVL_WOD_FREQ1_. ac_lvl_wod_freq2 AC_LVL_WOD_FREQ2_. ac_lvl_wod_freq3 AC_LVL_WOD_FREQ3_. ac_lvl_wod_freq4 AC_LVL_WOD_FREQ4_. ac_lvl_wod_freq5 AC_LVL_WOD_FREQ5_. 
ac_lvl_wod_freq6 AC_LVL_WOD_FREQ6_. ac_lvl_wod_freq7 AC_LVL_WOD_FREQ7_. ac_lvl_wod_freq8 AC_LVL_WOD_FREQ8_. ac_lvl_wod_freq9 AC_LVL_WOD_FREQ9_. ac_lvl_wod_freq10 AC_LVL_WOD_FREQ10_. ac_lvl_wod_freq11 AC_LVL_WOD_FREQ11_. ac_lvl_wod_freq12 
AC_LVL_WOD_FREQ12_. ac_lvl_wod_freq13 AC_LVL_WOD_FREQ13_. ac_lvl_wod_freq14 AC_LVL_WOD_FREQ14_. ac_lvl_wod_freq15 AC_LVL_WOD_FREQ15_. ac_lvl_wod_freq16 AC_LVL_WOD_FREQ16_. ac_lvl_wod_freq17 AC_LVL_WOD_FREQ17_. ac_lvl_wod_freq18 AC_LVL_WOD_FREQ18_. 
ac_lvl_wod_freq19 AC_LVL_WOD_FREQ19_. ac_lvl_wod_freq20 AC_LVL_WOD_FREQ20_. ac_lvl_wod_freq21 AC_LVL_WOD_FREQ21_. ac_lvl_wod_freq22 AC_LVL_WOD_FREQ22_. ac_lvl_wod_freq23 AC_LVL_WOD_FREQ23_. ac_lvl_wod_freq24 AC_LVL_WOD_FREQ24_. ac_lvl_wod_freq25 
AC_LVL_WOD_FREQ25_. ac_lvl_wod_freq26 AC_LVL_WOD_FREQ26_. ac_lvl_wod_freq27 AC_LVL_WOD_FREQ27_. ac_lvl_wod_freq28 AC_LVL_WOD_FREQ28_. ac_lvl_wod_freq29 AC_LVL_WOD_FREQ29_. ac_lvl_wod_freq30 AC_LVL_WOD_FREQ30_. ac_lvl_wod_freq31 AC_LVL_WOD_FREQ31_. 
ac_lvl_wod_freq32 AC_LVL_WOD_FREQ32_. ac_lvl_wod_freq33 AC_LVL_WOD_FREQ33_. ac_lvl_wod_freq34 AC_LVL_WOD_FREQ34_. ac_lvl_wod_freq35 AC_LVL_WOD_FREQ35_. ac_lvl_wod_freq36 AC_LVL_WOD_FREQ36_. act_lvl_wd_freq1 ACT_LVL_WD_FREQ1_. act_lvl_wd_freq2 
ACT_LVL_WD_FREQ2_. act_lvl_wd_freq3 ACT_LVL_WD_FREQ3_. act_lvl_wd_freq4 ACT_LVL_WD_FREQ4_. act_lvl_wd_freq5 ACT_LVL_WD_FREQ5_. act_lvl_wd_freq6 ACT_LVL_WD_FREQ6_. act_lvl_wd_freq7 ACT_LVL_WD_FREQ7_. act_lvl_wd_freq8 ACT_LVL_WD_FREQ8_. act_lvl_wd_freq9 
ACT_LVL_WD_FREQ9_. act_lvl_wd_freq10 ACT_LVL_WD_FREQ10_. act_lvl_wd_freq11 ACT_LVL_WD_FREQ11_. act_lvl_wd_freq12 ACT_LVL_WD_FREQ12_. act_lvl_wd_freq13 ACT_LVL_WD_FREQ13_. act_lvl_wd_freq14 ACT_LVL_WD_FREQ14_. act_lvl_wd_freq15 ACT_LVL_WD_FREQ15_. 
act_lvl_wd_freq16 ACT_LVL_WD_FREQ16_. act_lvl_wd_freq17 ACT_LVL_WD_FREQ17_. act_lvl_wd_freq18 ACT_LVL_WD_FREQ18_. act_lvl_wd_freq19 ACT_LVL_WD_FREQ19_. act_lvl_wd_freq20 ACT_LVL_WD_FREQ20_. act_lvl_wd_freq21 ACT_LVL_WD_FREQ21_. act_lvl_wd_freq22 
ACT_LVL_WD_FREQ22_. act_lvl_wd_freq23 ACT_LVL_WD_FREQ23_. act_lvl_wd_freq24 ACT_LVL_WD_FREQ24_. act_lvl_wd_freq25 ACT_LVL_WD_FREQ25_. act_lvl_wd_freq26 ACT_LVL_WD_FREQ26_. act_lvl_wd_freq27 ACT_LVL_WD_FREQ27_. act_lvl_wd_freq28 ACT_LVL_WD_FREQ28_. 
act_lvl_wd_freq29 ACT_LVL_WD_FREQ29_. act_lvl_wd_freq30 ACT_LVL_WD_FREQ30_. act_lvl_wd_freq31 ACT_LVL_WD_FREQ31_. act_lvl_wd_freq32 ACT_LVL_WD_FREQ32_. act_lvl_wd_freq33 ACT_LVL_WD_FREQ33_. act_lvl_wd_freq34 ACT_LVL_WD_FREQ34_. act_lvl_wd_freq35 
ACT_LVL_WD_FREQ35_. act_lvl_wd_freq36 ACT_LVL_WD_FREQ36_. pbss20_1 PBSS20_1_. pbss20_2 PBSS20_2_. pbss20_3 PBSS20_3_. pbss20_4 PBSS20_4_. pbss20_5 PBSS20_5_. pbss20_6 PBSS20_6_. pbss20_7 PBSS20_7_. pbss20_8 PBSS20_8_. pbss20_9 PBSS20_9_. pbss20_10 
PBSS20_10_. pbss20_11 PBSS20_11_. pbss20_12 PBSS20_12_. pbss20_13 PBSS20_13_. pbss20_14 PBSS20_14_. pbss20_15 PBSS20_15_. pbss20_16 PBSS20_16_. pbss20_17 PBSS20_17_. pbss20_18 PBSS20_18_. pbss20_19 PBSS20_19_. pbss20_20 PBSS20_20_. bscq_1 BEST12. bscq_2 
BEST12. bscq_3 BEST12. bscq_4 BEST12. bscq_5 BEST12. bscq_6 BEST12. bscq_7 BEST12. bscq_8 BEST12. behavior_change_ladder_2 BEHAVIOR_CHANGE_LADDER_2_. snq_1_age BEST12. snq_1_relation SNQ_1_RELATION_. snq_person1_q1 SNQ_PERSON1_Q1_. snq_person1_q2 
SNQ_PERSON1_Q2_. snq_person1_q3 SNQ_PERSON1_Q3_. snq_person1_q4 SNQ_PERSON1_Q4_. snq_person1_q5 SNQ_PERSON1_Q5_. snq_person1_q6 SNQ_PERSON1_Q6_. snq_person1_q7 SNQ_PERSON1_Q7_. snq_person1_q8 SNQ_PERSON1_Q8_. snq_person1_q9 SNQ_PERSON1_Q9_. 
snq_person1_q10 SNQ_PERSON1_Q10_. snq_2_age BEST12. snq_person2_relationship SNQ_PERSON2_RELATIONSHIP_. snq_person2_q1 SNQ_PERSON2_Q1_. snq_person2_q2 SNQ_PERSON2_Q2_. snq_person2_q3 SNQ_PERSON2_Q3_. snq_person2_q4 SNQ_PERSON2_Q4_. snq_person2_q5 
SNQ_PERSON2_Q5_. snq_person2_q6 SNQ_PERSON2_Q6_. snq_person2_q7 SNQ_PERSON2_Q7_. snq_person2_q8 SNQ_PERSON2_Q8_. snq_person2_q9 SNQ_PERSON2_Q9_. snq_person2_q10 SNQ_PERSON2_Q10_. snq_3_age BEST12. snq_person3_relationship SNQ_PERSON3_RELATIONSHIP_. 
snq_person3_q1 SNQ_PERSON3_Q1_. snq_person3_q2 SNQ_PERSON3_Q2_. snq_person3_q3 SNQ_PERSON3_Q3_. snq_person3_q4 SNQ_PERSON3_Q4_. snq_person3_q5 SNQ_PERSON3_Q5_. snq_person3_q6 SNQ_PERSON3_Q6_. snq_person3_q7 SNQ_PERSON3_Q7_. snq_person3_q8 SNQ_PERSON3_Q8_. 
snq_person3_q9 SNQ_PERSON3_Q9_. snq_person3_q10 SNQ_PERSON3_Q10_. snq_4_age BEST12. snq_person4_relationship SNQ_PERSON4_RELATIONSHIP_. snq_person4_q1 SNQ_PERSON4_Q1_. snq_person4_q2 SNQ_PERSON4_Q2_. snq_person4_q3 SNQ_PERSON4_Q3_. snq_person4_q4 
SNQ_PERSON4_Q4_. snq_person4_q5 SNQ_PERSON4_Q5_. snq_person4_q6 SNQ_PERSON4_Q6_. snq_person4_q7 SNQ_PERSON4_Q7_. snq_person4_q8 SNQ_PERSON4_Q8_. snq_person4_q9 SNQ_PERSON4_Q9_. snq_person4_q10 SNQ_PERSON4_Q10_. add_nw_member5 ADD_NW_MEMBER5_. snq_5_age 
BEST12. snq_person5_relationship SNQ_PERSON5_RELATIONSHIP_. snq_person5_q1 SNQ_PERSON5_Q1_. snq_person5_q2 SNQ_PERSON5_Q2_. snq_person5_q3 SNQ_PERSON5_Q3_. snq_person5_q4 SNQ_PERSON5_Q4_. snq_person5_q5 SNQ_PERSON5_Q5_. snq_person5_q6 SNQ_PERSON5_Q6_. 
snq_person5_q7 SNQ_PERSON5_Q7_. snq_person5_q8 SNQ_PERSON5_Q8_. snq_person5_q9 SNQ_PERSON5_Q9_. snq_person5_q10 SNQ_PERSON5_Q10_. add_nw_member6 ADD_NW_MEMBER6_. snq_6_age BEST12. snq_person6_relationship SNQ_PERSON6_RELATIONSHIP_. snq_person6_q1 
SNQ_PERSON6_Q1_. snq_person6_q2 SNQ_PERSON6_Q2_. snq_person6_q3 SNQ_PERSON6_Q3_. snq_person6_q4 SNQ_PERSON6_Q4_. snq_person6_q5 SNQ_PERSON6_Q5_. snq_person6_q6 SNQ_PERSON6_Q6_. snq_person6_q7 SNQ_PERSON6_Q7_. snq_person6_q8 SNQ_PERSON6_Q8_. snq_person6_q9 
SNQ_PERSON6_Q9_. snq_person6_q10 SNQ_PERSON6_Q10_. add_nw_member7 ADD_NW_MEMBER7_. snq_7_age BEST12. snq_person7_relationship SNQ_PERSON7_RELATIONSHIP_. snq_person7_q1 SNQ_PERSON7_Q1_. snq_person7_q2 SNQ_PERSON7_Q2_. snq_person7_q3 SNQ_PERSON7_Q3_. 
snq_person7_q4 SNQ_PERSON7_Q4_. snq_person7_q5 SNQ_PERSON7_Q5_. snq_person7_q6 SNQ_PERSON7_Q6_. snq_person7_q7 SNQ_PERSON7_Q7_. snq_person7_q8 SNQ_PERSON7_Q8_. snq_person7_q9 SNQ_PERSON7_Q9_. snq_person7_q10 SNQ_PERSON7_Q10_. add_nw_member_8 
ADD_NW_MEMBER_8_. snq_8_age BEST12. snq_person8_relationship SNQ_PERSON8_RELATIONSHIP_. snq_person8_q1 SNQ_PERSON8_Q1_. snq_person8_q2 SNQ_PERSON8_Q2_. snq_person8_q3 SNQ_PERSON8_Q3_. snq_person8_q4 SNQ_PERSON8_Q4_. snq_person8_q5 SNQ_PERSON8_Q5_. 
snq_person8_q6 SNQ_PERSON8_Q6_. snq_person8_q7 SNQ_PERSON8_Q7_. snq_person8_q8 SNQ_PERSON8_Q8_. snq_person8_q09 SNQ_PERSON8_Q09_. snq_person8_q10 SNQ_PERSON8_Q10_. add_nw_member9 ADD_NW_MEMBER9_. snq_9_age BEST12. snq_person9_relationship 
SNQ_PERSON9_RELATIONSHIP_. snq_person9_q1 SNQ_PERSON9_Q1_. snq_person9_q2 SNQ_PERSON9_Q2_. snq_person9_q3 SNQ_PERSON9_Q3_. snq_person9_q4 SNQ_PERSON9_Q4_. snq_person9_q5 SNQ_PERSON9_Q5_. snq_person9_q6 SNQ_PERSON9_Q6_. snq_person9_q7 SNQ_PERSON9_Q7_. 
snq_person9_q8 SNQ_PERSON9_Q8_. snq_person9_q9 SNQ_PERSON9_Q9_. snq_person9_q10 SNQ_PERSON9_Q10_. add_nw_member_10 ADD_NW_MEMBER_10_. snq_10_age BEST12. snq_person10_relationship SNQ_PERSON10_RELATIONSHIP_. snq_person10_q1 SNQ_PERSON10_Q1_. 
snq_person10_q2 SNQ_PERSON10_Q2_. snq_person10_q3 SNQ_PERSON10_Q3_. snq_person10_q4 SNQ_PERSON10_Q4_. snq_person10_q5 SNQ_PERSON10_Q5_. snq_person10_q6 SNQ_PERSON10_Q6_. snq_person10_q7 SNQ_PERSON10_Q7_. snq_person10_q8 SNQ_PERSON10_Q8_. snq_person10_q9 
SNQ_PERSON10_Q9_. snq_person10_q10 SNQ_PERSON10_Q10_. lost_relationship LOST_RELATIONSHIP_. spouse_not_available SPOUSE_NOT_AVAILABLE_. child_not_available CHILD_NOT_AVAILABLE_. relative_not_available RELATIVE_NOT_AVAILABLE_. friends_not_available 
FRIENDS_NOT_AVAILABLE_. other_not_available OTHER_NOT_AVAILABLE_. lost_support LOST_SUPPORT_. options_reduce_drink1 OPTIONS_REDUCE_DRINK1_. options_reduce_drink2 OPTIONS_REDUCE_DRINK2_. options_reduce_drink3 OPTIONS_REDUCE_DRINK3_. options_reduce_drink4 
OPTIONS_REDUCE_DRINK4_. options_reduce_drink5 OPTIONS_REDUCE_DRINK5_. options_reduce_drink6 OPTIONS_REDUCE_DRINK6_. options_reduce_drink7 OPTIONS_REDUCE_DRINK7_. options_reduce_drink8 OPTIONS_REDUCE_DRINK8_. options_reduce_drink9 OPTIONS_REDUCE_DRINK9_. 
options_reduce_drink10 OPTIONS_REDUCE_DRINK10_. almost BEST12. research_survey_of_d_v_1 RESEARCH_SURVEY_OF_D_V_1_. tracker_id BEST12. contact_id BEST12. Intensity BEST12. BP0 BEST12. BP1 BEST12. Omaxe BEST12. Pmaxe BEST12. Koff_Alpha BEST12. HS_Alpha 
BEST12.
DATA2DATASTEP INPUTLIST record_id:BEST32. redcap_data_access_group:$500. redcap_survey_identifier:$500. research_survey_of_d_v_0:$500. icf:ICF_. dob:YYMMDD10. zip_code:$500. gender:GENDER_. race:RACE_. hispanic_latino:HISPANIC_LATINO_. 
marital_status:MARITAL_STATUS_. number_children:BEST12. level_education:LEVEL_EDUCATION_. yearly_income:YEARLY_INCOME_. household_income:HOUSEHOLD_INCOME_. public_benefit_1:PUBLIC_BENEFIT_1_. public_benefit_2:PUBLIC_BENEFIT_2_. 
public_benefit_3:PUBLIC_BENEFIT_3_. public_benefit_4:PUBLIC_BENEFIT_4_. public_benefit_5:PUBLIC_BENEFIT_5_. young_adult_you_know:BEST12. young_adults_live_near:BEST12. young_adult_interacted:BEST12. yng_adlt_interact_online:BEST12. 
age_first_drink:AGE_FIRST_DRINK_. age_first_intoxicated:AGE_FIRST_INTOXICATED_. drink_days_past30:DRINK_DAYS_PAST30_. drinks_per_drink_day:BEST12. treatment_intervention___1:TREATMENT_INTERVENTION___1_. 
treatment_intervention___2:TREATMENT_INTERVENTION___2_. treatment_intervention___3:TREATMENT_INTERVENTION___3_. treatment_intervention___4:TREATMENT_INTERVENTION___4_. treatment_intervention___5:TREATMENT_INTERVENTION___5_. 
treatment_intervention___6:TREATMENT_INTERVENTION___6_. current_tobacco_use:CURRENT_TOBACCO_USE_. lifetime_illicit_drug:LIFETIME_ILLICIT_DRUG_. lifetime_prscrptn_drugs:LIFETIME_PRSCRPTN_DRUGS_. lifetime_alc_drug_mix:LIFETIME_ALC_DRUG_MIX_. 
yaacqb_1:YAACQB_1_. yaacqb_2:YAACQB_2_. yaacqb_3:YAACQB_3_. yaacqb_4:YAACQB_4_. yaacqb_5:YAACQB_5_. yaacqb_6:YAACQB_6_. yaacqb_7:YAACQB_7_. yaacqb_8:YAACQB_8_. yaacqb_9:YAACQB_9_. yaacqb_10:YAACQB_10_. yaacqb_11:YAACQB_11_. yaacqb_12:YAACQB_12_. 
yaacqb_13:YAACQB_13_. yaacqb_14:YAACQB_14_. yaacqb_15:YAACQB_15_. yaacqb_16:YAACQB_16_. yaacqb_17:YAACQB_17_. yaacqb_18:YAACQB_18_. yaacqb_19:YAACQB_19_. yaacqb_20:YAACQB_20_. yaacqb_21:YAACQB_21_. yaacqb_22:YAACQB_22_. yaacqb_23:YAACQB_23_. 
yaacqb_24:YAACQB_24_. dd_1:DD_1_. dd_2:DD_2_. dd_3:DD_3_. dd_4:DD_4_. dd_5:DD_5_. dd_6:DD_6_. dd_7:DD_7_. dd_8:DD_8_. dd_9:DD_9_. dd_10:DD_10_. dd_11:DD_11_. dd_12:DD_12_. dd_13:DD_13_. dd_14:DD_14_. dd_15:DD_15_. dd_16:DD_16_. dd_17:DD_17_. apt_1:BEST12. 
apt_2:BEST12. apt_3:BEST12. apt_4:BEST12. apt_5:BEST12. apt_6:BEST12. apt_7:BEST12. apt_8:BEST12. apt_9:BEST12. apt_10:BEST12. apt_11:BEST12. apt_12:BEST12. apt_13:BEST12. apt_14:BEST12. apt_15:BEST12. apt_16:BEST12. apt_17:BEST12. apt_18:BEST12. 
rdea_index_1:BEST12. rdea_index_2:BEST12. past30_savings:BEST12. ac_lvl_wod_freq1:AC_LVL_WOD_FREQ1_. ac_lvl_wod_freq2:AC_LVL_WOD_FREQ2_. ac_lvl_wod_freq3:AC_LVL_WOD_FREQ3_. ac_lvl_wod_freq4:AC_LVL_WOD_FREQ4_. ac_lvl_wod_freq5:AC_LVL_WOD_FREQ5_. 
ac_lvl_wod_freq6:AC_LVL_WOD_FREQ6_. ac_lvl_wod_freq7:AC_LVL_WOD_FREQ7_. ac_lvl_wod_freq8:AC_LVL_WOD_FREQ8_. ac_lvl_wod_freq9:AC_LVL_WOD_FREQ9_. ac_lvl_wod_freq10:AC_LVL_WOD_FREQ10_. ac_lvl_wod_freq11:AC_LVL_WOD_FREQ11_. 
ac_lvl_wod_freq12:AC_LVL_WOD_FREQ12_. ac_lvl_wod_freq13:AC_LVL_WOD_FREQ13_. ac_lvl_wod_freq14:AC_LVL_WOD_FREQ14_. ac_lvl_wod_freq15:AC_LVL_WOD_FREQ15_. ac_lvl_wod_freq16:AC_LVL_WOD_FREQ16_. ac_lvl_wod_freq17:AC_LVL_WOD_FREQ17_. 
ac_lvl_wod_freq18:AC_LVL_WOD_FREQ18_. ac_lvl_wod_freq19:AC_LVL_WOD_FREQ19_. ac_lvl_wod_freq20:AC_LVL_WOD_FREQ20_. ac_lvl_wod_freq21:AC_LVL_WOD_FREQ21_. ac_lvl_wod_freq22:AC_LVL_WOD_FREQ22_. ac_lvl_wod_freq23:AC_LVL_WOD_FREQ23_. 
ac_lvl_wod_freq24:AC_LVL_WOD_FREQ24_. ac_lvl_wod_freq25:AC_LVL_WOD_FREQ25_. ac_lvl_wod_freq26:AC_LVL_WOD_FREQ26_. ac_lvl_wod_freq27:AC_LVL_WOD_FREQ27_. ac_lvl_wod_freq28:AC_LVL_WOD_FREQ28_. ac_lvl_wod_freq29:AC_LVL_WOD_FREQ29_. 
ac_lvl_wod_freq30:AC_LVL_WOD_FREQ30_. ac_lvl_wod_freq31:AC_LVL_WOD_FREQ31_. ac_lvl_wod_freq32:AC_LVL_WOD_FREQ32_. ac_lvl_wod_freq33:AC_LVL_WOD_FREQ33_. ac_lvl_wod_freq34:AC_LVL_WOD_FREQ34_. ac_lvl_wod_freq35:AC_LVL_WOD_FREQ35_. 
ac_lvl_wod_freq36:AC_LVL_WOD_FREQ36_. act_lvl_wd_freq1:ACT_LVL_WD_FREQ1_. act_lvl_wd_freq2:ACT_LVL_WD_FREQ2_. act_lvl_wd_freq3:ACT_LVL_WD_FREQ3_. act_lvl_wd_freq4:ACT_LVL_WD_FREQ4_. act_lvl_wd_freq5:ACT_LVL_WD_FREQ5_. act_lvl_wd_freq6:ACT_LVL_WD_FREQ6_. 
act_lvl_wd_freq7:ACT_LVL_WD_FREQ7_. act_lvl_wd_freq8:ACT_LVL_WD_FREQ8_. act_lvl_wd_freq9:ACT_LVL_WD_FREQ9_. act_lvl_wd_freq10:ACT_LVL_WD_FREQ10_. act_lvl_wd_freq11:ACT_LVL_WD_FREQ11_. act_lvl_wd_freq12:ACT_LVL_WD_FREQ12_. 
3                                                                                                                        The SAS System                                                                                           10:55 Thursday, March 21, 2019

act_lvl_wd_freq13:ACT_LVL_WD_FREQ13_. act_lvl_wd_freq14:ACT_LVL_WD_FREQ14_. act_lvl_wd_freq15:ACT_LVL_WD_FREQ15_. act_lvl_wd_freq16:ACT_LVL_WD_FREQ16_. act_lvl_wd_freq17:ACT_LVL_WD_FREQ17_. act_lvl_wd_freq18:ACT_LVL_WD_FREQ18_. 
act_lvl_wd_freq19:ACT_LVL_WD_FREQ19_. act_lvl_wd_freq20:ACT_LVL_WD_FREQ20_. act_lvl_wd_freq21:ACT_LVL_WD_FREQ21_. act_lvl_wd_freq22:ACT_LVL_WD_FREQ22_. act_lvl_wd_freq23:ACT_LVL_WD_FREQ23_. act_lvl_wd_freq24:ACT_LVL_WD_FREQ24_. 
act_lvl_wd_freq25:ACT_LVL_WD_FREQ25_. act_lvl_wd_freq26:ACT_LVL_WD_FREQ26_. act_lvl_wd_freq27:ACT_LVL_WD_FREQ27_. act_lvl_wd_freq28:ACT_LVL_WD_FREQ28_. act_lvl_wd_freq29:ACT_LVL_WD_FREQ29_. act_lvl_wd_freq30:ACT_LVL_WD_FREQ30_. 
act_lvl_wd_freq31:ACT_LVL_WD_FREQ31_. act_lvl_wd_freq32:ACT_LVL_WD_FREQ32_. act_lvl_wd_freq33:ACT_LVL_WD_FREQ33_. act_lvl_wd_freq34:ACT_LVL_WD_FREQ34_. act_lvl_wd_freq35:ACT_LVL_WD_FREQ35_. act_lvl_wd_freq36:ACT_LVL_WD_FREQ36_. pbss20_1:PBSS20_1_. 
pbss20_2:PBSS20_2_. pbss20_3:PBSS20_3_. pbss20_4:PBSS20_4_. pbss20_5:PBSS20_5_. pbss20_6:PBSS20_6_. pbss20_7:PBSS20_7_. pbss20_8:PBSS20_8_. pbss20_9:PBSS20_9_. pbss20_10:PBSS20_10_. pbss20_11:PBSS20_11_. pbss20_12:PBSS20_12_. pbss20_13:PBSS20_13_. 
pbss20_14:PBSS20_14_. pbss20_15:PBSS20_15_. pbss20_16:PBSS20_16_. pbss20_17:PBSS20_17_. pbss20_18:PBSS20_18_. pbss20_19:PBSS20_19_. pbss20_20:PBSS20_20_. bscq_1:BEST12. bscq_2:BEST12. bscq_3:BEST12. bscq_4:BEST12. bscq_5:BEST12. bscq_6:BEST12. 
bscq_7:BEST12. bscq_8:BEST12. behavior_change_ladder_2:BEHAVIOR_CHANGE_LADDER_2_. snq_1_age:BEST12. snq_1_relation:SNQ_1_RELATION_. snq_person1_q1:SNQ_PERSON1_Q1_. snq_person1_q2:SNQ_PERSON1_Q2_. snq_person1_q3:SNQ_PERSON1_Q3_. 
snq_person1_q4:SNQ_PERSON1_Q4_. snq_person1_q5:SNQ_PERSON1_Q5_. snq_person1_q6:SNQ_PERSON1_Q6_. snq_person1_q7:SNQ_PERSON1_Q7_. snq_person1_q8:SNQ_PERSON1_Q8_. snq_person1_q9:SNQ_PERSON1_Q9_. snq_person1_q10:SNQ_PERSON1_Q10_. snq_2_age:BEST12. 
snq_person2_relationship:SNQ_PERSON2_RELATIONSHIP_. snq_person2_q1:SNQ_PERSON2_Q1_. snq_person2_q2:SNQ_PERSON2_Q2_. snq_person2_q3:SNQ_PERSON2_Q3_. snq_person2_q4:SNQ_PERSON2_Q4_. snq_person2_q5:SNQ_PERSON2_Q5_. snq_person2_q6:SNQ_PERSON2_Q6_. 
snq_person2_q7:SNQ_PERSON2_Q7_. snq_person2_q8:SNQ_PERSON2_Q8_. snq_person2_q9:SNQ_PERSON2_Q9_. snq_person2_q10:SNQ_PERSON2_Q10_. snq_3_age:BEST12. snq_person3_relationship:SNQ_PERSON3_RELATIONSHIP_. snq_person3_q1:SNQ_PERSON3_Q1_. 
snq_person3_q2:SNQ_PERSON3_Q2_. snq_person3_q3:SNQ_PERSON3_Q3_. snq_person3_q4:SNQ_PERSON3_Q4_. snq_person3_q5:SNQ_PERSON3_Q5_. snq_person3_q6:SNQ_PERSON3_Q6_. snq_person3_q7:SNQ_PERSON3_Q7_. snq_person3_q8:SNQ_PERSON3_Q8_. snq_person3_q9:SNQ_PERSON3_Q9_. 
snq_person3_q10:SNQ_PERSON3_Q10_. snq_4_age:BEST12. snq_person4_relationship:SNQ_PERSON4_RELATIONSHIP_. snq_person4_q1:SNQ_PERSON4_Q1_. snq_person4_q2:SNQ_PERSON4_Q2_. snq_person4_q3:SNQ_PERSON4_Q3_. snq_person4_q4:SNQ_PERSON4_Q4_. 
snq_person4_q5:SNQ_PERSON4_Q5_. snq_person4_q6:SNQ_PERSON4_Q6_. snq_person4_q7:SNQ_PERSON4_Q7_. snq_person4_q8:SNQ_PERSON4_Q8_. snq_person4_q9:SNQ_PERSON4_Q9_. snq_person4_q10:SNQ_PERSON4_Q10_. add_nw_member5:ADD_NW_MEMBER5_. snq_5_age:BEST12. 
snq_person5_relationship:SNQ_PERSON5_RELATIONSHIP_. snq_person5_q1:SNQ_PERSON5_Q1_. snq_person5_q2:SNQ_PERSON5_Q2_. snq_person5_q3:SNQ_PERSON5_Q3_. snq_person5_q4:SNQ_PERSON5_Q4_. snq_person5_q5:SNQ_PERSON5_Q5_. snq_person5_q6:SNQ_PERSON5_Q6_. 
snq_person5_q7:SNQ_PERSON5_Q7_. snq_person5_q8:SNQ_PERSON5_Q8_. snq_person5_q9:SNQ_PERSON5_Q9_. snq_person5_q10:SNQ_PERSON5_Q10_. add_nw_member6:ADD_NW_MEMBER6_. snq_6_age:BEST12. snq_person6_relationship:SNQ_PERSON6_RELATIONSHIP_. 
snq_person6_q1:SNQ_PERSON6_Q1_. snq_person6_q2:SNQ_PERSON6_Q2_. snq_person6_q3:SNQ_PERSON6_Q3_. snq_person6_q4:SNQ_PERSON6_Q4_. snq_person6_q5:SNQ_PERSON6_Q5_. snq_person6_q6:SNQ_PERSON6_Q6_. snq_person6_q7:SNQ_PERSON6_Q7_. snq_person6_q8:SNQ_PERSON6_Q8_. 
snq_person6_q9:SNQ_PERSON6_Q9_. snq_person6_q10:SNQ_PERSON6_Q10_. add_nw_member7:ADD_NW_MEMBER7_. snq_7_age:BEST12. snq_person7_relationship:SNQ_PERSON7_RELATIONSHIP_. snq_person7_q1:SNQ_PERSON7_Q1_. snq_person7_q2:SNQ_PERSON7_Q2_. 
snq_person7_q3:SNQ_PERSON7_Q3_. snq_person7_q4:SNQ_PERSON7_Q4_. snq_person7_q5:SNQ_PERSON7_Q5_. snq_person7_q6:SNQ_PERSON7_Q6_. snq_person7_q7:SNQ_PERSON7_Q7_. snq_person7_q8:SNQ_PERSON7_Q8_. snq_person7_q9:SNQ_PERSON7_Q9_. 
snq_person7_q10:SNQ_PERSON7_Q10_. add_nw_member_8:ADD_NW_MEMBER_8_. snq_8_age:BEST12. snq_person8_relationship:SNQ_PERSON8_RELATIONSHIP_. snq_person8_q1:SNQ_PERSON8_Q1_. snq_person8_q2:SNQ_PERSON8_Q2_. snq_person8_q3:SNQ_PERSON8_Q3_. 
snq_person8_q4:SNQ_PERSON8_Q4_. snq_person8_q5:SNQ_PERSON8_Q5_. snq_person8_q6:SNQ_PERSON8_Q6_. snq_person8_q7:SNQ_PERSON8_Q7_. snq_person8_q8:SNQ_PERSON8_Q8_. snq_person8_q09:SNQ_PERSON8_Q09_. snq_person8_q10:SNQ_PERSON8_Q10_. 
add_nw_member9:ADD_NW_MEMBER9_. snq_9_age:BEST12. snq_person9_relationship:SNQ_PERSON9_RELATIONSHIP_. snq_person9_q1:SNQ_PERSON9_Q1_. snq_person9_q2:SNQ_PERSON9_Q2_. snq_person9_q3:SNQ_PERSON9_Q3_. snq_person9_q4:SNQ_PERSON9_Q4_. 
snq_person9_q5:SNQ_PERSON9_Q5_. snq_person9_q6:SNQ_PERSON9_Q6_. snq_person9_q7:SNQ_PERSON9_Q7_. snq_person9_q8:SNQ_PERSON9_Q8_. snq_person9_q9:SNQ_PERSON9_Q9_. snq_person9_q10:SNQ_PERSON9_Q10_. add_nw_member_10:ADD_NW_MEMBER_10_. snq_10_age:BEST12. 
snq_person10_relationship:SNQ_PERSON10_RELATIONSHIP_. snq_person10_q1:SNQ_PERSON10_Q1_. snq_person10_q2:SNQ_PERSON10_Q2_. snq_person10_q3:SNQ_PERSON10_Q3_. snq_person10_q4:SNQ_PERSON10_Q4_. snq_person10_q5:SNQ_PERSON10_Q5_. 
snq_person10_q6:SNQ_PERSON10_Q6_. snq_person10_q7:SNQ_PERSON10_Q7_. snq_person10_q8:SNQ_PERSON10_Q8_. snq_person10_q9:SNQ_PERSON10_Q9_. snq_person10_q10:SNQ_PERSON10_Q10_. lost_relationship:LOST_RELATIONSHIP_. spouse_not_available:SPOUSE_NOT_AVAILABLE_. 
child_not_available:CHILD_NOT_AVAILABLE_. relative_not_available:RELATIVE_NOT_AVAILABLE_. friends_not_available:FRIENDS_NOT_AVAILABLE_. other_not_available:OTHER_NOT_AVAILABLE_. lost_support:LOST_SUPPORT_. options_reduce_drink1:OPTIONS_REDUCE_DRINK1_. 
options_reduce_drink2:OPTIONS_REDUCE_DRINK2_. options_reduce_drink3:OPTIONS_REDUCE_DRINK3_. options_reduce_drink4:OPTIONS_REDUCE_DRINK4_. options_reduce_drink5:OPTIONS_REDUCE_DRINK5_. options_reduce_drink6:OPTIONS_REDUCE_DRINK6_. 
options_reduce_drink7:OPTIONS_REDUCE_DRINK7_. options_reduce_drink8:OPTIONS_REDUCE_DRINK8_. options_reduce_drink9:OPTIONS_REDUCE_DRINK9_. options_reduce_drink10:OPTIONS_REDUCE_DRINK10_. code_word:$500. almost:BEST12. 
research_survey_of_d_v_1:RESEARCH_SURVEY_OF_D_V_1_. tracker_id:BEST12. contact_id:BEST12. age:32. Citystate:$200. City:$200. Consequences:32. RDEAProp:32. ALQProp:32. DDCount:32. PropLarge:32. Intensity:BEST12. BP0:BEST12. BP1:BEST12. Omaxe:BEST12. 
Pmaxe:BEST12. Koff_Alpha:BEST12. HS_Alpha:BEST12. zIntensity:32. zBP0:32. zBP1:32. zOmaxe:32. zPmaxe:32. zKoff_Alpha:32. zHS_Alpha:32. Amplitude:32. AmplitudeOmaxe:32. PersistenceKoff:32. PersistenceHS:32. Options_Reduce:32. Options_Reduce2:32. NSSQ:32. 
NSSQ2:32. ACT_Sum:32. ACT_mean:32. AC_Sum:32. AC_mean:32. BSCQ:32. BSCQ2:32. pbss20:32. pbss202:32. White:32. Married:32. HighSchool:32.
DATA2DATASTEP LBL YES
DATA2DATASTEP LBLLIST White="Are they white? Y/N" Married="Are they married? Y/N" HighSchool="Do they have at least HS edu? Y/N"
DATA2DATASTEP LIB RDS
DATA2DATASTEP LS 256
DATA2DATASTEP MEMLABEL 
DATA2DATASTEP MSGTYPE NOTE
DATA2DATASTEP OBS 10
DATA2DATASTEP OUTLIB WORK
DATA2DATASTEP SQLEXITCODE 0
DATA2DATASTEP SQLOBS 351
DATA2DATASTEP SQLOOPS 719
DATA2DATASTEP SQLRC 0
DATA2DATASTEP SQLXOBS 0
DATA2DATASTEP SQLXOPENERRS 0
DATA2DATASTEP VARLIST record_id redcap_data_access_group redcap_survey_identifier research_survey_of_d_v_0 icf dob zip_code gender race hispanic_latino marital_status number_children level_education yearly_income household_income public_benefit_1 
public_benefit_2 public_benefit_3 public_benefit_4 public_benefit_5 young_adult_you_know young_adults_live_near young_adult_interacted yng_adlt_interact_online age_first_drink age_first_intoxicated drink_days_past30 drinks_per_drink_day 
treatment_intervention___1 treatment_intervention___2 treatment_intervention___3 treatment_intervention___4 treatment_intervention___5 treatment_intervention___6 current_tobacco_use lifetime_illicit_drug lifetime_prscrptn_drugs lifetime_alc_drug_mix 
yaacqb_1 yaacqb_2 yaacqb_3 yaacqb_4 yaacqb_5 yaacqb_6 yaacqb_7 yaacqb_8 yaacqb_9 yaacqb_10 yaacqb_11 yaacqb_12 yaacqb_13 yaacqb_14 yaacqb_15 yaacqb_16 yaacqb_17 yaacqb_18 yaacqb_19 yaacqb_20 yaacqb_21 yaacqb_22 yaacqb_23 yaacqb_24 dd_1 dd_2 dd_3 dd_4 dd_5 
dd_6 dd_7 dd_8 dd_9 dd_10 dd_11 dd_12 dd_13 dd_14 dd_15 dd_16 dd_17 apt_1 apt_2 apt_3 apt_4 apt_5 apt_6 apt_7 apt_8 apt_9 apt_10 apt_11 apt_12 apt_13 apt_14 apt_15 apt_16 apt_17 apt_18 rdea_index_1 rdea_index_2 past30_savings ac_lvl_wod_freq1 
ac_lvl_wod_freq2 ac_lvl_wod_freq3 ac_lvl_wod_freq4 ac_lvl_wod_freq5 ac_lvl_wod_freq6 ac_lvl_wod_freq7 ac_lvl_wod_freq8 ac_lvl_wod_freq9 ac_lvl_wod_freq10 ac_lvl_wod_freq11 ac_lvl_wod_freq12 ac_lvl_wod_freq13 ac_lvl_wod_freq14 ac_lvl_wod_freq15 
ac_lvl_wod_freq16 ac_lvl_wod_freq17 ac_lvl_wod_freq18 ac_lvl_wod_freq19 ac_lvl_wod_freq20 ac_lvl_wod_freq21 ac_lvl_wod_freq22 ac_lvl_wod_freq23 ac_lvl_wod_freq24 ac_lvl_wod_freq25 ac_lvl_wod_freq26 ac_lvl_wod_freq27 ac_lvl_wod_freq28 ac_lvl_wod_freq29 
ac_lvl_wod_freq30 ac_lvl_wod_freq31 ac_lvl_wod_freq32 ac_lvl_wod_freq33 ac_lvl_wod_freq34 ac_lvl_wod_freq35 ac_lvl_wod_freq36 act_lvl_wd_freq1 act_lvl_wd_freq2 act_lvl_wd_freq3 act_lvl_wd_freq4 act_lvl_wd_freq5 act_lvl_wd_freq6 act_lvl_wd_freq7 
act_lvl_wd_freq8 act_lvl_wd_freq9 act_lvl_wd_freq10 act_lvl_wd_freq11 act_lvl_wd_freq12 act_lvl_wd_freq13 act_lvl_wd_freq14 act_lvl_wd_freq15 act_lvl_wd_freq16 act_lvl_wd_freq17 act_lvl_wd_freq18 act_lvl_wd_freq19 act_lvl_wd_freq20 act_lvl_wd_freq21 
act_lvl_wd_freq22 act_lvl_wd_freq23 act_lvl_wd_freq24 act_lvl_wd_freq25 act_lvl_wd_freq26 act_lvl_wd_freq27 act_lvl_wd_freq28 act_lvl_wd_freq29 act_lvl_wd_freq30 act_lvl_wd_freq31 act_lvl_wd_freq32 act_lvl_wd_freq33 act_lvl_wd_freq34 act_lvl_wd_freq35 
act_lvl_wd_freq36 pbss20_1 pbss20_2 pbss20_3 pbss20_4 pbss20_5 pbss20_6 pbss20_7 pbss20_8 pbss20_9 pbss20_10 pbss20_11 pbss20_12 pbss20_13 pbss20_14 pbss20_15 pbss20_16 pbss20_17 pbss20_18 pbss20_19 pbss20_20 bscq_1 bscq_2 bscq_3 bscq_4 bscq_5 bscq_6 
bscq_7 bscq_8 behavior_change_ladder_2 snq_1_age snq_1_relation snq_person1_q1 snq_person1_q2 snq_person1_q3 snq_person1_q4 snq_person1_q5 snq_person1_q6 snq_person1_q7 snq_person1_q8 snq_person1_q9 snq_person1_q10 snq_2_age snq_person2_relationship 
snq_person2_q1 snq_person2_q2 snq_person2_q3 snq_person2_q4 snq_person2_q5 snq_person2_q6 snq_person2_q7 snq_person2_q8 snq_person2_q9 snq_person2_q10 snq_3_age snq_person3_relationship snq_person3_q1 snq_person3_q2 snq_person3_q3 snq_person3_q4 
snq_person3_q5 snq_person3_q6 snq_person3_q7 snq_person3_q8 snq_person3_q9 snq_person3_q10 snq_4_age snq_person4_relationship snq_person4_q1 snq_person4_q2 snq_person4_q3 snq_person4_q4 snq_person4_q5 snq_person4_q6 snq_person4_q7 snq_person4_q8 
4                                                                                                                        The SAS System                                                                                           10:55 Thursday, March 21, 2019

snq_person4_q9 snq_person4_q10 add_nw_member5 snq_5_age snq_person5_relationship snq_person5_q1 snq_person5_q2 snq_person5_q3 snq_person5_q4 snq_person5_q5 snq_person5_q6 snq_person5_q7 snq_person5_q8 snq_person5_q9 snq_person5_q10 add_nw_member6 
snq_6_age snq_person6_relationship snq_person6_q1 snq_person6_q2 snq_person6_q3 snq_person6_q4 snq_person6_q5 snq_person6_q6 snq_person6_q7 snq_person6_q8 snq_person6_q9 snq_person6_q10 add_nw_member7 snq_7_age snq_person7_relationship snq_person7_q1 
snq_person7_q2 snq_person7_q3 snq_person7_q4 snq_person7_q5 snq_person7_q6 snq_person7_q7 snq_person7_q8 snq_person7_q9 snq_person7_q10 add_nw_member_8 snq_8_age snq_person8_relationship snq_person8_q1 snq_person8_q2 snq_person8_q3 snq_person8_q4 
snq_person8_q5 snq_person8_q6 snq_person8_q7 snq_person8_q8 snq_person8_q09 snq_person8_q10 add_nw_member9 snq_9_age snq_person9_relationship snq_person9_q1 snq_person9_q2 snq_person9_q3 snq_person9_q4 snq_person9_q5 snq_person9_q6 snq_person9_q7 
snq_person9_q8 snq_person9_q9 snq_person9_q10 add_nw_member_10 snq_10_age snq_person10_relationship snq_person10_q1 snq_person10_q2 snq_person10_q3 snq_person10_q4 snq_person10_q5 snq_person10_q6 snq_person10_q7 snq_person10_q8 snq_person10_q9 
snq_person10_q10 lost_relationship spouse_not_available child_not_available relative_not_available friends_not_available other_not_available lost_support options_reduce_drink1 options_reduce_drink2 options_reduce_drink3 options_reduce_drink4 
options_reduce_drink5 options_reduce_drink6 options_reduce_drink7 options_reduce_drink8 options_reduce_drink9 options_reduce_drink10 code_word almost research_survey_of_d_v_1 tracker_id contact_id age Citystate City Consequences RDEAProp ALQProp DDCount 
PropLarge Intensity BP0 BP1 Omaxe Pmaxe Koff_Alpha HS_Alpha zIntensity zBP0 zBP1 zOmaxe zPmaxe zKoff_Alpha zHS_Alpha Amplitude AmplitudeOmaxe PersistenceKoff PersistenceHS Options_Reduce Options_Reduce2 NSSQ NSSQ2 ACT_Sum ACT_mean AC_Sum AC_mean BSCQ 
BSCQ2 pbss20 pbss202 White Married HighSchool
NOTE: The quoted string currently being processed has become more than 262 characters long.  You might have unbalanced quotation marks.
NOTE: The quoted string currently being processed has become more than 262 characters long.  You might have unbalanced quotation marks.

NOTE: Format $EDCAP_DATA_ACCESS_GROUP_ was not found or could not be loaded.
NOTE: Format RESEARCH_SURVEY_OF_D_V_1_ was not found or could not be loaded.
NOTE: Format $EDCAP_DATA_ACCESS_GROUP_ was not found or could not be loaded.
NOTE: Format RESEARCH_SURVEY_OF_D_V_1_ was not found or could not be loaded.
data WORK.CLEAN_DUMMY;
  infile datalines dsd truncover;

input record_id:BEST32. redcap_data_access_group:$500. redcap_survey_identifier:$500. research_survey_of_d_v_0:$500. icf:ICF_. dob:YYMMDD10. zip_code:$500. gender:GENDER_. race:RACE_. hispanic_latino:HISPANIC_LATINO_. marital_status:MARITAL_STATUS_. number
_children:BEST12. level_education:LEVEL_EDUCATION_. yearly_income:YEARLY_INCOME_. household_income:HOUSEHOLD_INCOME_. public_benefit_1:PUBLIC_BENEFIT_1_. public_benefit_2:PUBLIC_BENEFIT_2_. public_benefit_3:PUBLIC_BENEFIT_3_. public_benefit_4:PUBLIC_BENEFI
T_4_. public_benefit_5:PUBLIC_BENEFIT_5_. young_adult_you_know:BEST12. young_adults_live_near:BEST12. young_adult_interacted:BEST12. yng_adlt_interact_online:BEST12. age_first_drink:AGE_FIRST_DRINK_. age_first_intoxicated:AGE_FIRST_INTOXICATED_. drink_days
_past30:DRINK_DAYS_PAST30_. drinks_per_drink_day:BEST12. treatment_intervention___1:TREATMENT_INTERVENTION___1_. treatment_intervention___2:TREATMENT_INTERVENTION___2_. treatment_intervention___3:TREATMENT_INTERVENTION___3_. treatment_intervention___4:TREA
TMENT_INTERVENTION___4_. treatment_intervention___5:TREATMENT_INTERVENTION___5_. treatment_intervention___6:TREATMENT_INTERVENTION___6_. current_tobacco_use:CURRENT_TOBACCO_USE_. lifetime_illicit_drug:LIFETIME_ILLICIT_DRUG_. lifetime_prscrptn_drugs:LIFETIM
E_PRSCRPTN_DRUGS_. lifetime_alc_drug_mix:LIFETIME_ALC_DRUG_MIX_. yaacqb_1:YAACQB_1_. yaacqb_2:YAACQB_2_. yaacqb_3:YAACQB_3_. yaacqb_4:YAACQB_4_. yaacqb_5:YAACQB_5_. yaacqb_6:YAACQB_6_. yaacqb_7:YAACQB_7_. yaacqb_8:YAACQB_8_. yaacqb_9:YAACQB_9_. yaacqb_10:Y
AACQB_10_. yaacqb_11:YAACQB_11_. yaacqb_12:YAACQB_12_. yaacqb_13:YAACQB_13_. yaacqb_14:YAACQB_14_. yaacqb_15:YAACQB_15_. yaacqb_16:YAACQB_16_. yaacqb_17:YAACQB_17_. yaacqb_18:YAACQB_18_. yaacqb_19:YAACQB_19_. yaacqb_20:YAACQB_20_. yaacqb_21:YAACQB_21_. yaa
cqb_22:YAACQB_22_. yaacqb_23:YAACQB_23_. yaacqb_24:YAACQB_24_. dd_1:DD_1_. dd_2:DD_2_. dd_3:DD_3_. dd_4:DD_4_. dd_5:DD_5_. dd_6:DD_6_. dd_7:DD_7_. dd_8:DD_8_. dd_9:DD_9_. dd_10:DD_10_. dd_11:DD_11_. dd_12:DD_12_. dd_13:DD_13_. dd_14:DD_14_. dd_15:DD_15_. d
d_16:DD_16_. dd_17:DD_17_. apt_1:BEST12. apt_2:BEST12. apt_3:BEST12. apt_4:BEST12. apt_5:BEST12. apt_6:BEST12. apt_7:BEST12. apt_8:BEST12. apt_9:BEST12. apt_10:BEST12. apt_11:BEST12. apt_12:BEST12. apt_13:BEST12. apt_14:BEST12. apt_15:BEST12. apt_16:BEST12
. apt_17:BEST12. apt_18:BEST12. rdea_index_1:BEST12. rdea_index_2:BEST12. past30_savings:BEST12. ac_lvl_wod_freq1:AC_LVL_WOD_FREQ1_. ac_lvl_wod_freq2:AC_LVL_WOD_FREQ2_. ac_lvl_wod_freq3:AC_LVL_WOD_FREQ3_. ac_lvl_wod_freq4:AC_LVL_WOD_FREQ4_. ac_lvl_wod_freq
5:AC_LVL_WOD_FREQ5_. ac_lvl_wod_freq6:AC_LVL_WOD_FREQ6_. ac_lvl_wod_freq7:AC_LVL_WOD_FREQ7_. ac_lvl_wod_freq8:AC_LVL_WOD_FREQ8_. ac_lvl_wod_freq9:AC_LVL_WOD_FREQ9_. ac_lvl_wod_freq10:AC_LVL_WOD_FREQ10_. ac_lvl_wod_freq11:AC_LVL_WOD_FREQ11_. ac_lvl_wod_freq
12:AC_LVL_WOD_FREQ12_. ac_lvl_wod_freq13:AC_LVL_WOD_FREQ13_. ac_lvl_wod_freq14:AC_LVL_WOD_FREQ14_. ac_lvl_wod_freq15:AC_LVL_WOD_FREQ15_. ac_lvl_wod_freq16:AC_LVL_WOD_FREQ16_. ac_lvl_wod_freq17:AC_LVL_WOD_FREQ17_. ac_lvl_wod_freq18:AC_LVL_WOD_FREQ18_. ac_lv
l_wod_freq19:AC_LVL_WOD_FREQ19_. ac_lvl_wod_freq20:AC_LVL_WOD_FREQ20_. ac_lvl_wod_freq21:AC_LVL_WOD_FREQ21_. ac_lvl_wod_freq22:AC_LVL_WOD_FREQ22_. ac_lvl_wod_freq23:AC_LVL_WOD_FREQ23_. ac_lvl_wod_freq24:AC_LVL_WOD_FREQ24_. ac_lvl_wod_freq25:AC_LVL_WOD_FREQ
25_. ac_lvl_wod_freq26:AC_LVL_WOD_FREQ26_. ac_lvl_wod_freq27:AC_LVL_WOD_FREQ27_. ac_lvl_wod_freq28:AC_LVL_WOD_FREQ28_. ac_lvl_wod_freq29:AC_LVL_WOD_FREQ29_. ac_lvl_wod_freq30:AC_LVL_WOD_FREQ30_. ac_lvl_wod_freq31:AC_LVL_WOD_FREQ31_. ac_lvl_wod_freq32:AC_LV
L_WOD_FREQ32_. ac_lvl_wod_freq33:AC_LVL_WOD_FREQ33_. ac_lvl_wod_freq34:AC_LVL_WOD_FREQ34_. ac_lvl_wod_freq35:AC_LVL_WOD_FREQ35_. ac_lvl_wod_freq36:AC_LVL_WOD_FREQ36_. act_lvl_wd_freq1:ACT_LVL_WD_FREQ1_. act_lvl_wd_freq2:ACT_LVL_WD_FREQ2_. act_lvl_wd_freq3:
ACT_LVL_WD_FREQ3_. act_lvl_wd_freq4:ACT_LVL_WD_FREQ4_. act_lvl_wd_freq5:ACT_LVL_WD_FREQ5_. act_lvl_wd_freq6:ACT_LVL_WD_FREQ6_. act_lvl_wd_freq7:ACT_LVL_WD_FREQ7_. act_lvl_wd_freq8:ACT_LVL_WD_FREQ8_. act_lvl_wd_freq9:ACT_LVL_WD_FREQ9_. act_lvl_wd_freq10:ACT
_LVL_WD_FREQ10_. act_lvl_wd_freq11:ACT_LVL_WD_FREQ11_. act_lvl_wd_freq12:ACT_LVL_WD_FREQ12_. act_lvl_wd_freq13:ACT_LVL_WD_FREQ13_. act_lvl_wd_freq14:ACT_LVL_WD_FREQ14_. act_lvl_wd_freq15:ACT_LVL_WD_FREQ15_. act_lvl_wd_freq16:ACT_LVL_WD_FREQ16_. act_lvl_wd_
freq17:ACT_LVL_WD_FREQ17_. act_lvl_wd_freq18:ACT_LVL_WD_FREQ18_. act_lvl_wd_freq19:ACT_LVL_WD_FREQ19_. act_lvl_wd_freq20:ACT_LVL_WD_FREQ20_. act_lvl_wd_freq21:ACT_LVL_WD_FREQ21_. act_lvl_wd_freq22:ACT_LVL_WD_FREQ22_. act_lvl_wd_freq23:ACT_LVL_WD_FREQ23_. a
ct_lvl_wd_freq24:ACT_LVL_WD_FREQ24_. act_lvl_wd_freq25:ACT_LVL_WD_FREQ25_. act_lvl_wd_freq26:ACT_LVL_WD_FREQ26_. act_lvl_wd_freq27:ACT_LVL_WD_FREQ27_. act_lvl_wd_freq28:ACT_LVL_WD_FREQ28_. act_lvl_wd_freq29:ACT_LVL_WD_FREQ29_. act_lvl_wd_freq30:ACT_LVL_WD_
FREQ30_. act_lvl_wd_freq31:ACT_LVL_WD_FREQ31_. act_lvl_wd_freq32:ACT_LVL_WD_FREQ32_. act_lvl_wd_freq33:ACT_LVL_WD_FREQ33_. act_lvl_wd_freq34:ACT_LVL_WD_FREQ34_. act_lvl_wd_freq35:ACT_LVL_WD_FREQ35_. act_lvl_wd_freq36:ACT_LVL_WD_FREQ36_. pbss20_1:PBSS20_1_.
 pbss20_2:PBSS20_2_. pbss20_3:PBSS20_3_. pbss20_4:PBSS20_4_. pbss20_5:PBSS20_5_. pbss20_6:PBSS20_6_. pbss20_7:PBSS20_7_. pbss20_8:PBSS20_8_. pbss20_9:PBSS20_9_. pbss20_10:PBSS20_10_. pbss20_11:PBSS20_11_. pbss20_12:PBSS20_12_. pbss20_13:PBSS20_13_. pbss20_
14:PBSS20_14_. pbss20_15:PBSS20_15_. pbss20_16:PBSS20_16_. pbss20_17:PBSS20_17_. pbss20_18:PBSS20_18_. pbss20_19:PBSS20_19_. pbss20_20:PBSS20_20_. bscq_1:BEST12. bscq_2:BEST12. bscq_3:BEST12. bscq_4:BEST12. bscq_5:BEST12. bscq_6:BEST12. bscq_7:BEST12. bscq
_8:BEST12. behavior_change_ladder_2:BEHAVIOR_CHANGE_LADDER_2_. snq_1_age:BEST12. snq_1_relation:SNQ_1_RELATION_. snq_person1_q1:SNQ_PERSON1_Q1_. snq_person1_q2:SNQ_PERSON1_Q2_. snq_person1_q3:SNQ_PERSON1_Q3_. snq_person1_q4:SNQ_PERSON1_Q4_. snq_person1_q5:
SNQ_PERSON1_Q5_. snq_person1_q6:SNQ_PERSON1_Q6_. snq_person1_q7:SNQ_PERSON1_Q7_. snq_person1_q8:SNQ_PERSON1_Q8_. snq_person1_q9:SNQ_PERSON1_Q9_. snq_person1_q10:SNQ_PERSON1_Q10_. snq_2_age:BEST12. snq_person2_relationship:SNQ_PERSON2_RELATIONSHIP_. snq_per
son2_q1:SNQ_PERSON2_Q1_. snq_person2_q2:SNQ_PERSON2_Q2_. snq_person2_q3:SNQ_PERSON2_Q3_. snq_person2_q4:SNQ_PERSON2_Q4_. snq_person2_q5:SNQ_PERSON2_Q5_. snq_person2_q6:SNQ_PERSON2_Q6_. snq_person2_q7:SNQ_PERSON2_Q7_. snq_person2_q8:SNQ_PERSON2_Q8_. snq_per
son2_q9:SNQ_PERSON2_Q9_. snq_person2_q10:SNQ_PERSON2_Q10_. snq_3_age:BEST12. snq_person3_relationship:SNQ_PERSON3_RELATIONSHIP_. snq_person3_q1:SNQ_PERSON3_Q1_. snq_person3_q2:SNQ_PERSON3_Q2_. snq_person3_q3:SNQ_PERSON3_Q3_. snq_person3_q4:SNQ_PERSON3_Q4_.
 snq_person3_q5:SNQ_PERSON3_Q5_. snq_person3_q6:SNQ_PERSON3_Q6_. snq_person3_q7:SNQ_PERSON3_Q7_. snq_person3_q8:SNQ_PERSON3_Q8_. snq_person3_q9:SNQ_PERSON3_Q9_. snq_person3_q10:SNQ_PERSON3_Q10_. snq_4_age:BEST12. snq_person4_relationship:SNQ_PERSON4_RELATI
ONSHIP_. snq_person4_q1:SNQ_PERSON4_Q1_. snq_person4_q2:SNQ_PERSON4_Q2_. snq_person4_q3:SNQ_PERSON4_Q3_. snq_person4_q4:SNQ_PERSON4_Q4_. snq_person4_q5:SNQ_PERSON4_Q5_. snq_person4_q6:SNQ_PERSON4_Q6_. snq_person4_q7:SNQ_PERSON4_Q7_. snq_person4_q8:SNQ_PERS
ON4_Q8_. snq_person4_q9:SNQ_PERSON4_Q9_. snq_person4_q10:SNQ_PERSON4_Q10_. add_nw_member5:ADD_NW_MEMBER5_. snq_5_age:BEST12. snq_person5_relationship:SNQ_PERSON5_RELATIONSHIP_. snq_person5_q1:SNQ_PERSON5_Q1_. snq_person5_q2:SNQ_PERSON5_Q2_. snq_person5_q3:
SNQ_PERSON5_Q3_. snq_person5_q4:SNQ_PERSON5_Q4_. snq_person5_q5:SNQ_PERSON5_Q5_. snq_person5_q6:SNQ_PERSON5_Q6_. snq_person5_q7:SNQ_PERSON5_Q7_. snq_person5_q8:SNQ_PERSON5_Q8_. snq_person5_q9:SNQ_PERSON5_Q9_. snq_person5_q10:SNQ_PERSON5_Q10_. add_nw_member
6:ADD_NW_MEMBER6_. snq_6_age:BEST12. snq_person6_relationship:SNQ_PERSON6_RELATIONSHIP_. snq_person6_q1:SNQ_PERSON6_Q1_. snq_person6_q2:SNQ_PERSON6_Q2_. snq_person6_q3:SNQ_PERSON6_Q3_. snq_person6_q4:SNQ_PERSON6_Q4_. snq_person6_q5:SNQ_PERSON6_Q5_. snq_per
son6_q6:SNQ_PERSON6_Q6_. snq_person6_q7:SNQ_PERSON6_Q7_. snq_person6_q8:SNQ_PERSON6_Q8_. snq_person6_q9:SNQ_PERSON6_Q9_. snq_person6_q10:SNQ_PERSON6_Q10_. add_nw_member7:ADD_NW_MEMBER7_. snq_7_age:BEST12. snq_person7_relationship:SNQ_PERSON7_RELATIONSHIP_.
 snq_person7_q1:SNQ_PERSON7_Q1_. snq_person7_q2:SNQ_PERSON7_Q2_. snq_person7_q3:SNQ_PERSON7_Q3_. snq_person7_q4:SNQ_PERSON7_Q4_. snq_person7_q5:SNQ_PERSON7_Q5_. snq_person7_q6:SNQ_PERSON7_Q6_. snq_person7_q7:SNQ_PERSON7_Q7_. snq_person7_q8:SNQ_PERSON7_Q8_.
 snq_person7_q9:SNQ_PERSON7_Q9_. snq_person7_q10:SNQ_PERSON7_Q10_. add_nw_member_8:ADD_NW_MEMBER_8_. snq_8_age:BEST12. snq_person8_relationship:SNQ_PERSON8_RELATIONSHIP_. snq_person8_q1:SNQ_PERSON8_Q1_. snq_person8_q2:SNQ_PERSON8_Q2_. snq_person8_q3:SNQ_PE
RSON8_Q3_. snq_person8_q4:SNQ_PERSON8_Q4_. snq_person8_q5:SNQ_PERSON8_Q5_. snq_person8_q6:SNQ_PERSON8_Q6_. snq_person8_q7:SNQ_PERSON8_Q7_. snq_person8_q8:SNQ_PERSON8_Q8_. snq_person8_q09:SNQ_PERSON8_Q09_. snq_person8_q10:SNQ_PERSON8_Q10_. add_nw_member9:AD
D_NW_MEMBER9_. snq_9_age:BEST12. snq_person9_relationship:SNQ_PERSON9_RELATIONSHIP_. snq_person9_q1:SNQ_PERSON9_Q1_. snq_person9_q2:SNQ_PERSON9_Q2_. snq_person9_q3:SNQ_PERSON9_Q3_. snq_person9_q4:SNQ_PERSON9_Q4_. snq_person9_q5:SNQ_PERSON9_Q5_. snq_person9
_q6:SNQ_PERSON9_Q6_. snq_person9_q7:SNQ_PERSON9_Q7_. snq_person9_q8:SNQ_PERSON9_Q8_. snq_person9_q9:SNQ_PERSON9_Q9_. snq_person9_q10:SNQ_PERSON9_Q10_. add_nw_member_10:ADD_NW_MEMBER_10_. snq_10_age:BEST12. snq_person10_relationship:SNQ_PERSON10_RELATIONSHI
P_. snq_person10_q1:SNQ_PERSON10_Q1_. snq_person10_q2:SNQ_PERSON10_Q2_. snq_person10_q3:SNQ_PERSON10_Q3_. snq_person10_q4:SNQ_PERSON10_Q4_. snq_person10_q5:SNQ_PERSON10_Q5_. snq_person10_q6:SNQ_PERSON10_Q6_. snq_person10_q7:SNQ_PERSON10_Q7_. snq_person10_q
8:SNQ_PERSON10_Q8_. snq_person10_q9:SNQ_PERSON10_Q9_. snq_person10_q10:SNQ_PERSON10_Q10_. lost_relationship:LOST_RELATIONSHIP_. spouse_not_available:SPOUSE_NOT_AVAILABLE_. child_not_available:CHILD_NOT_AVAILABLE_. relative_not_available:RELATIVE_NOT_AVAILA
5                                                                                                                        The SAS System                                                                                           10:55 Thursday, March 21, 2019

BLE_. friends_not_available:FRIENDS_NOT_AVAILABLE_. other_not_available:OTHER_NOT_AVAILABLE_. lost_support:LOST_SUPPORT_. options_reduce_drink1:OPTIONS_REDUCE_DRINK1_. options_reduce_drink2:OPTIONS_REDUCE_DRINK2_. options_reduce_drink3:OPTIONS_REDUCE_DRINK
3_. options_reduce_drink4:OPTIONS_REDUCE_DRINK4_. options_reduce_drink5:OPTIONS_REDUCE_DRINK5_. options_reduce_drink6:OPTIONS_REDUCE_DRINK6_. options_reduce_drink7:OPTIONS_REDUCE_DRINK7_. options_reduce_drink8:OPTIONS_REDUCE_DRINK8_. options_reduce_drink9:
OPTIONS_REDUCE_DRINK9_. options_reduce_drink10:OPTIONS_REDUCE_DRINK10_. code_word:$500. almost:BEST12. research_survey_of_d_v_1:RESEARCH_SURVEY_OF_D_V_1_. tracker_id:BEST12. contact_id:BEST12. age:32. Citystate:$200. City:$200. Consequences:32. RDEAProp:32
. ALQProp:32. DDCount:32. PropLarge:32. Intensity:BEST12. BP0:BEST12. BP1:BEST12. Omaxe:BEST12. Pmaxe:BEST12. Koff_Alpha:BEST12. HS_Alpha:BEST12. zIntensity:32. zBP0:32. zBP1:32. zOmaxe:32. zPmaxe:32. zKoff_Alpha:32. zHS_Alpha:32. Amplitude:32. AmplitudeOm
axe:32. PersistenceKoff:32. PersistenceHS:32. Options_Reduce:32. Options_Reduce2:32. NSSQ:32. NSSQ2:32. ACT_Sum:32. ACT_mean:32. AC_Sum:32. AC_mean:32. BSCQ:32. BSCQ2:32. pbss20:32. pbss202:32. White:32. Married:32. HighSchool:32.;

format record_id BEST32. icf ICF_. dob YYMMDD10. gender GENDER_. race RACE_. hispanic_latino HISPANIC_LATINO_. marital_status MARITAL_STATUS_. number_children BEST12. level_education LEVEL_EDUCATION_. yearly_income YEARLY_INCOME_. household_income HOUSEHOL
D_INCOME_. public_benefit_1 PUBLIC_BENEFIT_1_. public_benefit_2 PUBLIC_BENEFIT_2_. public_benefit_3 PUBLIC_BENEFIT_3_. public_benefit_4 PUBLIC_BENEFIT_4_. public_benefit_5 PUBLIC_BENEFIT_5_. young_adult_you_know BEST12. young_adults_live_near BEST12. young
_adult_interacted BEST12. yng_adlt_interact_online BEST12. age_first_drink AGE_FIRST_DRINK_. age_first_intoxicated AGE_FIRST_INTOXICATED_. drink_days_past30 DRINK_DAYS_PAST30_. drinks_per_drink_day BEST12. treatment_intervention___1 TREATMENT_INTERVENTION_
__1_. treatment_intervention___2 TREATMENT_INTERVENTION___2_. treatment_intervention___3 TREATMENT_INTERVENTION___3_. treatment_intervention___4 TREATMENT_INTERVENTION___4_. treatment_intervention___5 TREATMENT_INTERVENTION___5_. treatment_intervention___6
 TREATMENT_INTERVENTION___6_. current_tobacco_use CURRENT_TOBACCO_USE_. lifetime_illicit_drug LIFETIME_ILLICIT_DRUG_. lifetime_prscrptn_drugs LIFETIME_PRSCRPTN_DRUGS_. lifetime_alc_drug_mix LIFETIME_ALC_DRUG_MIX_. yaacqb_1 YAACQB_1_. yaacqb_2 YAACQB_2_. ya
acqb_3 YAACQB_3_. yaacqb_4 YAACQB_4_. yaacqb_5 YAACQB_5_. yaacqb_6 YAACQB_6_. yaacqb_7 YAACQB_7_. yaacqb_8 YAACQB_8_. yaacqb_9 YAACQB_9_. yaacqb_10 YAACQB_10_. yaacqb_11 YAACQB_11_. yaacqb_12 YAACQB_12_. yaacqb_13 YAACQB_13_. yaacqb_14 YAACQB_14_. yaacqb_1
5 YAACQB_15_. yaacqb_16 YAACQB_16_. yaacqb_17 YAACQB_17_. yaacqb_18 YAACQB_18_. yaacqb_19 YAACQB_19_. yaacqb_20 YAACQB_20_. yaacqb_21 YAACQB_21_. yaacqb_22 YAACQB_22_. yaacqb_23 YAACQB_23_. yaacqb_24 YAACQB_24_. dd_1 DD_1_. dd_2 DD_2_. dd_3 DD_3_. dd_4 DD_
4_. dd_5 DD_5_. dd_6 DD_6_. dd_7 DD_7_. dd_8 DD_8_. dd_9 DD_9_. dd_10 DD_10_. dd_11 DD_11_. dd_12 DD_12_. dd_13 DD_13_. dd_14 DD_14_. dd_15 DD_15_. dd_16 DD_16_. dd_17 DD_17_. apt_1 BEST12. apt_2 BEST12. apt_3 BEST12. apt_4 BEST12. apt_5 BEST12. apt_6 BEST
12. apt_7 BEST12. apt_8 BEST12. apt_9 BEST12. apt_10 BEST12. apt_11 BEST12. apt_12 BEST12. apt_13 BEST12. apt_14 BEST12. apt_15 BEST12. apt_16 BEST12. apt_17 BEST12. apt_18 BEST12. rdea_index_1 BEST12. rdea_index_2 BEST12. past30_savings BEST12. ac_lvl_wod
_freq1 AC_LVL_WOD_FREQ1_. ac_lvl_wod_freq2 AC_LVL_WOD_FREQ2_. ac_lvl_wod_freq3 AC_LVL_WOD_FREQ3_. ac_lvl_wod_freq4 AC_LVL_WOD_FREQ4_. ac_lvl_wod_freq5 AC_LVL_WOD_FREQ5_. ac_lvl_wod_freq6 AC_LVL_WOD_FREQ6_. ac_lvl_wod_freq7 AC_LVL_WOD_FREQ7_. ac_lvl_wod_fre
q8 AC_LVL_WOD_FREQ8_. ac_lvl_wod_freq9 AC_LVL_WOD_FREQ9_. ac_lvl_wod_freq10 AC_LVL_WOD_FREQ10_. ac_lvl_wod_freq11 AC_LVL_WOD_FREQ11_. ac_lvl_wod_freq12 AC_LVL_WOD_FREQ12_. ac_lvl_wod_freq13 AC_LVL_WOD_FREQ13_. ac_lvl_wod_freq14 AC_LVL_WOD_FREQ14_. ac_lvl_w
od_freq15 AC_LVL_WOD_FREQ15_. ac_lvl_wod_freq16 AC_LVL_WOD_FREQ16_. ac_lvl_wod_freq17 AC_LVL_WOD_FREQ17_. ac_lvl_wod_freq18 AC_LVL_WOD_FREQ18_. ac_lvl_wod_freq19 AC_LVL_WOD_FREQ19_. ac_lvl_wod_freq20 AC_LVL_WOD_FREQ20_. ac_lvl_wod_freq21 AC_LVL_WOD_FREQ21_
. ac_lvl_wod_freq22 AC_LVL_WOD_FREQ22_. ac_lvl_wod_freq23 AC_LVL_WOD_FREQ23_. ac_lvl_wod_freq24 AC_LVL_WOD_FREQ24_. ac_lvl_wod_freq25 AC_LVL_WOD_FREQ25_. ac_lvl_wod_freq26 AC_LVL_WOD_FREQ26_. ac_lvl_wod_freq27 AC_LVL_WOD_FREQ27_. ac_lvl_wod_freq28 AC_LVL_W
OD_FREQ28_. ac_lvl_wod_freq29 AC_LVL_WOD_FREQ29_. ac_lvl_wod_freq30 AC_LVL_WOD_FREQ30_. ac_lvl_wod_freq31 AC_LVL_WOD_FREQ31_. ac_lvl_wod_freq32 AC_LVL_WOD_FREQ32_. ac_lvl_wod_freq33 AC_LVL_WOD_FREQ33_. ac_lvl_wod_freq34 AC_LVL_WOD_FREQ34_. ac_lvl_wod_freq3
5 AC_LVL_WOD_FREQ35_. ac_lvl_wod_freq36 AC_LVL_WOD_FREQ36_. act_lvl_wd_freq1 ACT_LVL_WD_FREQ1_. act_lvl_wd_freq2 ACT_LVL_WD_FREQ2_. act_lvl_wd_freq3 ACT_LVL_WD_FREQ3_. act_lvl_wd_freq4 ACT_LVL_WD_FREQ4_. act_lvl_wd_freq5 ACT_LVL_WD_FREQ5_. act_lvl_wd_freq6
 ACT_LVL_WD_FREQ6_. act_lvl_wd_freq7 ACT_LVL_WD_FREQ7_. act_lvl_wd_freq8 ACT_LVL_WD_FREQ8_. act_lvl_wd_freq9 ACT_LVL_WD_FREQ9_. act_lvl_wd_freq10 ACT_LVL_WD_FREQ10_. act_lvl_wd_freq11 ACT_LVL_WD_FREQ11_. act_lvl_wd_freq12 ACT_LVL_WD_FREQ12_. act_lvl_wd_fre
q13 ACT_LVL_WD_FREQ13_. act_lvl_wd_freq14 ACT_LVL_WD_FREQ14_. act_lvl_wd_freq15 ACT_LVL_WD_FREQ15_. act_lvl_wd_freq16 ACT_LVL_WD_FREQ16_. act_lvl_wd_freq17 ACT_LVL_WD_FREQ17_. act_lvl_wd_freq18 ACT_LVL_WD_FREQ18_. act_lvl_wd_freq19 ACT_LVL_WD_FREQ19_. act_
lvl_wd_freq20 ACT_LVL_WD_FREQ20_. act_lvl_wd_freq21 ACT_LVL_WD_FREQ21_. act_lvl_wd_freq22 ACT_LVL_WD_FREQ22_. act_lvl_wd_freq23 ACT_LVL_WD_FREQ23_. act_lvl_wd_freq24 ACT_LVL_WD_FREQ24_. act_lvl_wd_freq25 ACT_LVL_WD_FREQ25_. act_lvl_wd_freq26 ACT_LVL_WD_FRE
Q26_. act_lvl_wd_freq27 ACT_LVL_WD_FREQ27_. act_lvl_wd_freq28 ACT_LVL_WD_FREQ28_. act_lvl_wd_freq29 ACT_LVL_WD_FREQ29_. act_lvl_wd_freq30 ACT_LVL_WD_FREQ30_. act_lvl_wd_freq31 ACT_LVL_WD_FREQ31_. act_lvl_wd_freq32 ACT_LVL_WD_FREQ32_. act_lvl_wd_freq33 ACT_
LVL_WD_FREQ33_. act_lvl_wd_freq34 ACT_LVL_WD_FREQ34_. act_lvl_wd_freq35 ACT_LVL_WD_FREQ35_. act_lvl_wd_freq36 ACT_LVL_WD_FREQ36_. pbss20_1 PBSS20_1_. pbss20_2 PBSS20_2_. pbss20_3 PBSS20_3_. pbss20_4 PBSS20_4_. pbss20_5 PBSS20_5_. pbss20_6 PBSS20_6_. pbss20
_7 PBSS20_7_. pbss20_8 PBSS20_8_. pbss20_9 PBSS20_9_. pbss20_10 PBSS20_10_. pbss20_11 PBSS20_11_. pbss20_12 PBSS20_12_. pbss20_13 PBSS20_13_. pbss20_14 PBSS20_14_. pbss20_15 PBSS20_15_. pbss20_16 PBSS20_16_. pbss20_17 PBSS20_17_. pbss20_18 PBSS20_18_. pbss
20_19 PBSS20_19_. pbss20_20 PBSS20_20_. bscq_1 BEST12. bscq_2 BEST12. bscq_3 BEST12. bscq_4 BEST12. bscq_5 BEST12. bscq_6 BEST12. bscq_7 BEST12. bscq_8 BEST12. behavior_change_ladder_2 BEHAVIOR_CHANGE_LADDER_2_. snq_1_age BEST12. snq_1_relation SNQ_1_RELAT
ION_. snq_person1_q1 SNQ_PERSON1_Q1_. snq_person1_q2 SNQ_PERSON1_Q2_. snq_person1_q3 SNQ_PERSON1_Q3_. snq_person1_q4 SNQ_PERSON1_Q4_. snq_person1_q5 SNQ_PERSON1_Q5_. snq_person1_q6 SNQ_PERSON1_Q6_. snq_person1_q7 SNQ_PERSON1_Q7_. snq_person1_q8 SNQ_PERSON1
_Q8_. snq_person1_q9 SNQ_PERSON1_Q9_. snq_person1_q10 SNQ_PERSON1_Q10_. snq_2_age BEST12. snq_person2_relationship SNQ_PERSON2_RELATIONSHIP_. snq_person2_q1 SNQ_PERSON2_Q1_. snq_person2_q2 SNQ_PERSON2_Q2_. snq_person2_q3 SNQ_PERSON2_Q3_. snq_person2_q4 SNQ
_PERSON2_Q4_. snq_person2_q5 SNQ_PERSON2_Q5_. snq_person2_q6 SNQ_PERSON2_Q6_. snq_person2_q7 SNQ_PERSON2_Q7_. snq_person2_q8 SNQ_PERSON2_Q8_. snq_person2_q9 SNQ_PERSON2_Q9_. snq_person2_q10 SNQ_PERSON2_Q10_. snq_3_age BEST12. snq_person3_relationship SNQ_P
ERSON3_RELATIONSHIP_. snq_person3_q1 SNQ_PERSON3_Q1_. snq_person3_q2 SNQ_PERSON3_Q2_. snq_person3_q3 SNQ_PERSON3_Q3_. snq_person3_q4 SNQ_PERSON3_Q4_. snq_person3_q5 SNQ_PERSON3_Q5_. snq_person3_q6 SNQ_PERSON3_Q6_. snq_person3_q7 SNQ_PERSON3_Q7_. snq_person
3_q8 SNQ_PERSON3_Q8_. snq_person3_q9 SNQ_PERSON3_Q9_. snq_person3_q10 SNQ_PERSON3_Q10_. snq_4_age BEST12. snq_person4_relationship SNQ_PERSON4_RELATIONSHIP_. snq_person4_q1 SNQ_PERSON4_Q1_. snq_person4_q2 SNQ_PERSON4_Q2_. snq_person4_q3 SNQ_PERSON4_Q3_. sn
q_person4_q4 SNQ_PERSON4_Q4_. snq_person4_q5 SNQ_PERSON4_Q5_. snq_person4_q6 SNQ_PERSON4_Q6_. snq_person4_q7 SNQ_PERSON4_Q7_. snq_person4_q8 SNQ_PERSON4_Q8_. snq_person4_q9 SNQ_PERSON4_Q9_. snq_person4_q10 SNQ_PERSON4_Q10_. add_nw_member5 ADD_NW_MEMBER5_. 
snq_5_age BEST12. snq_person5_relationship SNQ_PERSON5_RELATIONSHIP_. snq_person5_q1 SNQ_PERSON5_Q1_. snq_person5_q2 SNQ_PERSON5_Q2_. snq_person5_q3 SNQ_PERSON5_Q3_. snq_person5_q4 SNQ_PERSON5_Q4_. snq_person5_q5 SNQ_PERSON5_Q5_. snq_person5_q6 SNQ_PERSON5
_Q6_. snq_person5_q7 SNQ_PERSON5_Q7_. snq_person5_q8 SNQ_PERSON5_Q8_. snq_person5_q9 SNQ_PERSON5_Q9_. snq_person5_q10 SNQ_PERSON5_Q10_. add_nw_member6 ADD_NW_MEMBER6_. snq_6_age BEST12. snq_person6_relationship SNQ_PERSON6_RELATIONSHIP_. snq_person6_q1 SNQ
_PERSON6_Q1_. snq_person6_q2 SNQ_PERSON6_Q2_. snq_person6_q3 SNQ_PERSON6_Q3_. snq_person6_q4 SNQ_PERSON6_Q4_. snq_person6_q5 SNQ_PERSON6_Q5_. snq_person6_q6 SNQ_PERSON6_Q6_. snq_person6_q7 SNQ_PERSON6_Q7_. snq_person6_q8 SNQ_PERSON6_Q8_. snq_person6_q9 SNQ
_PERSON6_Q9_. snq_person6_q10 SNQ_PERSON6_Q10_. add_nw_member7 ADD_NW_MEMBER7_. snq_7_age BEST12. snq_person7_relationship SNQ_PERSON7_RELATIONSHIP_. snq_person7_q1 SNQ_PERSON7_Q1_. snq_person7_q2 SNQ_PERSON7_Q2_. snq_person7_q3 SNQ_PERSON7_Q3_. snq_person
7_q4 SNQ_PERSON7_Q4_. snq_person7_q5 SNQ_PERSON7_Q5_. snq_person7_q6 SNQ_PERSON7_Q6_. snq_person7_q7 SNQ_PERSON7_Q7_. snq_person7_q8 SNQ_PERSON7_Q8_. snq_person7_q9 SNQ_PERSON7_Q9_. snq_person7_q10 SNQ_PERSON7_Q10_. add_nw_member_8 ADD_NW_MEMBER_8_. snq_8_
age BEST12. snq_person8_relationship SNQ_PERSON8_RELATIONSHIP_. snq_person8_q1 SNQ_PERSON8_Q1_. snq_person8_q2 SNQ_PERSON8_Q2_. snq_person8_q3 SNQ_PERSON8_Q3_. snq_person8_q4 SNQ_PERSON8_Q4_. snq_person8_q5 SNQ_PERSON8_Q5_. snq_person8_q6 SNQ_PERSON8_Q6_. 
snq_person8_q7 SNQ_PERSON8_Q7_. snq_person8_q8 SNQ_PERSON8_Q8_. snq_person8_q09 SNQ_PERSON8_Q09_. snq_person8_q10 SNQ_PERSON8_Q10_. add_nw_member9 ADD_NW_MEMBER9_. snq_9_age BEST12. snq_person9_relationship SNQ_PERSON9_RELATIONSHIP_. snq_person9_q1 SNQ_PER
SON9_Q1_. snq_person9_q2 SNQ_PERSON9_Q2_. snq_person9_q3 SNQ_PERSON9_Q3_. snq_person9_q4 SNQ_PERSON9_Q4_. snq_person9_q5 SNQ_PERSON9_Q5_. snq_person9_q6 SNQ_PERSON9_Q6_. snq_person9_q7 SNQ_PERSON9_Q7_. snq_person9_q8 SNQ_PERSON9_Q8_. snq_person9_q9 SNQ_PER
SON9_Q9_. snq_person9_q10 SNQ_PERSON9_Q10_. add_nw_member_10 ADD_NW_MEMBER_10_. snq_10_age BEST12. snq_person10_relationship SNQ_PERSON10_RELATIONSHIP_. snq_person10_q1 SNQ_PERSON10_Q1_. snq_person10_q2 SNQ_PERSON10_Q2_. snq_person10_q3 SNQ_PERSON10_Q3_. s
nq_person10_q4 SNQ_PERSON10_Q4_. snq_person10_q5 SNQ_PERSON10_Q5_. snq_person10_q6 SNQ_PERSON10_Q6_. snq_person10_q7 SNQ_PERSON10_Q7_. snq_person10_q8 SNQ_PERSON10_Q8_. snq_person10_q9 SNQ_PERSON10_Q9_. snq_person10_q10 SNQ_PERSON10_Q10_. lost_relationship
 LOST_RELATIONSHIP_. spouse_not_available SPOUSE_NOT_AVAILABLE_. child_not_available CHILD_NOT_AVAILABLE_. relative_not_available RELATIVE_NOT_AVAILABLE_. friends_not_available FRIENDS_NOT_AVAILABLE_. other_not_available OTHER_NOT_AVAILABLE_. lost_support 
LOST_SUPPORT_. options_reduce_drink1 OPTIONS_REDUCE_DRINK1_. options_reduce_drink2 OPTIONS_REDUCE_DRINK2_. options_reduce_drink3 OPTIONS_REDUCE_DRINK3_. options_reduce_drink4 OPTIONS_REDUCE_DRINK4_. options_reduce_drink5 OPTIONS_REDUCE_DRINK5_. options_red
uce_drink6 OPTIONS_REDUCE_DRINK6_. options_reduce_drink7 OPTIONS_REDUCE_DRINK7_. options_reduce_drink8 OPTIONS_REDUCE_DRINK8_. options_reduce_drink9 OPTIONS_REDUCE_DRINK9_. options_reduce_drink10 OPTIONS_REDUCE_DRINK10_. almost BEST12. research_survey_of_d
_v_1 RESEARCH_SURVEY_OF_D_V_1_. tracker_id BEST12. contact_id BEST12. Intensity BEST12. BP0 BEST12. BP1 BEST12. Omaxe BEST12. Pmaxe BEST12. Koff_Alpha BEST12. HS_Alpha BEST12.;
  label White="Are they white? Y/N" Married="Are they married? Y/N" HighSchool="Do they have at least HS edu? Y/N";
datalines;
2     6/16/2017 19:26 Yes - I have read and understand this information. I consent and agree to participate in this research study. 1994-12-18 32312 Female White Yes Living with a partner or boyfriend/girlfriend 0 Some college or a 2-year degree
$5,000 to $9,999 $10,000 to $19,999 No No No No Yes 100 50 20 15 19 years old 19 years old 9 3 Unchecked Unchecked Unchecked Unchecked Checked Unchecked Yes No No No Yes Yes Yes Yes No Yes No Yes Yes No Yes Yes Yes No No Yes Yes Yes Yes Yes No Yes Yes No
$540 today $750 in 61 days? $190 today $850 in 7 days? $250 in 19 days $470 today $350 in 13 days? $600 in 14 days? $780 today $550 in 62 days? $300 in 7 days? $670 today $340 today $500 in 21 days? $850 in 91 days? $600 in 89 days? $800 today 10 10 10 10
8 7 7 6 4 3 2 2 2 1 1 0 0 0 80 30 0 4 = more than once a day 0 = 0 times 2 = 2-4 times a week 0 = 0 times 1 = once a week or less 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 3 = about once a day 0 = 0 times 2 = 2-4 times a week
0 = 0 times 2 = 2-4 times a week 0 = 0 times 0 = 0 times 1 = once a week or less 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 3 = about once a day 1 = once a week or less 0 = 0 times 1 = once a week or less 2 = 2-4 times a week
2 = 2-4 times a week 0 = 0 times 1 = once a week or less 0 = 0 times 1 = once a week or less 3 = about once a day 3 = about once a day 2 = 2-4 times a week 0 = 0 times 0 = 0 times 3 = about once a day 2 = 2-4 times a week 3 = about once a day 0 = 0 times
1 = once a week or less 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 1 = once a week or less 1 = once a week or less 0 = 0 times 2 = 2-4 times a week 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 1 = once a week or less 0 = 0 times
2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 0 = 0 times 0 = 0 times 1 = once a week or less 0 = 0 times 2 = 2-4 times a week 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times
6                                                                                                                        The SAS System                                                                                           10:55 Thursday, March 21, 2019

0 = 0 times 1 = once a week or less 5: Always 2: Rarely 3: Sometimes 3: Sometimes 1: Never 2: Rarely 4: Often 4: Often 2: Rarely 3: Sometimes 1: Never 2: Rarely 2: Rarely 2: Rarely 3: Sometimes 4: Often 4: Often 2: Rarely 4: Often 3: Sometimes 10 22 83 84
18 10 34 79 ___ ╠═ 30  ═╣Think I need to consider changing my drinking someday. 26 Spouse or partner 5: A great deal 5: A great deal 5: A great deal 5: A great deal 5: A great deal 5: A great deal 3: Moderately 2: A little 3: Moderately Yes 27
Friend 5: A great deal 5: A great deal 5: A great deal 4: Quite a bit 5: A great deal 4: Quite a bit 3: Moderately 1: Not at all 2: A little Yes 75 Other family member or relative 5: A great deal 5: A great deal 4: Quite a bit 4: Quite a bit
5: A great deal 5: A great deal 1: Not at all 5: A great deal 1: Not at all No 33 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . No . . . . . not at all 3 = Moderate interest 3 = Moderate interest 1 = No interest, I would not use this option 2 = Minimal interest 2 = Minimal interest 2 = Minimal interest 1 = No interest, I would not use this option
1 = No interest, I would not use this option 2 = Minimal interest 2 = Minimal interest Larping . 2 . . 24 Tallahassee, FL Tallahassee 17 0.375 0.2714285714 10 0.5882352941 10 12 10 18 3 0.005983593 0.012037866 0.6053999573 -0.10228631 -0.508094566
-0.307100356 -1.061389346 -0.383870499 -0.18447152 0.6053999573 0.1491498006 -0.565113692 -0.515263947 19 3.4545454545 116 3.625 19 0.5277777778 51 1.4166666667 340 42.5 56 2.8 1 0 1
3     3/22/2018 11:10 Yes - I have read and understand this information. I consent and agree to participate in this research study. 1995-03-12 12345 Female White No Single/Divorced or separated 0 Post-graduate or advanced professional degree
I choose not to answer I choose not to answer I choose not to answer I choose not to answer I choose not to answer I choose not to answer I choose not to answer 25 24 12 5 I choose not to answer I choose not to answer 1 1 Unchecked Unchecked Unchecked
Unchecked Checked Unchecked I choose not to answer No No No No No No No No No No No No No No No No No No No No No No No No No No No $540 today $750 in 61 days? $250 in 53 days? $850 in 7 days? $250 in 19 days $500 in 160 days? $350 in 13 days?
$600 in 14 days? $780 today $550 in 62 days? $300 in 7 days? $750 in 119 days? $340 today $500 in 21 days? $850 in 91 days? $600 in 89 days? $800 today 2 2 2 2 2 2 2 2 2 2 2 2 2 2 1 1 0 0 500 0 250 4 = more than once a day 1 = once a week or less
0 = 0 times 0 = 0 times 1 = once a week or less 2 = 2-4 times a week 4 = more than once a day P 4 = more than once a day 2 = 2-4 times a week 0 = 0 times 2 = 2-4 times a week 3 = about once a day 3 = about once a day 2 = 2-4 times a week 0 = 0 times
4 = more than once a day 2 = 2-4 times a week 0 = 0 times 4 = more than once a day 1 = once a week or less 2 = 2-4 times a week 0 = 0 times 1 = once a week or less 1 = once a week or less 2 = 2-4 times a week 4 = more than once a day P
1 = once a week or less 2 = 2-4 times a week 2 = 2-4 times a week 4 = more than once a day 0 = 0 times 0 = 0 times 4 = more than once a day 3 = about once a day 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times
0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times
1 = once a week or less 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 5: Always 5: Always 3: Sometimes 5: Always 5: Always 3: Sometimes 2: Rarely 5: Always 5: Always 5: Always 1: Never 5: Always 5: Always 5: Always
5: Always 5: Always 5: Always 5: Always 5: Always 5: Always 100 100 100 100 100 100 90 100 ___ ╠═ 00  ═╣No thought of changing my drinking. 67 Other family member or relative 4: Quite a bit 4: Quite a bit 3: Moderately 4: Quite a bit 3: Moderately
3: Moderately 1: Not at all 1: Not at all 1: Not at all Yes 70 Friend 3: Moderately 3: Moderately 2: A little 4: Quite a bit 4: Quite a bit 2: A little 1: Not at all 1: Not at all 1: Not at all Yes 55 Work or school associate 3: Moderately 3: Moderately
2: A little 3: Moderately 3: Moderately 2: A little 1: Not at all 1: Not at all 1: Not at all Yes 30 Friend 3: Moderately 3: Moderately 2: A little 4: Quite a bit 1: Not at all 1: Not at all 1: Not at all 1: Not at all 1: Not at all No No . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . No . . . . . I did not lose anyone 3 = Moderate interest 2 = Minimal interest 2 = Minimal interest 2 = Minimal interest
3 = Moderate interest 3 = Moderate interest 1 = No interest, I would not use this option 1 = No interest, I would not use this option 1 = No interest, I would not use this option 3 = Moderate interest decker . 2 . . 24 Schenectady, NY Schenectady 0 0
0.0151515152 13 0.7647058824 2 15 12 18 9 0.006670907 0.007042177 -1.138376923 0.5292801653 -0.125442114 -0.307100356 0.179260573 -0.264881259 -0.763567639 -1.138376923 -0.72273864 -0.129540789 -0.254212384 21 3.8181818182 97 2.2558139535 1 0.0277777778 65
1.9117647059 790 98.75 89 4.45 1 0 1
4     [not completed] Yes - I have read and understand this information. I consent and agree to participate in this research study. 1992-07-21 32607 Female White No Living with a partner or boyfriend/girlfriend 0 Some post-graduate work $20,000 to $29,999
$20,000 to $29,999 No No No No No 1000 10000 10000 100 18 years old 20 years old 7 2 Unchecked Unchecked Unchecked Unchecked Checked Unchecked No No No No No No No No No No No No No No No No No No No No No No No No No No No No $550 in 117 days?
$750 in 61 days? $190 today $850 in 7 days? $250 in 19 days $500 in 160 days? $150 today $250 today $780 today $550 in 62 days? $300 in 7 days? $750 in 119 days? $350 in 186 days? $270 today $850 in 91 days? $600 in 89 days? $850 in 157 days? 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 1 1 1 200 200 200 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week
2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week
2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week
2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week
2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week
2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week
2 = 2-4 times a week 2 = 2-4 times a week 3: Sometimes 3: Sometimes 3: Sometimes 3: Sometimes 3: Sometimes 3: Sometimes 3: Sometimes 3: Sometimes 3: Sometimes 3: Sometimes 3: Sometimes 3: Sometimes 3: Sometimes 3: Sometimes 3: Sometimes 3: Sometimes
3: Sometimes 3: Sometimes 3: Sometimes 3: Sometimes 53 57 56 55 53 55 56 55 ___ ╠═ 30  ═╣Think I need to consider changing my drinking someday. 25 Friend 3: Moderately 3: Moderately 3: Moderately 3: Moderately 3: Moderately 3: Moderately
3: Moderately 3: Moderately 3: Moderately Yes 24 Friend 2: A little 2: A little 2: A little 2: A little 2: A little 2: A little 2: A little 2: A little 2: A little Yes 24 Other family member or relative 1: Not at all 1: Not at all 1: Not at all
1: Not at all 1: Not at all 1: Not at all 1: Not at all 1: Not at all 1: Not at all Yes 24 Neighbor 1: Not at all 1: Not at all 1: Not at all 1: Not at all 1: Not at all 1: Not at all 1: Not at all 1: Not at all 1: Not at all Yes Yes 34
Health care provider, counselor, or therapist 1: Not at all 1: Not at all 1: Not at all 1: Not at all 1: Not at all 1: Not at all 1: Not at all 1: Not at all 1: Not at all Yes No . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . Yes 0 0 0 0 1 moderately 1 = No interest, I would not use this option 1 = No interest, I would not use this option 1 = No interest, I would not use this option 1 = No interest, I would not use this option
1 = No interest, I would not use this option 1 = No interest, I would not use this option 1 = No interest, I would not use this option 1 = No interest, I would not use this option 1 = No interest, I would not use this option
1 = No interest, I would not use this option 1234 . 0 . . 26 Gainesville, FL Gainesville 0 1 0.5 12 0.7058823529 . . . . . . . . . . . . . . . . . . 10 1.8181818182 97 1.7962962963 72 2 72 2 440 55 60 3 1 0 1
6     4/17/2018 20:06 Yes - I have read and understand this information. I consent and agree to participate in this research study. 1992-04-05 32204 Female White No Single/Never married 0 Post-graduate or advanced professional degree $60,000 to $69,999
$60,000 to $69,999 No No No No No 30 15 15 15 21 years old 21 years old 15 3 Unchecked Unchecked Unchecked Unchecked Checked Unchecked No Yes No No Yes Yes Yes Yes Yes No No Yes No No No Yes No No No No No No No No No No No No $540 today $750 in 61 days?
$250 in 53 days? $850 in 7 days? $250 in 19 days $470 today $350 in 13 days? $600 in 14 days? $780 today $400 today $300 in 7 days? $670 today $340 today $500 in 21 days? $850 in 91 days? $490 today $800 today 6 6 6 6 5 5 5 3 3 3 2 2 2 2 2 1 1 1 1000 50
500 4 = more than once a day 1 = once a week or less 2 = 2-4 times a week P 4 = more than once a day 4 = more than once a day 4 = more than once a day 3 = about once a day 4 = more than once a day 1 = once a week or less 1 = once a week or less
2 = 2-4 times a week 4 = more than once a day 4 = more than once a day 2 = 2-4 times a week 1 = once a week or less 4 = more than once a day 3 = about once a day 4 = more than once a day 4 = more than once a day 2 = 2-4 times a week 3 = about once a day
1 = once a week or less 4 = more than once a day 2 = 2-4 times a week 1 = once a week or less 4 = more than once a day 1 = once a week or less 1 = once a week or less 0 = 0 times 3 = about once a day 3 = about once a day 0 = 0 times 0 = 0 times
4 = more than once a day 4 = more than once a day 1 = once a week or less 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 1 = once a week or less 1 = once a week or less 1 = once a week or less 1 = once a week or less 1 = once a week or less 0 = 0 times
0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 2 = 2-4 times a week 2 = 2-4 times a week 1 = once a week or less 0 = 0 times 0 = 0 times 1 = once a week or less 1 = once a week or less 1 = once a week or less 0 = 0 times
0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 1 = once a week or less 0 = 0 times 0 = 0 times 1 = once a week or less 1 = once a week or less 5: Always 4: Often 5: Always 4: Often 2: Rarely 2: Rarely 2: Rarely 5: Always 3: Sometimes 5: Always
5: Always 3: Sometimes 4: Often 2: Rarely 3: Sometimes 5: Always 5: Always 3: Sometimes 4: Often 5: Always 100 100 24 100 100 100 49 52 ___ ╠═ 20  ═╣ 26 Friend 5: A great deal 5: A great deal 5: A great deal 5: A great deal 5: A great deal
3: Moderately 2: A little 1: Not at all 2: A little Yes 29 Spouse or partner 4: Quite a bit 4: Quite a bit 4: Quite a bit 5: A great deal 5: A great deal 4: Quite a bit 4: Quite a bit 2: A little 2: A little Yes 61 Other family member or relative
5: A great deal 5: A great deal 5: A great deal 5: A great deal 5: A great deal 5: A great deal 2: A little 1: Not at all 1: Not at all No 27 Friend 5: A great deal 5: A great deal 5: A great deal 5: A great deal 5: A great deal 4: Quite a bit
3: Moderately 1: Not at all 1: Not at all Yes No . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Yes 0 0 0 2 1 a little 3 = Moderate interest
3 = Moderate interest 2 = Minimal interest 1 = No interest, I would not use this option 1 = No interest, I would not use this option 2 = Minimal interest 1 = No interest, I would not use this option 1 = No interest, I would not use this option
1 = No interest, I would not use this option 1 = No interest, I would not use this option Joe . 2 53 4 26 Jacksonville, FL Jacksonville 7 0.05 0.1603773585 9 0.5294117647 6 . 20 20 20 0.006535743 0.010742097 -0.266488483 . 1.405167693 -0.176486588
2.4537854252 -0.288281134 -0.334675986 -0.266488483 -0.221487535 0.8485463491 0.836947636 16 2.9090909091 146 3.3953488372 17 0.4722222222 89 2.5428571429 625 78.125 76 3.8 1 0 1
15     5/6/2018 18:07 Yes - I have read and understand this information. I consent and agree to participate in this research study. 1989-03-26 32084 Female White No Single/Never married 0 Post-graduate or advanced professional degree $40,000 to $49,999
$40,000 to $49,999 No No No No No 16 7 4 4 21 years old 22 years old 7 4 Unchecked Unchecked Unchecked Unchecked Checked Unchecked No No No No Yes Yes Yes No No No No No No No No No No No No No Yes No No No No No No No $540 today $550 today $190 today
7                                                                                                                        The SAS System                                                                                           10:55 Thursday, March 21, 2019

$850 in 7 days? $140 today $470 today $150 today $250 today $780 today $400 today $110 today $670 today $340 today $270 today $690 today $490 today $800 today 6 6 6 5 5 3 3 2 1 1 1 1 1 1 1 1 1 1 200 20 250 4 = more than once a day 0 = 0 times 0 = 0 times
2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 0 = 0 times 3 = about once a day 0 = 0 times 0 = 0 times 0 = 0 times 4 = more than once a day 4 = more than once a day 1 = once a week or less 1 = once a week or less
0 = 0 times 1 = once a week or less 0 = 0 times 1 = once a week or less 0 = 0 times 0 = 0 times 0 = 0 times 1 = once a week or less 1 = once a week or less 0 = 0 times 1 = once a week or less 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times
0 = 0 times 0 = 0 times 4 = more than once a day 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times
0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 2 = 2-4 times a week 0 = 0 times
4: Often 5: Always 3: Sometimes 4: Often 5: Always 3: Sometimes 4: Often 4: Often 4: Often 5: Always 4: Often 5: Always 3: Sometimes 5: Always 4: Often 4: Often 3: Sometimes 5: Always 3: Sometimes 5: Always 76 81 75 90 82 95 69 92
___ ╠═ 00  ═╣No thought of changing my drinking. 25 Friend 5: A great deal 4: Quite a bit 3: Moderately 4: Quite a bit 5: A great deal 4: Quite a bit 4: Quite a bit 3: Moderately 5: A great deal Yes 27 Friend 5: A great deal 4: Quite a bit
5: A great deal 5: A great deal 3: Moderately 5: A great deal 3: Moderately 4: Quite a bit 3: Moderately Yes 43 Other family member or relative 5: A great deal 4: Quite a bit 4: Quite a bit 5: A great deal 4: Quite a bit 4: Quite a bit 4: Quite a bit
5: A great deal 5: A great deal Yes 31 Work or school associate 5: A great deal 3: Moderately 4: Quite a bit 3: Moderately 4: Quite a bit 3: Moderately 3: Moderately 4: Quite a bit 3: Moderately Yes No . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . No . . . . . a little 3 = Moderate interest 4 = High interest 3 = Moderate interest 2 = Minimal interest 3 = Moderate interest 3 = Moderate interest
3 = Moderate interest 3 = Moderate interest 3 = Moderate interest 2 = Minimal interest Sushi . 2 66 19 29 Saint Augustine, FL Saint Augustine 4 0.1 0.0555555556 1 0.0588235294 6 . 20 20 20 0.013299163 0.028533164 -0.266488483 . 1.405167693 -0.176486588
2.4537854252 0.8826163072 1.7276497213 -0.266488483 -0.221487535 1.1412707094 1.3525290629 29 5.2727272727 162 3.7674418605 2 0.0555555556 34 0.9444444444 660 82.5 82 4.1 1 0 1
16     [not completed] Yes - I have read and understand this information. I consent and agree to participate in this research study. 1992-08-29 33063 Female White No Married 0 4-year college degree $30,000 to $39,999 Don't know. No No No No No 50 30 20 15
22 years old 22 years old 5 3 Unchecked Unchecked Unchecked Unchecked Checked Unchecked No Yes No No Yes Yes Yes Yes No No No Yes Yes Yes No Yes Yes No Yes Yes Yes No No No Yes No No No $550 in 117 days? $750 in 61 days? $250 in 53 days? $850 in 7 days?
$250 in 19 days $500 in 160 days? $350 in 13 days? $600 in 14 days? $780 today $400 today $300 in 7 days? $670 today $340 today $500 in 21 days? $690 today $490 today $800 today 8 7 7 7 6 6 6 5 4 4 3 3 2 2 1 1 0 0 600 200 500 4 = more than once a day
0 = 0 times 0 = 0 times 0 = 0 times 1 = once a week or less 2 = 2-4 times a week 1 = once a week or less 1 = once a week or less 3 = about once a day 0 = 0 times 0 = 0 times 1 = once a week or less 3 = about once a day 3 = about once a day
1 = once a week or less 0 = 0 times 4 = more than once a day 1 = once a week or less 1 = once a week or less 4 = more than once a day 0 = 0 times 0 = 0 times 0 = 0 times 1 = once a week or less 1 = once a week or less 0 = 0 times 0 = 0 times 0 = 0 times
0 = 0 times 0 = 0 times 2 = 2-4 times a week 3 = about once a day 0 = 0 times 0 = 0 times 4 = more than once a day 3 = about once a day 4 = more than once a day 0 = 0 times 0 = 0 times 0 = 0 times 1 = once a week or less 2 = 2-4 times a week
1 = once a week or less 1 = once a week or less 3 = about once a day 0 = 0 times 1 = once a week or less 0 = 0 times 3 = about once a day 3 = about once a day 1 = once a week or less 0 = 0 times 4 = more than once a day 1 = once a week or less
1 = once a week or less 4 = more than once a day 0 = 0 times 0 = 0 times 0 = 0 times 1 = once a week or less 1 = once a week or less 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 2 = 2-4 times a week 3 = about once a day 0 = 0 times
0 = 0 times 4 = more than once a day 3 = about once a day 4: Often 3: Sometimes 5: Always 4: Often 4: Often 4: Often 4: Often 5: Always 4: Often 3: Sometimes 2: Rarely 3: Sometimes 4: Often 4: Often 3: Sometimes 5: Always 5: Always 5: Always 5: Always
5: Always 75 100 84 100 90 75 70 33 ___ ╠═ 00  ═╣No thought of changing my drinking. 22 Other family member or relative 5: A great deal 4: Quite a bit 4: Quite a bit 4: Quite a bit 5: A great deal 5: A great deal 2: A little 3: Moderately
4: Quite a bit Yes 28 Spouse or partner 5: A great deal 5: A great deal 5: A great deal 5: A great deal 5: A great deal 5: A great deal 3: Moderately 2: A little 3: Moderately Yes 26 Friend 5: A great deal 5: A great deal 5: A great deal 4: Quite a bit
4: Quite a bit 4: Quite a bit 5: A great deal 2: A little 3: Moderately Yes 25 Friend 5: A great deal 5: A great deal 5: A great deal 3: Moderately 4: Quite a bit 4: Quite a bit 4: Quite a bit 3: Moderately 3: Moderately Yes No . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Yes 0 0 1 2 1 a little 2 = Minimal interest 1 = No interest, I would not use this option
1 = No interest, I would not use this option 3 = Moderate interest 3 = Moderate interest 2 = Minimal interest 1 = No interest, I would not use this option 1 = No interest, I would not use this option 2 = Minimal interest
1 = No interest, I would not use this option pink . 0 68 20 26 Pompano Beach, FL Pompano Beach 13 0.3333333333 0.5 10 0.5882352941 8 15 12 21 7 0.005636225 0.010403584 0.1694557372 0.5292801653 -0.125442114 -0.111179704 -0.2342894 -0.444007575 -0.373916132
0.1694557372 0.0291380168 -0.228729698 -0.211206838 17 3.0909090909 160 3.7209302326 44 1.2222222222 44 1.2222222222 627 78.375 81 4.05 1 1 1
20     [not completed] Yes - I have read and understand this information. I consent and agree to participate in this research study. 1990-01-02 32608 Female More than one race No Married 0 Post-graduate or advanced professional degree $5,000 to $9,999
$30,000 to $39,999 No No No No No 120 120 120 35 22 years old 22 years old 18 2 Unchecked Unchecked Unchecked Unchecked Checked Unchecked No Yes No Yes Yes Yes Yes Yes Yes No No Yes No Yes No No No Yes No Yes Yes No Yes No No Yes Yes No $540 today
$750 in 61 days? $250 in 53 days? $850 in 7 days? $250 in 19 days $470 today $350 in 13 days? $600 in 14 days? $780 today $550 in 62 days? $300 in 7 days? $670 today $340 today $500 in 21 days? $690 today $490 today $800 today 4 4 4 4 4 4 4 4 4 3 3 2 2 2 2
1 1 0 1000 400 150 4 = more than once a day 1 = once a week or less 0 = 0 times 0 = 0 times 2 = 2-4 times a week 1 = once a week or less 2 = 2-4 times a week 2 = 2-4 times a week 3 = about once a day 0 = 0 times 0 = 0 times 3 = about once a day
3 = about once a day 3 = about once a day 1 = once a week or less 1 = once a week or less 2 = 2-4 times a week 2 = 2-4 times a week 1 = once a week or less 3 = about once a day 1 = once a week or less 3 = about once a day 1 = once a week or less
2 = 2-4 times a week 0 = 0 times 0 = 0 times 1 = once a week or less 0 = 0 times 0 = 0 times 2 = 2-4 times a week 2 = 2-4 times a week 2 = 2-4 times a week 0 = 0 times 0 = 0 times 4 = more than once a day 3 = about once a day 2 = 2-4 times a week
1 = once a week or less 1 = once a week or less 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 1 = once a week or less 1 = once a week or less 1 = once a week or less 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times
2 = 2-4 times a week 1 = once a week or less 1 = once a week or less 0 = 0 times 0 = 0 times 1 = once a week or less 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 1 = once a week or less 0 = 0 times
1 = once a week or less 0 = 0 times 0 = 0 times 1 = once a week or less 4: Often 4: Often 3: Sometimes 5: Always 4: Often 4: Often 5: Always 5: Always 3: Sometimes 4: Often 3: Sometimes 3: Sometimes 5: Always 5: Always 5: Always 5: Always 5: Always
2: Rarely 4: Often 4: Often 91 50 40 100 54 62 32 18 ___ ╠═ 20  ═╣ 31 Spouse or partner 5: A great deal 5: A great deal 5: A great deal 5: A great deal 5: A great deal 5: A great deal 2: A little 2: A little 4: Quite a bit Yes 27 Friend
4: Quite a bit 3: Moderately 4: Quite a bit 3: Moderately 5: A great deal 4: Quite a bit 4: Quite a bit 2: A little 3: Moderately Yes 27 Friend 4: Quite a bit 4: Quite a bit 4: Quite a bit 4: Quite a bit 5: A great deal 4: Quite a bit 4: Quite a bit
2: A little 3: Moderately Yes 48 Other family member or relative 4: Quite a bit 4: Quite a bit 3: Moderately 3: Moderately 4: Quite a bit 4: Quite a bit 2: A little 2: A little 2: A little Yes No . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Yes 0 0 0 3 or more 3 or more moderately 2 = Minimal interest 3 = Moderate interest 1 = No interest, I would not use this option 4 = High interest
3 = Moderate interest 2 = Minimal interest 2 = Minimal interest 1 = No interest, I would not use this option 2 = Minimal interest 1 = No interest, I would not use this option Cheddar . 0 89 44 29 Gainesville, FL Gainesville 13 0.4 0.2142857143 9
0.5294117647 4 20 15 20 10 0.005347989 0.009625762 -0.702432703 1.5818909567 0.4485365635 -0.176486588 0.3860355596 -0.493907595 -0.464080612 -0.702432703 -0.439459645 0.0410444851 0.0485012308 21 3.8181818182 147 3.4186046512 15 0.4166666667 55
1.5277777778 447 55.875 82 4.1 0 1 1
21     [not completed] Yes - I have read and understand this information. I consent and agree to participate in this research study. 1996-09-04 33928 Female White Yes Single/Never married 0 4-year college degree $20,000 to $29,999 $40,000 to $49,999 Yes No
Don't know No No 20 20 10 16 19 years old 18 years old 3 3 Unchecked Unchecked Unchecked Unchecked Checked Unchecked No Yes Yes No Yes Yes Yes Yes No No Yes No No No No No No No No No Yes No No No No No No No $540 today $750 in 61 days? $250 in 53 days?
$850 in 7 days? $250 in 19 days $470 today $350 in 13 days? $600 in 14 days? $780 today $400 today $300 in 7 days? $670 today $340 today $500 in 21 days? $690 today $490 today $800 today 5 4 4 4 3 3 2 2 1 1 0 0 0 0 0 0 0 0 60 12 100
4 = more than once a day 4 = more than once a day 2 = 2-4 times a week 0 = 0 times 0 = 0 times 1 = once a week or less 3 = about once a day 0 = 0 times 3 = about once a day 0 = 0 times 1 = once a week or less 2 = 2-4 times a week 2 = 2-4 times a week
2 = 2-4 times a week 0 = 0 times 1 = once a week or less 3 = about once a day 4 = more than once a day 2 = 2-4 times a week 4 = more than once a day 0 = 0 times 1 = once a week or less 1 = once a week or less 0 = 0 times 1 = once a week or less
3 = about once a day 4 = more than once a day 0 = 0 times 0 = 0 times 0 = 0 times 3 = about once a day 3 = about once a day 0 = 0 times 0 = 0 times 0 = 0 times 3 = about once a day 2 = 2-4 times a week 0 = 0 times 1 = once a week or less 0 = 0 times
0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 1 = once a week or less 0 = 0 times 1 = once a week or less 0 = 0 times 0 = 0 times 1 = once a week or less 0 = 0 times 1 = once a week or less 0 = 0 times 1 = once a week or less 0 = 0 times
1 = once a week or less 0 = 0 times 0 = 0 times 1 = once a week or less 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 1 = once a week or less 1 = once a week or less 0 = 0 times 0 = 0 times 0 = 0 times
1 = once a week or less 5: Always 5: Always 5: Always 5: Always 3: Sometimes 5: Always 5: Always 5: Always 4: Often 5: Always 3: Sometimes 3: Sometimes 3: Sometimes 5: Always 5: Always 5: Always 5: Always 1: Never 5: Always 5: Always 91 100 96 97 99 94 100
99 ___ ╠═ 10  ═╣ 26 Friend 5: A great deal 5: A great deal 5: A great deal 5: A great deal 5: A great deal 5: A great deal 5: A great deal 5: A great deal 5: A great deal Yes 21 Friend 5: A great deal 5: A great deal 5: A great deal 5: A great deal
5: A great deal 5: A great deal 5: A great deal 5: A great deal 5: A great deal Yes 22 Friend 5: A great deal 5: A great deal 5: A great deal 5: A great deal 5: A great deal 5: A great deal 5: A great deal 5: A great deal 5: A great deal No 25 . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . No . . . . . I did not lose anyone 2 = Minimal interest 2 = Minimal interest
2 = Minimal interest 4 = High interest 3 = Moderate interest 2 = Minimal interest 2 = Minimal interest 2 = Minimal interest 2 = Minimal interest 2 = Minimal interest Ford . 0 92 47 22 Estero, FL Estero 6 0.2 0.1857142857 8 0.4705882353 5 6 5 6 3
0.020460416 0.031905872 -0.484460593 -1.365419259 -1.464725696 -1.090782966 -1.061389346 2.1223874308 2.1186112309 -0.484460593 -0.78762178 -0.373627644 -0.374571694 23 4.1818181818 145 4.53125 13 0.3611111111 57 1.5833333333 776 97 87 4.35 1 0 1
8                                                                                                                        The SAS System                                                                                           10:55 Thursday, March 21, 2019

25     6/1/2018 11:35 Yes - I have read and understand this information. I consent and agree to participate in this research study. 1993-01-06 32605 Female American Indian/Alaska Native Yes Living with a partner or boyfriend/girlfriend 0
4-year college degree $50,000 to $59,999 $70,000 to $79,999 No No No No No 20 20 20 10 16 years old 18 years old 4 6 Unchecked Unchecked Unchecked Unchecked Checked Unchecked No No No No Yes Yes Yes Yes No Yes No No Yes No No No No No No No Yes No No No No
No No No $540 today $750 in 61 days? $250 in 53 days? $850 in 7 days? $250 in 19 days $470 today $350 in 13 days? $600 in 14 days? $780 today $550 in 62 days? $300 in 7 days? $670 today $340 today $500 in 21 days? $690 today $490 today $800 today 7 7 7 7 6
5 4 3 3 2 2 1 1 1 0 0 0 0 500 50 200 4 = more than once a day 0 = 0 times 0 = 0 times 2 = 2-4 times a week 4 = more than once a day 4 = more than once a day 4 = more than once a day 4 = more than once a day 4 = more than once a day 0 = 0 times
2 = 2-4 times a week 4 = more than once a day 4 = more than once a day 4 = more than once a day 1 = once a week or less 2 = 2-4 times a week 3 = about once a day 3 = about once a day 0 = 0 times 4 = more than once a day 1 = once a week or less
3 = about once a day 1 = once a week or less 2 = 2-4 times a week 2 = 2-4 times a week 0 = 0 times 1 = once a week or less 1 = once a week or less 0 = 0 times 0 = 0 times 3 = about once a day 4 = more than once a day 0 = 0 times 0 = 0 times
4 = more than once a day 4 = more than once a day 1 = once a week or less 0 = 0 times 1 = once a week or less 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 1 = once a week or less 0 = 0 times 1 = once a week or less 0 = 0 times
1 = once a week or less 1 = once a week or less 0 = 0 times 0 = 0 times 0 = 0 times 1 = once a week or less 0 = 0 times 1 = once a week or less 0 = 0 times 0 = 0 times 1 = once a week or less 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times
0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 1 = once a week or less 3: Sometimes 3: Sometimes 2: Rarely 1: Never 1: Never 1: Never 2: Rarely 3: Sometimes 2: Rarely 3: Sometimes 2: Rarely 2: Rarely 3: Sometimes
3: Sometimes 2: Rarely 5: Always 5: Always 2: Rarely 5: Always 5: Always 100 100 23 19 100 82 20 17 ___ ╠═ 00  ═╣No thought of changing my drinking. 22 Spouse or partner 5: A great deal 5: A great deal 5: A great deal 5: A great deal
5: A great deal 5: A great deal 1: Not at all 2: A little 1: Not at all Yes 23 Friend 4: Quite a bit 3: Moderately 3: Moderately 4: Quite a bit 3: Moderately 3: Moderately 4: Quite a bit 1: Not at all 1: Not at all Yes 25 Friend 4: Quite a bit
4: Quite a bit 3: Moderately 4: Quite a bit 3: Moderately 3: Moderately 4: Quite a bit 1: Not at all 1: Not at all Yes 27 Other family member or relative 4: Quite a bit 4: Quite a bit 4: Quite a bit 3: Moderately 3: Moderately 3: Moderately 3: Moderately
1: Not at all 1: Not at all Yes No . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . No . . . . . I did not lose anyone
1 = No interest, I would not use this option 2 = Minimal interest 1 = No interest, I would not use this option 2 = Minimal interest 2 = Minimal interest 2 = Minimal interest 2 = Minimal interest 1 = No interest, I would not use this option
2 = Minimal interest 1 = No interest, I would not use this option Fries . 2 101 57 26 Gainesville, FL Gainesville 7 0.1 0.1123595506 9 0.5294117647 7 10 9 12 6 0.009220512 0.01717836 -0.048516373 -0.523330626 -0.699420792 -0.698941661 -0.441064387
0.1765117005 0.411410274 -0.048516373 -0.373729017 -0.415728785 -0.357004141 16 2.9090909091 128 2.976744186 10 0.2777777778 79 2.1944444444 461 57.625 55 2.75 0 0 1
26     6/1/2018 14:47 Yes - I have read and understand this information. I consent and agree to participate in this research study. 1991-10-20 32210 Female White No Single/Never married 0 4-year college degree $40,000 to $49,999 $40,000 to $49,999 No No No
No No 1000 100 30 10 19 years old 19 years old 15 5 Unchecked Unchecked Unchecked Checked Unchecked Unchecked No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No $540 today $750 in 61 days?
$250 in 53 days? $850 in 7 days? $250 in 19 days $470 today $350 in 13 days? $600 in 14 days? $780 today $400 today $300 in 7 days? $670 today $340 today $500 in 21 days? $850 in 91 days? $600 in 89 days? $800 today 10 10 10 10 10 10 9 8 5 4 4 3 3 2 2 2 2
1 200 50 0 4 = more than once a day 1 = once a week or less 0 = 0 times 0 = 0 times 1 = once a week or less 1 = once a week or less 0 = 0 times 4 = more than once a day 2 = 2-4 times a week 0 = 0 times 2 = 2-4 times a week 3 = about once a day
3 = about once a day 3 = about once a day 0 = 0 times 0 = 0 times 4 = more than once a day 3 = about once a day 1 = once a week or less 4 = more than once a day 1 = once a week or less 0 = 0 times 0 = 0 times 3 = about once a day 3 = about once a day
0 = 0 times 3 = about once a day 2 = 2-4 times a week 0 = 0 times 0 = 0 times 0 = 0 times 3 = about once a day 0 = 0 times 0 = 0 times 4 = more than once a day 3 = about once a day 2 = 2-4 times a week 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times
0 = 0 times 0 = 0 times 2 = 2-4 times a week 1 = once a week or less 0 = 0 times 2 = 2-4 times a week 1 = once a week or less 1 = once a week or less 0 = 0 times 0 = 0 times 0 = 0 times 1 = once a week or less 2 = 2-4 times a week 0 = 0 times
2 = 2-4 times a week 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 2 = 2-4 times a week 0 = 0 times 1 = once a week or less 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 0 = 0 times 2 = 2-4 times a week 1 = once a week or less
3: Sometimes 3: Sometimes 2: Rarely 1: Never 1: Never 2: Rarely 2: Rarely 2: Rarely 1: Never 2: Rarely 1: Never 2: Rarely 3: Sometimes 1: Never 2: Rarely 4: Often 5: Always 3: Sometimes 3: Sometimes 4: Often 68 86 93 77 33 28 22 30 ___ ╠═ 70  ═╣ 28
Spouse or partner 5: A great deal 4: Quite a bit 5: A great deal 5: A great deal 5: A great deal 5: A great deal 4: Quite a bit 4: Quite a bit 4: Quite a bit Yes 25 Friend 5: A great deal 4: Quite a bit 4: Quite a bit 4: Quite a bit 5: A great deal
4: Quite a bit 4: Quite a bit 2: A little 3: Moderately Yes 27 Friend 4: Quite a bit 5: A great deal 5: A great deal 5: A great deal 5: A great deal 4: Quite a bit 4: Quite a bit 2: A little 2: A little Yes 26 Friend 2: A little 1: Not at all 2: A little
3: Moderately 1: Not at all 2: A little 5: A great deal 2: A little 2: A little Yes No . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Yes 2 0 0 1 0
quite a bit 1 = No interest, I would not use this option 1 = No interest, I would not use this option 2 = Minimal interest 2 = Minimal interest 2 = Minimal interest 1 = No interest, I would not use this option 1 = No interest, I would not use this option
1 = No interest, I would not use this option 1 = No interest, I would not use this option 1 = No interest, I would not use this option Pizza . 2 102 59 27 Jacksonville, FL Jacksonville 22 0.25 0.2564102564 10 0.5882352941 10 . 20 30 15 0.003838858
0.007344942 0.6053999573 . 1.405167693 0.4765822539 1.4199104924 -0.755171516 -0.728471372 0.6053999573 0.5409911056 0.6366222309 0.6432972668 13 2.3636363636 148 3.4418604651 20 0.5555555556 58 1.6111111111 437 54.625 47 2.35 1 0 1
;;;;
1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

Please use smaller examples. That is way too much code to read or parse.

 

You can examine the formatted value of a variable using the put function.

The basic would be something like:

 

if put(variable, fmtname.) = 'Somevalue' then do <whatever>.

 

If you are hoping to dump a bunch of variables into the process such as in an array you still have to make sure the variables are of the same type as arrays only handle a single variable AND all of the variables have a format with those values as current formatted values then you may be looking for the VVALUE function which returns the formatted value of a variable given by name OR array reference.

 

array dummy <variable list>;

do i= 1 to dim(dummy);

    if value(dummy[i]) = "I choose not to answer"  then dummy[i]= .P;

    if value(dummy[i]) = "Don't know."                    then dummy[i]= .D;

end;

 

 

 

 

View solution in original post

3 REPLIES 3
ballardw
Super User

Please use smaller examples. That is way too much code to read or parse.

 

You can examine the formatted value of a variable using the put function.

The basic would be something like:

 

if put(variable, fmtname.) = 'Somevalue' then do <whatever>.

 

If you are hoping to dump a bunch of variables into the process such as in an array you still have to make sure the variables are of the same type as arrays only handle a single variable AND all of the variables have a format with those values as current formatted values then you may be looking for the VVALUE function which returns the formatted value of a variable given by name OR array reference.

 

array dummy <variable list>;

do i= 1 to dim(dummy);

    if value(dummy[i]) = "I choose not to answer"  then dummy[i]= .P;

    if value(dummy[i]) = "Don't know."                    then dummy[i]= .D;

end;

 

 

 

 

joebacon
Pyrite | Level 9
You are absolutely right. I should've truncated the data to only the variables to read. I apologize.

Thank you for the succinct answer! This saves me quite a bit of time-- I appreciate it.

@andreas_lds thank you as well!
andreas_lds
Jade | Level 19

Sorry, but this was way to much code to be read right now (10pm). But from the small step you posted and assuming that the format is already attached to the variable:

data rds.redcap_character_clean;
  set rds.redcap_character_clean;
  array Nums[*] _numeric_ ;

  do i=1 to dim(Nums);
    if vvalue(Nums[i]) = 'EXPECTED_TEXT' then q[i] = .P;
  end;
run;

 

 

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 450 views
  • 0 likes
  • 3 in conversation