SAS Institute SAS Institute Certifications A00-212 Questions & Answers

• Question 61:

  Given the unsorted data set WORK.ORDERS

  

  The following three programs are submitted:

  

  Which program will create a list of unique Customer_ID values in the WORK.ORDERS data set?

  A. Only programs 2 and 3

  B. Only programs 1 and 2

  C. Programs 1, 2, and 3

  D. Only programs 1and 2

  Correct Answer: A

• Question 62:

  Given the SAS data sets ONE and TWO:

  

  The following SAS program is submitted:

  Data combine;

  Merge one two;

  By id;

  Run;

  Which SQL procedure program procedures the same results?

  A. proc sql; Create table combine as Select coalesce (one.id, two.id) as id, Name,salary from one, two where one.id=two.id; Quit;

  B. proc sql; Create table combine as Select one.id, Name, salary from one full join two where one.id=two.id; Quit

  C. proc sql; Create table combine as Select one.id,name,salary from one inner join two on one.id=two.id Quit

  D. proc sql; Create table combine as Select coalesce (one id, two id) as id, Name,salary from one full join two on one.id=two.id; Quit;

  Correct Answer: D

• Question 63:

  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 variable START?

  A. %let start = today(),weekdate.;

  B. %let start = today(),format=weekdate.;

  C. %let start = %sysfunc(today(),weekdate.);

  D. %let start = %sysfunc(%today(),weekdate.);

  Correct Answer: C

• Question 64:

  The question will ask you to provide a segment of missing code.

  Given the following SAS program:

  

  Which segment of code completes the program to use finance.new SAS view?

  A. Data = finance.new

  B. Data = finance.new / view = finance.new

  C. Data = finance.new / view

  D. View = finance.new

  Correct Answer: D

• Question 65:

  Given the data set SASHELP.CLASS:

  SASHELP.CLASS

  NAME AGE

  Mary 15

  Philip 16

  Robert 12

  Ronald 15

  The following SAS program is submitted:

  %let value = Philip;

  proc print data = sashelp.class;

  run;

  Which WHERE statement successfully completes the program and procedures a report?

  A. Where upcase(name)=%upcase(andvalue);

  B. Where upcase(name)="upcase(andvalue)";

  C. Where upcase(name)=upcase(andvalue);

  D. Where upcase(name)="%upcase(andvalue)";

  Correct Answer: D

• Question 66:

  Given the following SAS data sets ONE and TWO: ONE TWO OBS COMMON X OBS COMMON Y 1 A 10 1 A 1 2 A 13 2 A 3

  3 A 14 3 B 4 4 B 9 4 B 2 5 C 8 5 C 5 6 C 14 The following SAS DATA step is submitted:

  data combine;

  merge one two;

  by common;

  run;

  Which one of the following represents the data values stored in data set COMBINE?

  A. OBS COMMON X Y 1 A 10 1 2 A 13 3 3 A 14 3 4 B 9 4 5 B 9 2 6 C 8 5 7 C 14 5

  B. OBS COMMON X Y 1 A 10 1 2 A 13 3 3 B 9 4 4 C 8 5

  C. OBS COMMON X Y 1 A 10 1 2 A 13 3 3 B 14 4 4 B 9 2 5 C 8 5

  D. OBS COMMON X Y 1 A 10 1 2 A 13 1 3 A 14 1 4 A 10 3 5 A 13 3 6 A 14 3 7 B 9 4 8 B 9 2 9 C 8 5 10 C 14 5

  Correct Answer: A

• Question 67:

  The following are values of the variable STYLE from the SAS data set SASUSER.HOUSES: SASUSERS.HOUSES OBS STYLE

  1 RANCH 2 SPLIT 3 CONDO 4 TWOSTORY 5 RANCH 6 SPLIT 7 SPLIT The following SAS program is submitted: proc sql noprint; select distinct style into :styles separated by ' ' from sasuser.houses order by style; quit; Which one of the following is the value of the resulting macro variable?

  A. CONDO RANCH SPLIT TWOSTORY

  B. RANCH SPLIT CONDO TWOSTORY

  C. CONDO RANCH RANCH SPLIT SPLIT SPLIT TWOSTORY

  D. RANCH SPLIT CONDO TWOSTORY RANCH SPLIT SPLIT

  Correct Answer: A

• Question 68:

  Given the non-indexed SAS data set TEMP: TEMP X Y

  P 52 P 45 A 13 A 56 R 34 R 12 R 78 The following SAS program is submitted: Proc print data=temp;

  A. X;

  B. By X groupd;

  C. By X notsorted;

  D. By descending X;

  Correct Answer: C

• Question 69:

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

  A. data three; set one; set two key = char1; run;

  B. data three; set one; if char1 in ('new york' 'los angeles'); run;

  C. data three; set one; where char1 in ('new york' 'los angeles'); run;

  D. proc sql; create table three as select * from one, two where one.char1 > two.char1;

  quit;

  Correct Answer: A

• Question 70:

  The following SAS program is submitted:

  %macro execute;

  proc print data = sasuser.houses;

  run;

  %end;

  %mend;

  Which of the following completes the above program so that it executes on Tuesday?

  A. %if andsysday = Tuesday %then %do;

  B. %if andsysday = 'Tuesday' %then %do;

  C. %if "andsysday" = Tuesday %then %do;

  D. %if 'andsysday' = 'Tuesday' %then %do;

  Correct Answer: A