Thank you! I did what you recommended and it worked. I am having trouble on the last step, which is subsetting the male data file to include participants that are classified as having "normal weight" according to their BMI (18.5–24.9kg/(m*m)). Attached is my whole log. When I run it, there is 0 observations. OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 68 69 PROC IMPORT 70 DATAFILE='/home/u59343073/Data File PH 629 II/yrbs2017.sav' 71 DBMS=SAV OUT = yrbss REPLACE; 72 run; NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I. NOTE: The import data set has 14765 observations and 240 variables. NOTE: WORK.YRBSS data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.13 seconds user cpu time 0.10 seconds system cpu time 0.04 seconds memory 3264.21k OS Memory 30100.00k Timestamp 02/06/2022 10:02:27 PM Step Count 229 Switch Count 4 Page Faults 0 Page Reclaims 549 Page Swaps 0 Voluntary Context Switches 31 Involuntary Context Switches 1 Block Input Operations 256 Block Output Operations 56056 73 74 data yrbss_2; 75 set yrbss; 76 if Q88 IN (1,2,3,4) then SHORTSLEEP = 0; 77 else if Q88 IN (5,6,7) then SHORTSLEEP = 1; 78 if Q88 not EQ .; 79 if Q3 IN (2,3,4); 80 run; NOTE: There were 14765 observations read from the data set WORK.YRBSS. NOTE: The data set WORK.YRBSS_2 has 8691 observations and 241 variables. NOTE: DATA statement used (Total process time): real time 0.05 seconds user cpu time 0.01 seconds system cpu time 0.04 seconds memory 4213.18k OS Memory 31912.00k Timestamp 02/06/2022 10:02:27 PM Step Count 230 Switch Count 5 Page Faults 0 Page Reclaims 579 Page Swaps 0 Voluntary Context Switches 20 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 33544 81 82 proc freq data = yrbss; 83 tables Q2 Q3 raceeth; 84 run; NOTE: There were 14765 observations read from the data set WORK.YRBSS. NOTE: PROCEDURE FREQ used (Total process time): real time 0.05 seconds user cpu time 0.05 seconds system cpu time 0.00 seconds memory 3136.62k OS Memory 30120.00k Timestamp 02/06/2022 10:02:27 PM Step Count 231 Switch Count 3 Page Faults 0 Page Reclaims 333 Page Swaps 0 Voluntary Context Switches 14 Involuntary Context Switches 1 Block Input Operations 0 Block Output Operations 272 85 86 proc freq data = yrbss_2 (WHERE=(SHORTSLEEP=0)); 87 tables Q2 Q3 RACEETH; 88 run; NOTE: There were 6802 observations read from the data set WORK.YRBSS_2. WHERE SHORTSLEEP=0; NOTE: PROCEDURE FREQ used (Total process time): real time 0.04 seconds user cpu time 0.04 seconds system cpu time 0.01 seconds memory 2309.28k OS Memory 30120.00k Timestamp 02/06/2022 10:02:27 PM Step Count 232 Switch Count 27 Page Faults 0 Page Reclaims 313 Page Swaps 0 Voluntary Context Switches 75 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 280 89 90 proc freq data = yrbss_2; 91 tables Q2*SHORTSLEEP/CHISQ; 92 run; NOTE: There were 8691 observations read from the data set WORK.YRBSS_2. NOTE: PROCEDURE FREQ used (Total process time): real time 0.04 seconds user cpu time 0.04 seconds system cpu time 0.01 seconds memory 2774.65k OS Memory 30380.00k Timestamp 02/06/2022 10:02:27 PM Step Count 233 Switch Count 6 Page Faults 0 Page Reclaims 380 Page Swaps 0 Voluntary Context Switches 27 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 544 93 94 data yrbss_female; 95 set yrbss; 96 if Q2 = 1; 97 run; NOTE: There were 14765 observations read from the data set WORK.YRBSS. NOTE: The data set WORK.YRBSS_FEMALE has 7526 observations and 240 variables. NOTE: DATA statement used (Total process time): real time 0.04 seconds user cpu time 0.02 seconds system cpu time 0.03 seconds memory 4118.65k OS Memory 32168.00k Timestamp 02/06/2022 10:02:27 PM Step Count 234 Switch Count 6 Page Faults 0 Page Reclaims 535 Page Swaps 0 Voluntary Context Switches 28 Involuntary Context Switches 1 Block Input Operations 0 Block Output Operations 28424 98 99 data yrbss_male; 100 set yrbss; 101 if Q2 = 2; 102 run; NOTE: There were 14765 observations read from the data set WORK.YRBSS. NOTE: The data set WORK.YRBSS_MALE has 7112 observations and 240 variables. NOTE: DATA statement used (Total process time): real time 0.04 seconds user cpu time 0.02 seconds system cpu time 0.02 seconds memory 4116.87k OS Memory 32168.00k Timestamp 02/06/2022 10:02:27 PM Step Count 235 Switch Count 6 Page Faults 0 Page Reclaims 531 Page Swaps 0 Voluntary Context Switches 27 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 26888 103 104 DATA YRBSSMALE; 105 SET yrbss_male; 106 BMI=Q7/Q6*Q6; 107 RUN; NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 732 at 106:7 NOTE: There were 7112 observations read from the data set WORK.YRBSS_MALE. NOTE: The data set WORK.YRBSSMALE has 7112 observations and 241 variables. NOTE: DATA statement used (Total process time): real time 0.04 seconds user cpu time 0.01 seconds system cpu time 0.03 seconds memory 4110.21k OS Memory 32168.00k Timestamp 02/06/2022 10:02:27 PM Step Count 236 Switch Count 4 Page Faults 0 Page Reclaims 532 Page Swaps 0 Voluntary Context Switches 19 Involuntary Context Switches 2 Block Input Operations 0 Block Output Operations 27400 108 109 PROC MEANS DATA=YRBSSMALE; 110 VAR BMI; 111 RUN; NOTE: There were 7112 observations read from the data set WORK.YRBSSMALE. NOTE: PROCEDURE MEANS used (Total process time): real time 0.02 seconds user cpu time 0.01 seconds system cpu time 0.01 seconds memory 8245.03k OS Memory 36296.00k Timestamp 02/06/2022 10:02:27 PM Step Count 237 Switch Count 3 Page Faults 0 Page Reclaims 1800 Page Swaps 0 Voluntary Context Switches 26 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 8 112 113 114 DATA YRBSS_WTMALE; 115 SET YRBSSMALE; 116 if BMI<18.5 THEN DELETE; 117 else if BMI>24.9 THEN DELETE; 118 RUN; NOTE: There were 7112 observations read from the data set WORK.YRBSSMALE. NOTE: The data set WORK.YRBSS_WTMALE has 0 observations and 241 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds user cpu time 0.01 seconds system cpu time 0.01 seconds memory 3014.03k OS Memory 30376.00k Timestamp 02/06/2022 10:02:27 PM Step Count 238 Switch Count 4 Page Faults 0 Page Reclaims 307 Page Swaps 0 Voluntary Context Switches 21 Involuntary Context Switches 1 Block Input Operations 0 Block Output Operations 264
... View more