A00-202 Exam Questions

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

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

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

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

The following SAS program is submitted: %let var = chicago, 1; data a; var = 'new york, 2'; newvar = %scan(&var,2,%str()); run; Which one of the following explains why the program...

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

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?

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

Given the following SAS program: proc sql; select product, type, sum(sales) as revenue SAS A00-202 Exam from one group by product, type; quit; Which one of the following clauses sh...

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

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

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

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

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

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: %let lib = %upcase(sasuser); proc sql; select nvar from dictionary.tables where libname = "&lib"; quit; Given that several SAS data sets exi...

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

Given the following SAS data set SASUSER.HIGHWAY: SASUSER.HIGHWAY SAS A00-202 Exam STEERING SEATBELT SPEED STATUS COUNT -------------------- ----------------- ------------------ --...

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

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

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

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 SAS A00-202...

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

Given the following SAS data set SASUSER.HIGHWAY: SASUSER.HIGHWAY STEERING SEATBELT SPEED STATUS COUNT -----------------------------------------------------------------------------...

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

The following are values of the variable STYLE from the SAS data set SASUSER.HOUSES: SASUSERS.HOUSES SAS A00-202 Exam OBS STYLE ------------ -------- 1 RANCH 2 SPLIT 3 CONDO 4 TWOS...

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 options is available for SAS macro debugging?

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

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

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

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 COUNTRY CITY VISIT ----------------- ---------------- -------- USA BOSTON 10 UK LONDON 5 USA DALLAS 10 UK MARLOW 10 USA BOSTON 20 UK LONDO...

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

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?

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

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

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

SAS A00-202 Exam The following SAS program is submitted: %macro test(var); %let jobs = BLACKSMITH WORDSMITH SWORDSMITH; %let type = %index(&jobs,&var); %mend; %test(SMITH) Which on...

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

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 following SAS data sets ONE and TWO: ONE TWO OBS COMMON X OBS COMMON Y -------- -------------- ------ -------- ---------------- ------ 1 A 10 1 A 1 SAS A00-202 Exam 2 A 1...

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

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

SAS A00-202 Exam Given the following SAS data sets ONE and TWO: ONE TWO YEAR QTR BUDGET YEAR QTR SALES ----------- ----------- ----------- ---------- ----------- --------- 2001 3 5...

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

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

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