A00-231 exam

The following SAS program is submitted: How will the Exam variable value be displayed in the FREQ procedure output?A . FailB . PassC . 50.5D . .(missing numeric value)View AnswerAnswer: C

The SAS data set PETS is sorted by the variables TYPE and BREED. The following SAS program is submitted: proc print data = pets; var type breed; sum number; run; What is the result?A . The SUM statement produces only a grand total of NUMBER.B . The SUM statement produces...

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

Which ODS statement option terminates output being written to an HTML rile?A . ENDB . QUITC . STOPD . CLOSEView AnswerAnswer: D

The Excel workbook QTR1.XLS contains the following three worksheets: JAN FEB MAR Which statement correctly assigns a library reference to the Excel workbook?A . libname qtrdata 'qtr1.xls';B . libname 'qtr1.xls' sheets=3;C . libname jan feb mar 'qtr1.xls';D . libname mydata 'qtr1.xls' WORK.heets=(jan,feb,mar);View AnswerAnswer: A

The following SAS program is submitted: libname temp ‘SAS data library’; data temp.sales; merge temp.sales work.receipt; by names; run; The input data files are sorted by the NAMES variable: What is the result?A . The program executes successfully and a temporary SAS data set is created.B . The program executes...

The following SAS program is submitted: data work.total; set work.salary(keep = department wagerate); by department; if first.department then payroll = 0; payroll + wagerate; if last.department; run; The SAS data set named WORKSALARY contains 10 observations for each department, and is currently ordered by DEPARTMENT. Which statement is true?A ....

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 SAS data set WORK.ONE contains a numeric variable named Num ana character variable named Char: WORK.ONE Num Char ------ ------ 1 23 3 23 1 77 The following SAS program is submitted: proc print data=WORK.ONE; where Num='1'; run; What is output?A . Num Char--- ---- 1 23B . Num...

The following SAS program is submitted: Data_null_; set old; put sales 1 sales2; run; Where is the output written?A . to the SAS logB . to the SAS data set _NULL_C . to the SAS output window or to an output fileD . to the raw data file that was...