CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. SAS Institute
  5. A00-212

Free A00-212 Exam Braindumps (page: 6)

Page 5 of 47
PDF with 184 Questions

The following SAS program is submitted:

%let a=cat;
%macro animal(a=frog);
%let a=bird;
%mend;
%animal(a=pig)
%put a is &a;

What is written to the SAS log?

  1. a is pig
  2. a set cat
  3. a is frog
  4. a is bird

Answer(s): B



Which SQL procedure program deletes rows from the data set CLASS?

  1. proc sql;
    Select * from class
    Where age<(select stop_age from threshold);
    Quit;
  2. proc sql;
    Modify table class
    Delete where age<(select stop_age from threshold);
    Quit
  3. proc sql;
    Delete from class
    Where age<(select stop_age from threshold);
    Quit;
  4. proc sql;
    Alter from class
    Delete where age<(select stop_age from threshold);
    Quit;

Answer(s): C



The following SAS program is submitted:

%let lib=%upcase(sauser); proc sql;
select nvar form dictionary.tables where libname='&lib"; quit;
Several SAS data sets exist in the SAUSER library.

What is generated as output?

  1. A report showing the names of the columns in each table in SASUSER
  2. A report showing the number of columns in each table in SASUSER
  3. A report showing the numeric columns in each table in SASUSER
  4. A report showing the number of numeric columns in each table in SASUSER

Answer(s): B



The following SAS program is submitted:

%macro loop;
data one;
%do I=1 %to 3;
var&I=&I;%
end
run;
%mend;
%loop

After this program executes; the following is written to the SAS log:
(LOOP): Beginning execution
(LOOP): %DO loop beginning; index variable l; start value is 1; stop value is 3; by value is 1
(LOOP): %DO loop index variable l is now 2; loop will iterate again
(LOOP): %DO loop index variable l is no 3; loop will iterate again
(LOOP): %DO loop index variable l is no 4; loop will iterate again
(LOOP): Ending execution

Which SAS system option displays the notes in the SAS log?

  1. SYMBOLGEN
  2. MLOGIC
  3. MACRO
  4. MPRINT

Answer(s): B






Post your Comments and Discuss SAS Institute A00-212 exam with other Community members:

A00-212 Discussions & Posts