As asked this is my entire code, this contains everything I am working on. I am stuck at a few places in this code. This forum i am trying to target the race/ethnicity and trying to combine it into the two groups of NHW and other which is at the bottom. Thank you /* Generated Code (IMPORT) */ /* Source File: vaccine_hesitancy_data.csv */ /* Source Path: /home/u57317860/Capstone data */ /* Code generated on: 9/24/21, 4:45 AM */ %web_drop_table(WORK.vaccine_hesitancy_data); FILENAME REFFILE '/home/u57317860/Capstone data/vaccine_hesitancy_data.csv'; PROC IMPORT DATAFILE=REFFILE DBMS=CSV OUT=WORK.vaccine_hesitancy_data; GETNAMES=YES; RUN; PROC CONTENTS DATA=WORK.vaccine_hesitancy_data; RUN; %web_open_table(WORK.vaccine_hesitancy_data); DATA WORK.vaccine_hesitancy_data; SET WORK.vaccine_hesitancy_data; IF VACCINEUPTAKE= 0 AND VACCINEINTEND IN (2,3,4,5,9) THEN VACCINEHESITANT=1; ELSE VACCINEHESITANT= 0; IF SEX IN ("Unknow", "") THEN DELETE; RUN; PROC FREQ data=WORK.vaccine_hesitancy_data; TABLES (VACCINEUPTAKE VACCINEINTEND SEX) * VACCINEHESITANT/ MISSING CHISQ; RUN; PROC TTEST data=WORK.vaccine_hesitancy_data; VAR AGE; CLASS VACCINEHESITANT; RUN; PROC FREQ data=WORK.vaccine_hesitancy_data; TABLES (SEX AGE POP EDUCATION IMPACTPHYSICAL IMPACTMENTAL IMPACTFAMILY IMPACTEMPLOYMENT) * VACCINEHESITANT/ MISSING CHISQ; RUN; *********ATTEMPTING TO RUN EDUCATION VARIABLE*******************; PROC FREQ data=WORK.vaccine_hesitancy_data; TABLES (EDUCATION) * VACCINEHESITANT/ MISSING CHISQ; RUN; *********ATTEMPTING TO CREATE AGE VARIABLES AND RUN T TEST *****; DATA WORK.vaccine_hesitancy_data; SET WORK.vaccine_hesitancy_data; if AGE < 30 then AGE_NEW = "18-30"; else if AGE = >30 then AGE_NEW = "30-65"; DATA WORK.vaccine_hesitancy_data; SET WORK.vaccine_hesitancy_data; IF AGE > 65 THEN AGE NEW= "65+"; ELSE IF AGE = < 65+ THEN AGE NEW = "UNDER65+"; PROC FREQ data=WORK.vaccine_hesitancy_data; TABLES (AGE) * VACCINEHESITANT/ MISSING CHISQ; PROC TTEST data=WORK.vaccine_hesitancy_data; VAR AGE; CLASS VACCINEHESITANT; RUN; ************* Trying to turn race/ethnicity into two variables nhw and other****; PROC FORMAT; VALUE POP_FMT 1= 'NHW' 2,3,4,5,6,7,= 'Other'; RUN; PROC FREQ data=vaccine_hesitancy_data; TABLES (POP) * VACCINEHESITANT/ MISSING CHISQ; format POP POP_FMT.; RUN; ****************** HAS ANYONE THAT LIVES WITH YOU TESTED POSITIVE this code deletes the unknown delete the if then if we decide not to do this *****; DATA WORK.vaccine_hesitancy_data; SET WORK.vaccine_hesitancy_data; IF livetestpos = '.' then delete; RUN; PROC FREQ data=WORK.vaccine_hesitancy_data; TABLES (livetestpos) * VACCINEHESITANT/ MISSING CHISQ; run;
... View more