Dear Team, See below the outcome. Code and Log entries shown but no details in the Result Column. CODE *****DATA CLASS********; DATA TEMP; INPUT RollNumber $ Class $ Age Gender $ Subject $ Sports $; DATALINES; 001 1 10 M Maths Cricket 002 1 11 M English Tennis 003 2 9 F Maths Football 004 4 7 F Science Football 005 3 7 M Maths Cricket 006 5 10 F Science Tennis 007 3 7 F Art Cricket ; proc sort data = temp out = want; by RollNumber; Where .<10 and Subject = 'Maths' and Sports = 'Football'; run; LOG 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 *****DATA CLASS********; 74 DATA TEMP; 75 INPUT RollNumber $ Class $ Age Gender $ Subject $ Sports $; 76 DATALINES; NOTE: The data set WORK.TEMP has 7 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 84 ; 85 86 proc sort data = temp out = want; 87 by RollNumber; 88 Where .<10 and Subject = 'Maths' and Sports = 'Football'; 89 run; NOTE: There were 1 observations read from the data set WORK.TEMP. WHERE (Age>. and Age<10) and (Subject='Maths') and (Sports='Football'); NOTE: The data set WORK.WANT has 1 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 90 91 92 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 104
... View more