QUESTION: 9

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?

FULL JOIN
INNER JOIN
LEFT JOIN
RIGHT JOIN

Answer(s): A

Reveal Solution Next Question

QUESTION: 10

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?

2
6
0
5

Answer(s): A

Reveal Solution Next Question

QUESTION: 11

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?

%put the value is "&&&dept";
%put the value is "&&&dept";
%put the value is "&&&dept";
%put the value is %quote (&&&dept);

Answer(s): A

Reveal Solution Next Question

QUESTION: 12

The SAS data set WORK.TEMPDATA contains the variables FMTNAME, START and LABEL and it consists of 10 observations.

The following SAS program is submitted:
Proc format cntlin=wor.tempdata;
Run;

What is the result of submitting the FORMAT procedure step?

It uses the WORK.TEMPDATA SAS data set as input to create the format
All formats created will be stored in two WORK.TEMPDATA SAS data set
An ERROR message is written to the SAS log because the program is incomplete
NO formats are created in this step

Answer(s): A

Reveal Solution Next Question

Free A00-212 Exam Braindumps (page: 18)

QUESTION: 9

QUESTION: 10

QUESTION: 11

QUESTION: 12

A00-212 Exam Discussions & Posts