A00-231 V1

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: <insert ODS statement here> proc means data = sasuser.shoes; where product in (‘Sandal’ , ‘Slipper’ , ‘Boot’); run; <insert ODS statement here> Which ODS statements complete the program and send the report to an HTML file?A . ods html = ‘sales.html’; ods html close;B...

Given the contents of the raw data file EMPLOYEE: ----|----10----|----20----|----30 Alan 19/2/2004 ACCT Rob 22/5/2004 MKTG MaryJane 14/3/2004 EDUC The following SAS program is submitted: data emps; infile ‘employee’; input@1 name$ @15 date <insert INFORMAT here> @25 department$; run; Which INFORMAT correctly completes the program?A . date9.B . ddmmyyyy9.C ....

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 . 0B . 1C . 2D . 12View AnswerAnswer: D

Given the raw data file AMOUNT: ----I---- 10---I----20---I----30 $1,234 The following SAS program is submitted: data test; infile ‘amount’; input@1 salary 6.; if_error_then description = ‘Problems’; else description = ‘No Problems’; run; What is the result?A . The value of the DESCRIPTION variable is No Probl.B . The value of...

Given the SAS data set EMPLOYEES: EMPLOYEES NAME SALARY -------- ------------ Innis60000 Jolli50000 Ellis55000 Liu45000 The following SAS program is submitted: proc print data = employees; where name like ‘_i%’; run; What is contained in the output?A . Liu onlyB . Innis and Ellis onlyC . Innis, Ellis, and Liu...

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 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 one; addressl = ‘214 London Way’; run; data one; set one; address = tranwrd(address1, ‘Way’, ‘Drive’); run; What are the length and value of the variable ADDRESS?A . Length is 14; value is ‘214 London Dri’.B . Length is 14; value is ‘214...

Which statement correctly computes the average of four numerical values?A . average = mean(num1, num4);B . average = mean(num1 - num4);C . average = mean(ofnum1 - num4)D . average = mean(num1 num2 num3 num4);View AnswerAnswer: C