A00-231

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

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 only B. Innis and Ellis only C. Innis, Ellis, and Liu...

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

Which is a valid LIBNAME statement?A . libname "_SAS_data_library_location_"; B. sasdata libname "_SAS_data_library_location_"; C. libname sasdata "_SAS_data_library_location_"; D. libname sasdata sas "_SAS_data_library_location_";View AnswerAnswer: C

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

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