A00-202 Exam Questions

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

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 techniques concatenates data in SAS?

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

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

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

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

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

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

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

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

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

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

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

Which one of the following programs contains a syntax error?

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

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

Which one of the following statements is true?

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?

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

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

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

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

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?

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