A00-202 Exam Questions
76 real A00-202 exam questions with expert-verified answers and explanations. Page 2 of 2.
- Question #55
Given the following SAS data set ONE: ONE LEVEL AGE ------------ ---------- 1 10 2 20 3 20 2 10 1 10 2 30 SAS A00-202 Exam 3 10 2 20 3 30 1 10 The following SAS program is submitte...
- Question #56
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...
- Question #57
Which one of the following techniques concatenates data in SAS?
- Question #58
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 10...
- Question #59
The following SAS program is submitted: proc datasets lib = testdata; modify one; SAS A00-202 Exam label num = 'Number'; format num 4.; quit; Which one of the following SQL program...
- Question #60
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 follow...
- Question #61
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...
- Question #62
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...
- Question #63
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...
- Question #64
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 divisio...
- Question #65
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...
- Question #66
Which one of the following SAS programs uses the most amount of memory resources for output buffers?
- Question #67
Which one of the following is the purpose of the IDXNAME= data set option?
- Question #68
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...
- Question #69
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...
- Question #70
Which one of the following programs contains a syntax error?
- Question #71
In which one of the following SAS programs is the SAS data set index named CHAR1 always used?
- Question #72
Which one of the following is true regarding the KEEP statement?
- Question #73
Which one of the following statements is true?
- Question #74
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?
- Question #75
Given the following SAS data set ONE: ONE JOB LEVEL SALARY ----------- ---------------- --------------- SAS A00-202 Exam ACC 2 300 SEC 1 100 SEC 2 200 MGR 3 700 ACC 1 . ACC 3 . MGR...
- Question #76
Which one of the following is an advantage of creating and using a SAS DATA step view? SAS A00-202 Exam
- Question #77
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 follo...
- Question #78
The following SAS ARRAY statement is submitted: array score{*} a4 - a10, a25 ; Which one of the following is the maximum number of elements stored?
- Question #79
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?
- Question #80
SAS A00-202 Exam Which one of the following SAS programs displays the descriptor portion of each data set stored in the SASUSER library?