A00-231

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 23 B. 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 log B. to the SAS data set _NULL_ C. to the SAS output window or to an output file D. to the raw data file that was...

The Excel workbook REGIONS.XLS contains the following four worksheets: EAST WEST NORTH SOUTH The following program is submitted: libname MYXLS 'regions.xls'; Which PROC PRINT step correctly displays the NORTH worksheet?A . proc print data=MYXLS.NORTH;run; B. proc print data=MYXLS.NORTH$;run; C. proc print data=MYXLS.'NORTH'e;run; D. proc print data=MYXLS.'NORTH$'n;run;View AnswerAnswer: D

The following SAS program is submitted: data work.test; set work.staff (keep = jansales febsales marsales); array diff_sales{3} difsales1 - difsales3; array monthly{3} jansales febsales marsales; run; What new variables are created?A . JANSALES, FEBSALES and MARSALES B. MONTHLY1, MONTHLY2 and MONTHLY3 C. DIFSALES1, DIFSALES2 and DIFSALES3 D. DIFF_SALES1, DIFF_SALES2 and...

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

The following SAS program is submitted: data test; set sasuser.employees; if 2 le years_service le 10 then amount = 1000; else amount = 0; amount_per_year = years_service / amount run; What is the value of the variable AMOUNT_PER_YEAR if an employee has been with the company for one year?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;...

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 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.empsalary; set work.people (in = inemp) work.money (in = insal); if insal and inemp; run; The SAS data set WORKPEOPLE has 5 observations, and the data set WORKMONEY has 7 observations. How many observations will the data set WORK.EMPSALARY contain?A . 0 B....