Download SAS Advanced Programming Exam for SAS 9.A00-212.PassGuide.2018-11-09.106q.vcex

Vendor: SASInstitute
Exam Code: A00-212
Exam Name: SAS Advanced Programming Exam for SAS 9
Date: Nov 09, 2018
File Size: 4 MB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
Given the SAS data sets ONE and TWO:
  
The following SAS program is submitted:
Proc sql; 
Select two.*,budget from one <insert JOIN operator here> two on one.year=two.year, 
Quit; 
The following output is desired:
  
Which JOIN operator completes the program and generates the desired output? 
  1. FULL JOIN
  2. INNER JOIN
  3. LEFT JOIN
  4. RIGHT JOIN
Correct answer: A
Question 2
Given the SAS data set SAUSER.HIGWAY:
SASUSER.HIGHWAY 
  
The following SAS program is submitted: 
%macro highway; 
proc sql nonprint; 
%let numgrp=6; 
select distinct status into:group1-:group&numgrp from sasuser.highway;
quit; 
%do i=1 %to &numgrp; 
proc print data =sasuser.highway; 
where status ="&&group&I"; 
run; 
%end; 
%mend; 
%highway 
How many reports are produced?
  1. 2
  2. 6
  3. 0
  4. 5
Correct answer: A
Question 3
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?
  1. %put the value is "&&&dept";
  2. %put the value is "&&&dept";
  3. %put the value is "&&&dept";
  4. %put the value is %quote (&&&dept);
Correct answer: A
Explanation:
Question 4
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?
  1. 1234
  2. sales
  3. 5678
  4. null
Correct answer: B
Question 5
The following SAS program is submitted:
%let first=yourname; 
%let last=first; 
%put &&&last; 
What is written to the SAS Log?
  1. First
  2. Yourname
  3. &&First
  4. &yourname
Correct answer: B
Question 6
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
Correct answer: B
Question 7
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;
Correct answer: C
Question 8
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
Correct answer: B
Question 9
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 
Correct answer: B
Question 10
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?
  1. proc sql; 
    Contents table testdata.one; 
    Quit;
  2. proc sql; 
    Describe table testdata.one; 
    Quit;
  3. proc sql; 
    describe testdata.one; 
    Quit;
  4. proc sql; 
    Contents testdata.one; 
    Quit;
Correct answer: B
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!