This question will ask you to provide a segment of missing code.
Given the SAS data set WORK EXAM:
TotalScore -
----------------
512
657
*
782
The following SAS program is submitted:
The following output is desired:
TotalScore -
--------------
512
657
782
Which WHERE expression completes the program and generates the desired output?
To obtain the desired output, the correct expression to use in the SQL query is 'Where TotalScore is not missing'. This expression will filter out any rows where the TotalScore value is missing, including the row with the asterisk ('*'). The other options do not pertain to filtering out missing data in the context provided.
A. Where TotalScore is not missing