- All Exams Instant Download
What new variables are created?
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 MARSALESB . MONTHLY1, MONTHLY2 and MONTHLY3C . DIFSALES1, DIFSALES2 and DIFSALES3D . DIFF_SALES1, DIFF_SALES2 and...
What is the value of the variable DESCRIPTION?
The following SAS program is submitted: data test; set chemists; jobcode = ‘Chem2’ then description = ‘Senior Chemist’; else description = ‘Unknown’; run; The value for the variable JOBCODE is: JOBCODE ------------- chem2 What is the value of the variable DESCRIPTION?A . chem2B . UnknownC . Senior ChemistD . ‘...
Which PROC PRINT step correctly displays the NORTH worksheet?
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
Which TABLES option(s) would be used to eliminate the row and column counts and just see the frequencies and percents?
The following output is created by the FREQUENCY procedure: Which TABLES option(s) would be used to eliminate the row and column counts and just see the frequencies and percents?A . norowcount nocolcountB . freq percentC . norow nocolD . nocountsView AnswerAnswer: C
Which program displays a listing of all data sets in the SASUSER library?
Which program displays a listing of all data sets in the SASUSER library?A . proc contents lib = sasuser.all; run;B . proc contents data = sasuser.all; run;C . proc contents lib = sasuser._alI_; run;D . proc contents data = sasuser._all_; run;View AnswerAnswer: D
Which SAS statement completes the program and results in a value of ‘Printing750’ for the DEPARTMENT variable?
Given the raw data record DEPT: ----|----10---|----20---|----30 Printing 750 The following SAS program is submitted: data bonus; infile ‘dept’; inputdept$ 1-11 number 13- 15; <insert statement here> run; Which SAS statement completes the program and results in a value of ‘Printing750’ for the DEPARTMENT variable?A . department = dept II...
How many observations are written out to the data set SUBSET?
Given the SAS data set AGES: AGES AGE --------- The variable AGE contains character values. The following SAS program is submitted: data subset; set ages; where age> 12; run; How many observations are written out to the data set SUBSET?A . 0B . 1C . 2D . 3View AnswerAnswer: A
Which statement(s) completed the program and produced a non-missing value for the variable TOTQUANTITY in the final observation of the output data set?
1941 1 The following SAS program is submitted: data coins; infile ‘yearamt’; input year quantity; <insert statement(s) here> run; Which statement(s) completed the program and produced a non-missing value for the variable TOTQUANTITY in the final observation of the output data set?A . totquantity + quantity;B . totquantity = sum(totquantity...
Which footnote(s) is/are displayed in the report?
The following SAS program is submitted: footnote1 ‘Sales Report for Last Month’; footnote2 ‘Selected Products Only’; footnote3 ‘All Regions’; footnote4 ‘All Figures in Thousands of Dollars’; proc print data = sasuser.shoes; footnote2 ‘All Products’; run; Which footnote(s) is/are displayed in the report?A . All ProductsB . Sales Report for Last...
Which ODS statements inserted, respectively, in the two location above creates a report stored in an html file?
The following SAS program is submitted: <_insert_ods_code_> proc means data=SASUSER.SHOES; where Product in ('Sandal' , 'Slipper' , 'Boot'); run; <_insert_ods_code_> Which ODS statements inserted, respectively, in the two location above creates a report stored in an html file?A . ods html open='sales.html';ods html close;B . ods file='sales.html' / html;ods file...
