A00-212 Exam Questions

The following SAS ARRAY statement is submitted: array score{*} a4 - a10, a25 ; Which one of the following is the maximum number of elements stored?

When is it appropriate to create indexes on a SAS data set for efficient processing?

The following SAS program is submitted: options yearcutoff = 1950; %macro y2kopt(date); %if &date >= 14610 %then %do; options yearcutoff = 2000; %end; %else %do; options yearcutoff...

Which one of the following is the purpose of the REUSE= YES option in a compressed SAS data set?

Given the following SAS data set ONE: ONE LEVEL AGE 1 10 2 20 3 20 2 10 1 10 2 30 3 10 2 20 3 30 1 10 The following SAS program is submitted: proc sql; select level, max(age) as MA...

Which one of the following is true regarding the KEEP statement?

Which one of the following displays the definition of a stored SQL procedure view in the SAS log?

The following SAS program is submitted: data temp; array points{2,3}_temporary_; run; Which one of the following is the maximum number of elements that are stored?

Which one of the following is the purpose of the IDXNAME= data set option?

The DICTIONARY.MACROS table stores information about which of the following?

Given the following SAS data set named WORK.INTERNAT: WORK.INTERNAT LOCATION SUM USA 30 EUR 40 The following SAS program is submitted: %let LOC = Usa; proc sql; select * from inter...

The following SAS program is submitted: %let a = cat; %macro animal(a = frog); %let a = bird; %mend; %animal(a = pig) %put a is &a; Which one of the following is written to the SAS...

The following SAS program is submitted: proc sql; select * from dictionary.tables; quit; Which one of the following is reported?

The following SAS program is submitted: data two; y = '2'; run; %let x = 10; %let var = y; data one; set two (keep = &var); z = &var * &x; run; Which one of the following is the va...

Which one of the following options is available for SAS macro debugging?

The following SAS program is submitted: %let first = yourname; %let last = first; %put &&&last; Which one of the following is the result in the log of the %PUT statement?

Given the following SAS data sets ONE and TWO: ONE TWO YEAR QTR BUDGET YEAR QTR SALES 2001 3 500 2001 4 300 2001 4 400 2002 1 600 2002 1 700 The following SAS program is submitted:...

Given the following SAS program: proc sql; select product, type, sum(sales) as revenue from one group by product, type; quit; Which one of the following clauses should be added to...

The following SAS program is submitted: %macro test(var); proc print data = sasuser.class; where age > &var; run; %mend; Which type of parameter is the macro variable VAR?

The following SAS program is submitted: proc datasets lib = testdata; modify one; label num = 'Number'; format num 4.; quit; Which one of the following SQL programs produces the sa...

Which one of the following techniques concatenates data in SAS?

In which one of the following SAS programs is the SAS data set index named CHAR1 always used?

Given the following SAS data set ONE: ONE CATEGORY AGE SALARY BONUS M 28 200 20 M 25 100 10 M 28 300 10 M 33 300 30 F 18 100 50 F 25 200 10 F 35 400 50 The following SQL program is...

Which one of the following should be avoided when creating and using an SQL procedure view?

The following SAS program is submitted: filename sales ('external-file1' 'external-file2'); data new; infile sales; input date date9. company $ revenue; run; Which one of the follo...

The SAS data set ONE contains the variables X, Y, Z, and W. The following SAS program is submitted: proc transpose data = one out = trans name = new; by x; var y; run; Which one of...

Given the following SAS data set ONE: ONE JOB LEVEL SALARY ACC 2 300 SEC 1 100 SEC 2 200 MGR 3 700 ACC 1 . ACC 3 . MGR 2 400 The following SAS data set TWO is created: TWO JOB LEVE...

Given the following SAS data set ONE: ONE CATEGORY AGE SALARY BONUS M 28 200 20 M 25 100 10 M 28 300 10 M 33 300 30 F 18 100 50 F 25 200 10 F 35 400 50 The following SAS program is...

The following are values of the variable STYLE from the SAS data set SASUSER.HOUSES: SASUSERS.HOUSES OBS STYLE 1 RANCH 2 SPLIT 3 CONDO 4 TWOSTORY 5 RANCH 6 SPLIT 7 SPLIT The follow...

The following SAS program is submitted: %let value = .5; %let add = 5; %let newval = %eval(&value + &add); Which one of the following is the resulting value of the macro variable N...

Which one of the following statements about compressed SAS data sets is always true?

Given the following SAS data set ONE: ONE DIVISION SALES A 1234 A 3654 B 5678 The following SAS program is submitted: data _null_; set one; by division; if first.division then call...

The following SAS program is submitted: proc contents data = testdata.one; run; Which one of the following SQL statements produces similar information about the column attributes a...

Which one of the following SAS programs displays the descriptor portion of each data set stored in the SASUSER library?

Given the following SAS data sets ONE and TWO: ONE TWO OBS COMMON X OBS COMMON Y 1 A 10 1 A 1 2 A 13 2 A 3 3 A 14 3 B 4 4 B 9 4 B 2 5 C 8 5 C 5 6 C 14 The following SAS DATA step i...

The following SAS program is submitted: %let name = Patel's Restaurant; Which one of the following statements avoids problems associated with the unbalanced quotation mark?

Given the SAS data sets ONE and TWO: ONE TWO COMMON X COMMON Y A 10 A 1 A 13 A 3 A 14 B 4 B 9 B 2 The following SAS program is submitted: data combine; set one; set two; run; What...

Given the SAS data sets EMPLOYEE and NEWEMPLOYEE: EMPLOYEE NEWEMPLOYEE NAME DEPT NAME SALARY ------- -------- --------- ---------- Alan Sales Michelle 50000 Michelle Sales Paresh 6...

The variable TOTOBS has a value of 123, which represents the total number of observations in a SAS data set. Which assignment statement correctly creates the variable PTOBS that gu...

When does a SELECT statement in a DATA step always use fewer CPU resources than IF- THEN/ELSE statements?

The following SAS program is submitted: proc sql; insert into company.employee(name, salary, birthdate) select name, salary, birthdate from work.newemployees; What is the result of...

The following SAS program is submitted: proc sort data=class out=class1 nodupkey; by name course ; run; Which SQL procedure program produces the same results?

Given the data sets shown on the left, the SAS program shown on the right is submitted. What will be output by the program?

This question will ask you to provide a missing reference. Given the SAS data set SASUSER HIGHWAY: The following SAS program is submitted: What macro variable reference completes t...

This question will ask you to provide a segment of missing code. Given the SAS data set SASUSER.HIGHWAY: The following SAS program is submitted: Which SQL clause stores the text 0-...

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

The following SAS program is submitted: The current system date macro variable is 30JUL2013. Which output will be written to the log by the program?

This question will ask you to provide a segment of missing code. Given the SAS data set SASUSER.ORDERS: The following SAS program is submitted: Which statement completes the progra...

This question will ask you to provide a segment of missing code. The following SAS program submitted: Which segment of code will successfully run an in-line view?

In the data step merge, the BY variables in all data sets must have the same: