SAS base Exam | Questions & 100% Correct Answers (Verified) | Latest Update | Grade A+

B. A note is written to the SAS log explaining the error, and the DATA step continues to execute. : error with invalid data The DATA step stops executing at the point of the error, and no SAS data set is created. : syntax error The DATA step stops executing at the point of the error, and the resulting DATA set contains observations up to that point. : If it's a problem with merging two or more datasets proc sort : By default SAS will sort data in ascending order sum statement in data step 2 | P a g e : It adds the value of an expression to an accumulator variable and ignores missing values. Which of the following is not an error identified during the compilation phase? : Quotation marks are unbalances An option is invalid Semicolons are missing in statements check for missing values : if missing(var) then do; if charvar=' ' then do; if numvar=. then do; substr(s, p, n) : SUBSTR(SOURCE, POSITION, N) SOURCE—This is the larger or reference string. It can be a variable or a string of characters. ♦ POSITION—This value is a positive integer and references the starting point to begin reading the internal group of characters. ♦ N—This value is a positive integer and references the number of characters to read from the starting point POSITION in the field SOURCE sorting numeric 3 | P a g e : if you sort your data set by a numeric variable, observations with missing values for that variable appear first in the sorted data set when you sort a data set by a character variable, observations with missing (blank) values of the BY variable always a