Hi! The data is from 1 file. Here is my whole log if it helps. I used the libname to call in. Thank you for your advice so far! I will try it! Im very new at using Redcap and SAS so to be honest I had no idea what I was doing when I was making the survey in the first place... haha hindsight is 2020! 🙂 NOTE: Unable to open SASUSER.PROFILE. WORK.PROFILE will be opened instead. NOTE: All profile changes will be lost at the end of the session. 1 libname hpv "G:\Shared drives\Can Prevent HPV Participant\Quant Data\SAS Data\HPV Quant - 1 ! Interns"; NOTE: Libref HPV was successfully assigned as follows: Engine: V9 Physical Name: G:\Shared drives\Can Prevent HPV Participant\Quant Data\SAS Data\HPV Quant - Interns 2 OPTIONS nofmterr; 3 OPTIONS FMTSEARCH = (hpv.hpvformats); 4 5 data ParisAnalysis; *THIS IS CURRENTLY A TERMPORAY FILE. IF YOU WANT TO CREATE A PERMANENT ONE 5 ! THAT HAS NEW VARIABLES, 6 DELETED VARIABLES, DELETED CASES, THEN WRITE "data hpv.NameOfNewDataSet"; 7 set hpv.deidhpv; 8 /*** RECODE VARIABLES HERE ***/ 9 /*** DELETE VARIABLES WE DONT NEED - ESP PERSONAL IDENTIFYING ONES ***/ 10 /*** DELETER CASES WE DONT WANT - E.G., TOO YOUNG, TOO OLD ***/ 11 12 if 0<=q1<18 then delete; 13 if 30<q1<100 then delete; 14 if 0<=q1_sp<18 then delete; 15 if 30<q1_sp<100 then delete; 16 17 /* Numeric Arrays */ 18 19 Array English (i) q2___1-q2___10 q3 q4 q6 q5 q44 q7 q8 q9 q11-q17e___9 q17f___1-q17f___7 19 ! q18-q28___5 q29 q30___1-q32___12 q33___1-q33___13 q34-q35___9 q36___1-q36___9 q37 q38 q39; ERROR: Alphabetic prefixes for enumerated variables (q11-q17e___9) are different. ERROR: Alphabetic prefixes for enumerated variables (q18-q28___5) are different. ERROR: Alphabetic prefixes for enumerated variables (q30___1-q32___12) are different. ERROR: Alphabetic prefixes for enumerated variables (q34-q35___9) are different. 20 Array Spanish (i) q2_sp___1-q2_sp___10 q3_sp q4_sp q6_sp q5_sp q44_sp q7_sp q8_sp q9_sp 20 ! q11_sp-q17e_sp___9 q17f_sp___1-q17f_sp___7 q18_sp-q28_sp___5 q29_sp q30_sp___1-q32_sp___13 20 ! q33_sp___1-q33_sp___13 q34_sp-q35_sp___9 q36_sp___1-q36_sp___9 q37_sp q38_sp q39_sp; ERROR: Missing numeric suffix on a numbered variable list (q11_sp-q17e_sp___9). ERROR: Missing numeric suffix on a numbered variable list (q18_sp-q28_sp___5). ERROR: Alphabetic prefixes for enumerated variables (q30_sp___1-q32_sp___13) are different. ERROR: Missing numeric suffix on a numbered variable list (q34_sp-q35_sp___9). 21 do i= 148; 22 if languages1=2 then Spanish (i) = English (i); ERROR: Mixing of implicit and explicit array subscripting is not allowed. ERROR: Mixing of implicit and explicit array subscripting is not allowed. ERROR: Mixing of implicit and explicit array subscripting is not allowed. ERROR: Mixing of implicit and explicit array subscripting is not allowed. 23 24 end; 25 26 /* Character Arrays */ 27 28 Array EnglishC (i) q1 otherq2 otherq4 otherq6 otherq7 otherq8 q10 otherq17e otherq17f otherq28 28 ! otherq29 otherq32 otherq33 otherq35 otherq36 contact; 29 Array SpanishC (i) q1_sp otherq2_sp otherq4_sp otherq6_sp otherq7_sp otherq8_sp q10_sp 29 ! otherq17e_sp otherq17f_sp otherq28_sp otherq29_sp otherq32_sp otherq33_sp otherq35_sp 29 ! otherq36_sp contact_sp; 30 do i= 148; 31 32 if languages1=2 then Spanish (i) = English (i); ERROR: Mixing of implicit and explicit array subscripting is not allowed. ERROR: Mixing of implicit and explicit array subscripting is not allowed. ERROR: Mixing of implicit and explicit array subscripting is not allowed. ERROR: Mixing of implicit and explicit array subscripting is not allowed. 33 34 end; 35 36 37 /*race_sum = q2___1 + q2___2 + q2___3 + q2___4 + q2___5 + q2___6 + q2___7 + q2___8 + q2___9 + 37 ! q2___10; 38 39 40 if q2___1 = 1 then race_eth = 1; else 41 if q2___2 = 1 then race_eth = 2; else 42 if q2___3 = 1 then race_eth = 3; else 43 if q2___4 = 1 then race_eth = 4; else 44 if q2___5 = 1 then race_eth = 5; else 45 if q2___6 = 1 then race_eth = 6; else 46 if q2___7 = 1 then race_eth = 7; else 47 if q2___8 = 1 then race_eth = 8; else 48 if q2___9 = 1 then race_eth = 9; else 49 if q2___10 = 1 then race_eth = 10; else 50 51 if q2_sp___1 = 1 then race_eth = 1; else 52 if q2_sp___2 = 1 then race_eth = 2; else 53 if q2_sp___3 = 1 then race_eth = 3; else 54 if q2_sp___4= 1 then race_eth = 4; else 55 if q2_sp___5 = 1 then race_eth = 5; else 56 if q2_sp___6= 1 then race_eth = 6; else 57 if q2_sp___7 = 1 then race_eth = 7; else 58 if q2_sp___8 = 1 then race_eth = 8; else 59 if q2_sp___9 = 1 then race_eth = 9; else 60 if q2_sp___10= 1 then race_eth = 10;*\ 61 62 run; 63 64 /*** DO PROCEDURES HERE ***/ 65 66 NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 12:7 13:7 14:7 15:7 NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.PARISANALYSIS may be incomplete. When this step was stopped there were 0 observations and 370 variables. NOTE: DATA statement used (Total process time): real time 0.07 seconds cpu time 0.00 seconds 67 Proc contents varnum; NOTE: Writing HTML Body file: sashtml.htm 68 run; NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.54 seconds cpu time 0.45 seconds 69 70 proc freq label; ----- 22 202 ERROR 22-322: Syntax error, expecting one of the following: ;, COMPRESS, DATA, FC, FORMCHAR, NLEVELS, NOPRINT, ORDER, PAGE. ERROR 202-322: The option or parameter is not recognized and will be ignored. 71 table race_eth q1 * q1_sp/missing; 72 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE FREQ used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 73 74 proc freq ; 75 table race_sum * q2___1 * q2___2 * q2___3 * q2___4 * q2___5 * q2___6 * q2___7 * q2___8 * 75 ! q2___9 * q2___10/list missing; ERROR: Variable RACE_SUM not found. 76 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE FREQ used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 77 78 proc freq; 79 table language_selectionse_v_0 languages1 language_selectionse_v_1; 80 run; NOTE: No observations in data set WORK.PARISANALYSIS. NOTE: PROCEDURE FREQ used (Total process time): real time 0.00 seconds cpu time 0.01 seconds
... View more