A00-212 Exam Questions

The following SAS program is submitted: The purpose of FILEVAR = option on the INFILE statement is to name the variable next, whose value:

Given the SAS data sets: The SAS program is submitted: What output will be produced?

Given the data set shown on the left, the SAS program on the right is submitted: Which statement is true regarding the WORK.MISSING data set?

Given the following partial SAS log: Which SQL procedure statement generated this output?

Given the data set SASHELP.CLASS: The following SAS program is submitted: The PROC steps execute successfully?

Given the SAS data set WORK.ONE: The following SAS program is submitted; Which result set would be generated?

The SAS data set WORK.CHECK has a variable named Id_Code in it. Which SQL statement would create an index on this variable?

A data set stored on a network drive has the following characteristics: 14 Million observations 400 numeric variables 0 character variables of length 20 Binary compression A DATA S...

Which MACRO option is responsible for this partial SAS log?

The following SAS program is submitted: What is the value of the macro variable Newval when the %PUT statement executes?

The following SAS program is submitted: How will the variable be listed?

Given the SAS data set WORK TRANSACT: The following output is desired: Which SQL statement was used?

Given the unsorted data set WORK.ORDERS The following three programs are submitted: Which program will create a list of unique Customer_ID values in the WORK.ORDERS data set?

The following SAS program is submitted: What is written to the SAS log?

This question will ask you to provide missing option. Which option is required to complete the program correctly?

Given the two output sets shown on the left, which program produced the output shown on the right?

The question will ask you to provide a segment of missing code. Given the following SAS program: Which segment of code completes the program to use finance.new SAS view?

Given the following scenario: The SAS libraries LIBRARY and MYLIB are successfully defined in your current SAS session. There is a SAS Data Set named WORK.GENDERS with a column cal...

Given the data sets: The following SAS program is submitted: Which result set would be generated?

The SAS data set WORK.TEMP is indexed on variable Id: The following SAS program is submitted:

This question will ask you to provide a segment of missing code. Given the following program and data: What is the WHERE statement that successfully completes the PROC PRINT and se...

Given the SAS data sets: A SAS program is submitted and the following is written to SAS to: What would allow the program to successfully execute without errors?

Given the SAS data sets: The following SAS DATA step is submitted: What data values are stored in data set WORK.COMBINE?

Given the SAS data sets shown on the left, the SAS program on the right is submitted. What will be the result when this program is executed?

Which SAS System option(s) can aid in benchmarking?

Which macro statement would remove the macro variable mv_Info from the symbol table?

Which title statement would always display current date?

Given a SAS data set with the following characteristics: 200 million observations 300 variables Compressed Resides on a network location A SAS DATA Step program is written that wil...

Given the following SAS program: What will be the output from the PRINT Procedure?

Which PUT statements will be the log if the program is submitted at the beginning of a new SAS session?

Which SAS produce can be used to report Page Size?

The SAS set WORK CHECK has an index on the variable Code and the following SAS program is submitted. proc sort data=WORK.CHECK; by Code; run; What describes the result of submittin...

Given the SAS data sets: The following SAS program is submitted: What output is produced?

This question will ask you to provide a segment of missing code. Given the SAS data set WORK EXAM: TotalScore ---------------- * The following SAS program is submitted: The followi...

Given the SAS data sets: The following SAS program is submitted: What data values are stored in data set WORK.COMBINE?

Which option forces the use of a specific index from a data set?

The following SAS program is submitted: options mprint; %macro test(parm); proc &parm data = sashelp.prdsale; run; %mend; %test(print) What is the result of the MPRINT options?

The following SAS program is submitted: The report will not successfully run and will produce an error message in the log. What causes the error message in the log?

Given the data set shown in the left, the SAS program on the right is submitted. Which program will result in the identical report?