A00-231 exam

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 ....

Given the SAS data set WORKAWARDS: WORK.AWARDS FNAMEPOINTSMONTH ---------------------------------- Amy24 Amy17 Gerard33 Wang33 Wang112 Wang18 The following SAS program is submitted: proc sort data = work.awards; by descending fname points; run; How are the observations sorted?A . ENAME POINTS MONTH Wang33 Wang112 Wang18 Gerard33 Amy24 Amy17B . ENAME POINTS MONTH...

Given the following data step: After data step execution, what will data set WORK.GEO contain? A . Option AB . Option BC . Option CD . Option DView AnswerAnswer: A

The following SAS program is submitted: The program fails execution due to syntax errors. What is the cause of the syntax error?A . The variable MONTHSALES does not exist.B . An array cannot be referenced on a KEEP data set option.C . The KEEP= data set option should be (KEEP...

Given the SAS data set ONE: Given the SAS data set WORK.ONE: The following SAS program is submitted: Which report is produced? A . Option AB . Option BC . Option CD . Option DView AnswerAnswer: B

The following SAS program is submitted: What new variables are created?A . Difcount1, Difcount2 and Difcount3B . Diff1, Diff2 and Diff3C . Janpt, Febpt, and MarptD . Patients1, Patients2 and Patients3View AnswerAnswer: A

The SAS data set named WORK.SALARY contains 10 observations for each department, and is currently ordered by Department. The following SAS program is submitted: Which statement is true?A . The by statement in the DATA step causes a syntax error.B . The statement Payroll+(MonthlyWageRate*12); in the data step causes a...

The following SAS program is submitted: data work.retail; cost = ‘20000’; total= .10* cost run; What is the result?A . The value of the variable TOTAL in the output data set is 2000. No messages are written to the SAS log.B . The value of the variable TOTAL in the...

The following SAS program is submitted: data test; infile ‘file specification’; input name $ amount@@; run; Which of the following is true?A . Two @@ together are the same as one c.B . Two @@ hold the data records until the bottom of the DATA step.C . Two @@ hold...

The following SAS program is submitted; data combine; country = ‘Italy, Russia, ireland’; found = find(country, ‘i’); run; What is the value of the variable FOUND in the output data set?A . 1B . 12C . ItalyD . RussiaView AnswerAnswer: B