SAS Institute A00-212 Online Practice Questions and Exam Preparation

SAS Institute A00-212 Online Questions & Answers

• Question 1:

  The following SAS program is submitted:

  

  What is the value of the macro variable Newval when the %PUT statement executes?

  A. 0.555
  B. 2.2
  C. 1
  D. 2
  C. 1

• Question 2:

  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)";
  D. Where upcase(name)="%upcase(andvalue)";

• Question 3:

  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
  B. CHANGE statement only

• Question 4:

  The following SAS program is submitted:

  %macro test(var);

  %let jobs = BLACKSMITH WORDSMITH SWORDSMITH;

  %let type = %index(andjobs,andvar);

  %mend;

  %test(SMITH)

  Which one of the following is the resulting value of the macro variable TYPE?

  B. 3
  C. 6
  D. null
  C. 6

• Question 5:

  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;
  A. data three; set one; set two key = char1; run;

• Question 6:

  When reading a SAS data file, what does the NOBS=option on the SET statement represent?

  A. A variable that represents the total number of observation in the output data set(s)
  B. A variable that represents a flag indicating the end of the file
  C. A variable that represents the total number of observations in the input data set(s)
  D. A variable that represents the current observation number
  C. A variable that represents the total number of observations in the input data set(s)

• Question 7:

  The following SAS program is submitted:

  date view=sauser.ranch;

  describe;

  run;

  What is the result?

  A. The program creates a DATA step view called SASUSER.RANCH and places the program cod in the current editor window
  B. The program retrieves the SAS source code that creates the view and places it in the output window
  C. The program creates a DATA step view called SASUSER.RANCH and places it in the SAS log
  D. the program retrieves the SAS source code that creates the view and places it in the SAS log
  D. the program retrieves the SAS source code that creates the view and places it in the SAS log

• Question 8:

  The following SAS program is submitted:

  proc contents data = testdata.one;

  run;

  Which SQL procedure program produces similar information about the column attributes of the dataset TESTDATA.ONE?

  A. proc sql; Contents table testdata.one; Quit;
  B. proc sql; Describe table testdata.one; Quit;
  C. proc sql; describe testdata.one; Quit;
  D. proc sql; Contents testdata.one; Quit;
  B. proc sql; Describe table testdata.one; Quit;

• Question 9:

  The following SAS program is submitted:

  %let value=9;

  %let add=5;

  %let newval=%eval(andvalue/andadd);

  What is the value of the macro variable NEWVAL?

  A. null
  B. 2
  C. 1
  D. 1.8
  C. 1

• Question 10:

  What is the purpose of the SASFILE statement?

  A. It requests that SAS data set be opened and loaded into SAS memory one page at a time
  B. It requests that a SAS data set the opened and loaded into SAS memory one variable at a time
  C. It requests that a SAS data set be opened and loaded into SAS memory one observation at a time
  D. It requests that a SAS data set be opened and loaded into SAS memory in its entirety
  D. It requests that a SAS data set be opened and loaded into SAS memory in its entirety