SAS Institute A00-212 Online Practice Questions and Exam Preparation

SAS Institute A00-212 Online Questions & Answers

• Question 61:

  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
  D. View = finance.new

• Question 62:

  Which one of the following displays the definition of a stored SQL procedure view in the SAS log?

  A. ECHOVIEW option
  B. EXPANDVIEW option
  C. VALIDATE VIEW statement
  D. DESCRIBE VIEW statement
  D. DESCRIBE VIEW statement

• Question 63:

  Given the data sets:

  

  The following SAS program is submitted:

  

  Which result set would be generated?

  A. 100
  B. 200
  C. 300
  D. 400
  A. 100

• Question 64:

  The following SAS program is submitted:

  data temp;

  length 1 b 3 x;

  infile 'file reference';

  input a b x;

  run;

  What is the result?

  A. The data set TEMP is not created because variables A and B have invalid lengths
  B. The data set TEMP is created, but variable X is not created
  C. The data set TEMP is not created because variable A has an invalid length
  D. The data set TEMP is created and variable X has a length of 8
  C. The data set TEMP is not created because variable A has an invalid length

• Question 65:

  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?

  A. CHECK
  B. UNIQUE
  C. FORMAT
  D. DISTINCT
  A. CHECK

• Question 66:

  The following SAS program is submitted:

  %let dept=prod;

  %let prod=merchandise;

  The following message is written to the SAS log:

  The value is "merchandise"

  Which SAS System option writes this message to the SAS log?

  A. %put the value is "andandanddept";
  B. %put the value is "andandanddept";
  C. %put the value is "andandanddept";
  D. %put the value is %quote (andandanddept);
  A. %put the value is "andandanddept";

• Question 67:

  Given the SAS data set ONE:

  ONE

  DIVISION SALES

  A 1234

  A 3654

  B 5678

  The following SAS program is submitted:

  Data_null_;

  Set one;

  By divition;

  If first.division then

  Do;

  %let mfirst=sales;

  end;

  run;

  What is the value of the macro variable MFRIST when the program finishes execution?

  A. 1234
  B. sales
  C. 5678
  D. null
  B. sales

• Question 68:

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

  Given the two data sets on the left, the SAS program on the right is submitted.

  

  

  In the text box in the program above, complete the program so that it will properly use the macro variable to select the corresponding cities. Case is ignored and standard SAS syntax rules apply.

  North Carolina

• Question 69:

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

• Question 70:

  The following SAS code is submitted:

  %macro houses(dsn = houses,sub = RANCH);

  data anddsn;

  set sasuser.houses;

  if style = "?quot;;

  run;

  %mend;

  %houses(sub = SPLIT)

  %houses(dsn = ranch)

  %houses(sub = TWOSTORY)

  Which one of the following is the value of the automatic macro variable SYSLAST?

  A. work.ranch
  B. work.houses
  C. WORK.RANCH
  D. WORK.HOUSES
  D. WORK.HOUSES