A00-211

Given the raw data record in the file phone.txt: Which SAS statement completes the program and results in a value of "James Stevens" for the variableFullName?A . FullName=CATX('',EmpFName,EmpLName); B. FullName=CAT('',EmpFName,EmpLName); C. FullName=EmpFName!!EmpLName; D. FullName=EmpFName + EmpLName;View AnswerAnswer: A

Given the SAS data set SASDATA TWO: SASDATA TWO XY 52 31 56 The following SAS program is submitted: data sasuser.one two sasdata.three; set sasdata two; if x = 5 then output sasuser.one; else output sasdata two; run; What is the result?A . data set SASUSER.ONE has 5 observationsdata set...

The following output is created by the FREQUENCY procedure: Which TABLES option(s) would be used to eliminate the row and column counts and just see the frequencies and percents?A . norowcount nocolcount B. freq percent C. norow nocol D. nocountsView AnswerAnswer: C

The following code was modified to generate the results further below: proc format; value agegrp low-12 ='Pre-Teen' 13-high = 'Teen'; run; proc means data=SASHELP.CLASS; var Height; class Sex Age; format Age agegrp.; run; The following results were generated to display only specific statistics and limit the decimals with the modification:...

Given the SAS data set PEPM.STUDENTS: PERM.STUDENTS NAME AGE Alfred 14 Alice13 Barbara13 Carol14 The following SAS program is submitted: libname perm ‘SAS data library’; data students; set perm. Students; file ‘file specification’; put name $15. @5 age 2.; run; What is written to the output raw data file?A ....

The following SAS program is submitted: data work.sets; do until (prod gt 6); prod + 1; end; run; What is the value of the variable PROD in the output data set?A . 6 B. 7 C. 8 D. (missing numeric)View AnswerAnswer: B

The SAS data sets WORK.EMPLOYEE and WORK.SALARY are shown below: WORK.EMPLOYEE WORK.SALARY fname age name salary Bruce 30 Bruce 25000 Dan 40 Bruce 35000 Dan 25000 The following SAS program is submitted: data work.empdata; by fname; totsal + salary; run; Which one of the following statements completes the merge of...

The following SAS program is submitted: data work.flights; destination = ‘cph’; select(destination); when(’LHR’) city = ‘London’; when(’CPH’) city = ‘Copenhagen’; otherwise city = ‘Other’; end; run; What is the value of the CITY variable?A . Other B. Copenh C. Copenhagen D. ‘‘(missing character value)View AnswerAnswer: A

Given the SAS data set AGES: AGES AGE --------- The variable AGE contains character values. The following SAS program is submitted: data subset; set ages; where age> 12; run; How many observations are written out to the data set SUBSET?A . 0 B. 1 C. 2 D. 3View AnswerAnswer: A

The following SAS program is submitted: data WORK.ONE; Text=’Australia, US, Denmark’; Pos=find (Text,’US’,’i’,5); run; What value will SAS assign to Pos?A . 0 B. 1 C. 2 D. 12View AnswerAnswer: D