A00-202 Exam Questions
76 real A00-202 exam questions with expert-verified answers and explanations. Page 1 of 2.
- Question #1
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...
- Question #2
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...
- Question #3
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...
- Question #4
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...
- Question #6
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...
- Question #7
Which one of the following is the purpose of the REUSE= YES option in a compressed SAS data set?
- Question #8
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?
- Question #10
Which one of the following options controls the pagesize of a SAS data set?
- Question #11
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...
- Question #12
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...
- Question #13
When is it appropriate to create indexes on a SAS data set for efficient processing?
- Question #14
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?
- Question #15
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...
- Question #16
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...
- Question #17
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...
- Question #18
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?
- Question #19
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...
- Question #20
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...
- Question #21
Given the following SAS data set SASUSER.HIGHWAY: SASUSER.HIGHWAY SAS A00-202 Exam STEERING SEATBELT SPEED STATUS COUNT -------------------- ----------------- ------------------ --...
- Question #22
Which one of the following statements is true regarding a SAS DATA step view?
- Question #23
Which one of the following SAS procedures changes a permanent format of a variable stored in a SAS A00-202 Exam SAS data set?
- Question #24
Which of the following statement(s) in the DATASETS procedure alters the name of a SAS data set stored in a SAS data library?
- Question #25
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...
- Question #26
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...
- Question #27
Which one of the following should be avoided when creating and using an SQL procedure view?
- Question #28
Given the following SAS data set SASUSER.HIGHWAY: SASUSER.HIGHWAY STEERING SEATBELT SPEED STATUS COUNT -----------------------------------------------------------------------------...
- Question #29
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...
- Question #30
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...
- Question #32
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';...
- Question #33
Which one of the following options is available for SAS macro debugging?
- Question #34
The following SAS program is submitted: proc sql; select * from dictionary.tables; quit; Which one of the following is reported?
- Question #35
Which one of the following automatic SAS macro variables contains the return code from a previously executed step?
- Question #36
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...
- Question #37
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?
- Question #38
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...
- Question #39
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...
- Question #40
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?
- Question #41
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...
- Question #43
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...
- Question #44
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...
- Question #45
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...
- Question #46
The DICTIONARY.MACROS table stores information about which of the following?
- Question #47
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?
- Question #48
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...
- Question #49
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...
- Question #50
Given the following SAS statement: %let idcode = Prod567; Which one of the following statements stores the value 567 in the macro variable CODENUM?
- Question #51
SAS A00-202 Exam Given the following SAS data sets ONE and TWO: ONE TWO YEAR QTR BUDGET YEAR QTR SALES ----------- ----------- ----------- ---------- ----------- --------- 2001 3 5...
- Question #52
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...
- Question #53
Which one of the following SAS procedures changes a permanent format of a variable stored in a SAS data set?
- Question #54
Which one of the following statements about compressed SAS data sets is always true?