247 DM 'LOG;CLEAR;OUT;CLEAR'; 248 OPTIONS THREADS=YES CPUCOUNT=8; 249 options mlogic mprint mtrace symbolgen; 250 251 data data01; 252 infile 'C:\Documents and Settings\Eric A. Suess\Desktop\Stat6250\data01.txt'; 253 input ID Location M1 M2 M3 M4 M5 M6 M7 M8; 254 run; NOTE: The infile 'C:\Documents and Settings\Eric A. Suess\Desktop\Stat6250\data01.txt' is: File Name=C:\Documents and Settings\Eric A. Suess\Desktop\Stat6250\data01.txt, RECFM=V,LRECL=256 NOTE: 3000000 records were read from the infile 'C:\Documents and Settings\Eric A. Suess\Desktop\Stat6250\data01.txt'. The minimum record length was 129. The maximum record length was 157. NOTE: The data set WORK.DATA01 has 3000000 observations and 10 variables. NOTE: DATA statement used (Total process time): real time 15.51 seconds cpu time 14.10 seconds 255 /* Compute the mean and stdev of the measurement. */ 256 proc means data=data01 n mean std maxdec=2; 257 class location; 258 title 'Mean scores for each location'; 259 var M1 - M8; 260 run; NOTE: There were 3000000 observations read from the data set WORK.DATA01. NOTE: PROCEDURE MEANS used (Total process time): real time 1.57 seconds cpu time 3.20 seconds 261 proc sort data=data01; 262 by location; 263 run; NOTE: There were 3000000 observations read from the data set WORK.DATA01. NOTE: The data set WORK.DATA01 has 3000000 observations and 10 variables. NOTE: PROCEDURE SORT used (Total process time): real time 15.38 seconds cpu time 8.51 seconds 264 proc means data=data01 n mean std maxdec=2; 265 by location; 266 title 'Mean scores for each location'; 267 var M1 - M8; 268 run; NOTE: There were 3000000 observations read from the data set WORK.DATA01. NOTE: PROCEDURE MEANS used (Total process time): real time 2.51 seconds cpu time 2.42 seconds 269 270 /* Create a new data set using the "output" subcommand. */ 271 272 proc means data=data01 noprint nway; 273 class location; 274 var M1 - M8; 275 output out=locationsum 276 n = n_measurement 277 mean = m_measurement 278 std = s_measurement 279 max = max_measurement 280 min = min_measurement; 281 run; NOTE: There were 3000000 observations read from the data set WORK.DATA01. NOTE: The data set WORK.LOCATIONSUM has 3 observations and 8 variables. NOTE: PROCEDURE MEANS used (Total process time): real time 1.62 seconds cpu time 3.17 seconds 282 283 proc print data=locationsum; 284 title 'Listing of data set locationsum'; 285 run; NOTE: There were 3 observations read from the data set WORK.LOCATIONSUM. NOTE: PROCEDURE PRINT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 286 proc contents data=data01 ; 287 run; NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.01 seconds cpu time 0.01 seconds