SAS Institute A00-212 SAS Advanced Programming Exam for SAS 9 Online Training
SAS Institute A00-212 Online Training
The questions for A00-212 were last updated at Nov 23,2024.
- Exam Code: A00-212
- Exam Name: SAS Advanced Programming Exam for SAS 9
- Certification Provider: SAS Institute
- Latest update: Nov 23,2024
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?
- A . What displays is three
- B . What displays is two
- C . What displays is one
- D . What displays is last
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)?
- A . The variables named POINTS10, POINTS15, POINTS20, POINTS25, POINTS30, POINTS35 are created in the PDV
- B . No variables are created in the PDV
- C . The variables named POINTS1, POINTS2, POINTS4, POINTS5, POINTS6 are created in the PDV
- D . The variables named POINTS11, POINTS12, POINTS13, POINTS21, POINTS22, POINTS23 are created in the PDV
Which DICTIONARY table provides information on all the tables containing a variable named LASTNAME?
- A . DICTIONARY.COLUMNS
- B . DICTIONARY.VARIABLES
- C . DICTIONARY.MEMBERS
- D . DICTIONARY.TABLES
What is generated as a result of submitting the RANUNI function with a seed of 123?
- A . A missing value because 123 is an invalid argument for the RANUNI function
- B . A different sequence of random numbers with each program execution
- C . A random number between 0 and 123
- D . A consistent sequence of random numbers with each program execution
What is an advantage of using a hash object in a SAS DATA step?
- A . The hash object persists after the DATA step has executed
- B . The hash object key values can be multiple numeric and character data values
- C . The hash object automatically sorts the data
- D . The hash object does not require unique keys
Which of the following statement(s) in the DATASETS procedure alters the name of a SAS data set stored in a SAS data library?
- A . RENAME statement only
- B . CHANGE statement only
- C . MODIFY and RENAME statements
- D . MODIFY and CHANGE statements
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 &development";
run;
Which one of the following statements completes the above and resolves title1 to "For research&development"?
- A . %let dept = %str(research&development);
- B . %let dept = %str(research%&development);
- C . %let dept = %nrstr(research&development);
- D . %let dept = %nrstr(research%&development);
Which one of the following options controls the pagesize of a SAS data set?
- A . SIZE=
- B . BUFNO=
- C . BUFSIZE=
- D . PAGESIZE=
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 program is submitted:
proc sql;
select rep, avg(cost) as AVERAGE
from one
group by rep
having avg(cost) > (select avg(cost) from one);
quit;
Which one of the following reports is generated?
- A . REP AVERAGE JONES 200
- B . REP AVERAGE JONES 320
- C . REP AVERAGE SMITH 320
- D . REP AVERAGE SMITH 500
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?
- A . I/O usage only
- B . CPU usage only
- C . I/O and CPU usage
- D . temporary disk usage
Latest A00-212 Dumps Valid Version with 184 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
thank you