A00-212 Exam Questions

The following SAS program is submitted: %let test=one; %let one=two; %let two=three; %let three=last; %put what displays is &&&&&test; What is the written to the SAS log?

The following SAS program is submitted: data temp; array points{2,3} (10, 15, 20, 25, 30, 35); run; What impact does the ARRAY statement have in the program Data vector (PDV)?

Which DICTIONARY table provides information on all the tables containing a variable named LASTNAME?

What is generated as a result of submitting the RANUNI function with a seed of 123?

What is an advantage of using a hash object in a SAS DATA step?

The following SAS program is submitted: %macro one(input); %two %put the value is &date; %mend; %macro two; data _null_; call symput('date', '12SEP2008'); run; %mend; %let date = 3...

Which of the following statement(s) in the DATASETS procedure alters the name of a SAS data set stored in a SAS data library?

The following SAS program is submitted: <insert statement here>; %let development = ontime; proc print data = sasuser.highway; title "For &dept"; title2 "This project was completed...

Which one of the following options controls the pagesize of a SAS data set?

Given the following SAS data set ONE: ONE REP COST ----- ---- SMITH 200 SMITH 400 JONES 100 SMITH 600 JONES 100 JONES 200 JONES 400 SMITH 800 JONES 100 JONES 300 The following SAS...

The following SAS program is submitted: proc sort data = sales tagsort; by month year; run; Which of the following resource(s) is the TAGSORT option reducing?

The following SAS program is submitted: data one; do i = 1 to 10; ptobs = ceil(ranuni(0) * totobs); set temp point = ptobs nobs = totobs; output; end; stop; run; The SAS data set T...

Which one of the following programs contains a syntax error?

The following SAS code is submitted: %macro houses(dsn = houses,sub = RANCH); data &dsn; set sasuser.houses; if style = "-"; run; %mend; %houses(sub = SPLIT) %houses(dsn = ranch) %...

Given the following SAS data sets ONE and TWO: ONE TWO NUM COUNTRY NUM CITY --- --------- ---- ------ 1 CANADA 3 BERLIN 2 FRANCE 5 TOKYO 3 GERMANY 4 BELGIUM 5 JAPAN The following S...

Which one of the following statements is true?

The variable attributes of SAS data sets ONE and TWO are shown below: ONE TWO # Variable Type Len Pos # Variable Type Len Pos 2 sales Num 8 8 2 budget Num 8 8 1 year Num 8 0 3 sale...

Given the following SAS statement: %let idcode = Prod567; Which one of the following statements stores the value 567 in the macro variable CODENUM?

The following SAS program is submitted: data new (bufsize = 6144 bufno = 4); set old; run; Which one of the following describes the difference between the usage of BUFSIZE= and BUF...

Consider the following SAS log: 229 data sasuser.ranch sasuser.condo / view = sasuser.ranch; 230 set sasuser.houses; 231 if style = 'RANCH' then output sasuser.ranch; 232 else if s...

Which one of the following is an advantage of creating and using a SAS DATA step view?

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 data set ONE: ONE NUM VAR --- --- 1 A 2 B 3 C Which one of the following SQL programs deletes the SAS data set ONE?

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

The SAS data set TEMP has the following distribution of values for variable A: A Frequency -- -------- 1 500,000 2 500,000 6 7,000,000 8 3,000 Which one of the following SAS progra...

The following SAS program is submitted: %let value = 9; %let value2 = 5; %let newval = %eval(&value / &value2); Which one of the following is the resulting value of the macro varia...

The following SAS program is submitted: %let lib = %upcase(sasuser); proc sql; select nvar from dictionary.tables where libname = "&lib"; quit; Given that several SAS data sets exi...

Given the following SAS data set ONE: ONE GROUP SUM ----- ---- A 765 B 123 C 564 The following SAS program is submitted: data _null_; set one; call symput(group,sum); run; Which on...

The SAS data set ONE consists of five million observations and has 25 variables. Which one of the following SAS programs successfully creates three new variables TOTREV, TOTCOST, a...

Given the following SAS data set ONE: ONE COUNTRY CITY VISIT USA BOSTON 10 UK LONDON 5 USA DALLAS 10 UK MARLOW 10 USA BOSTON 20 UK LONDON 15 USA DALLAS 10 The following SAS program...

Given the following SAS data sets ONE and TWO: ONE TWO NUM CHAR1 NUM CHAR2 1 A 2 X 2 B 3 Y 4 D 5 V The following SAS program is submitted creating the output table THREE: data thre...

Which one of the following automatic SAS macro variables contains the return code from a previously executed step?

The SAS data set ONE has a variable X on which an index has been created. The data sets ONE and THREE are sorted by X. Which one of the following SAS programs uses the index to sel...

Given the following SAS data set ONE: ONE REP AREA COST SMITH NORTH 100 SMITH SOUTH 200 JONES EAST 100 SMITH NORTH 300 JONES WEST 100 JONES NORTH 200 JONES NORTH 400 SMITH NORTH 40...

Which one of the following SAS procedures changes a permanent format of a variable stored in a SAS data set?

Given the following SAS data set SASUSER.HIGHWAY: The following SAS program is submitted: %macro highway; proc sql noprint; select count(distinct status) into :numgrp from sasuser....

Text is sent to the SAS compiler as a result of macro execution. Which one of the following SAS system options writes that text to the log?

Given the following SAS data set ONE: ONE CATEGORY AGE SALARY BONUS --------- ---- ----- ----- M 28 200 . M 25 100 10 F 18 100 50 F 25 200 10 The following SAS program is submitted...

Which one of the following SAS SORT procedure options eliminates identical consecutive observations?

The following SAS program is submitted: data temp; array points{3,2}_temporary_ (10,20,30,40,50,60); score = points{2,1} run; Which one of the following is the value of the variabl...

The following SAS FORMAT procedure is submitted: proc format lib = sasuser; value tempc low < 0 = 'BELOW FREEZING' 0 < 5 = 'COLD' 5 < 10 = 'MILD' 10 < 15 = 'WARM' 15 high = 'HOT';...

Which one of the following SAS programs uses the most amount of memory resources for output buffers?

Given the following SAS data sets ONE and TWO: ONE TWO NUM CHAR1 NUM CHAR2 1 A1 2 X1 1 A2 2 X2 2 B1 3 Y 2 B2 5 V 4 D The following SAS program is submitted creating the output tabl...

The following SAS program is submitted: %macro execute; <insert statement here> proc print data = sasuser.houses; run; %end; %mend; Which of the following completes the above progr...

Which one of the following statements is true regarding a SAS DATA step view?

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

Assume today is Tuesday, July 23, 2002. Which one of the following statements submitted at the beginning of a SAS session assigns the value Tuesday, July 23, 2002 to the macro vari...

The following SAS program is submitted: %macro test(var); %let jobs = BLACKSMITH WORDSMITH SWORDSMITH; %let type = %index(&jobs,&var); %mend; %test(SMITH) Which one of the followin...

Which one of the following SAS integrity constraint types ensures that a specific set or range of values are the only values in a variable?

Which one of the following options displays the value of a macro variable in the SAS log?