Free A00-212 Exam Dumps Preview

FILL BLANK

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.

Given the SAS date sets CLASS1 and CLASS2

CLASS1 CLASS2

NAME COURSE NAME COURSE

Lauren MATH1 Smith MATH2

Patel MATH1 Farmer MATH2

Chang MATH1 Patel MATH2

Chang MATH3 Hiller MATH2

The following SAS program is submitted:

Proc sql;

Select name from CLASS1

<insert SQL set operator here>

select name from CLASS;

quit;

The following output is desired

NAME

Chang

Chang

Lauren

Which SQL set operator completes the program and generates the desired output?

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?

Given the unsorted data set WORK.ORDERS

The following three programs are submitted:

Which program will create a list of unique Customer_ID values in the WORK.ORDERS data set?

Given the following SAS data set named WORK.INTERNAT:

WORK.INTERNAT

LOCATION SUM
USA 30

EUR 40

The following SAS program is submitted:

%let LOC = Usa;

proc sql;

select *

from internat

where location = "&Loc";

quit;

Which one of the following is the result when the above code is executed on the above data set?

Given the SAS data set WORK.ONE:

The following SAS program is submitted;

Which result set would be generated?

The following SAS program is submitted:

%let name = Patel's Restaurant;

Which one of the following statements avoids problems associated with the unbalanced quotation mark?

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

Which one of the following automatic SAS macro variables contains the return code from a previously executed step?

Given the following SAS program:

What will be the output from the PRINT Procedure?

Which statement(s) in the DATASETS procedure alter(s) the name of a SAS data set stored in a SAS data library?

The following SAS program is submitted:

proc datasets lib = testdata;

modify one;

label num = 'Number';

format num 4.;

quit;

Which one of the following SQL programs produces the same results as the above DATASETS procedure?

The following SAS program is submitted:

What is written to the SAS log?

The SAS data set ONE has a variable X on which an index has been created. The data sets ONE and THREE are sorted by X.

Which one of the following SAS programs uses the index to select observations from the data set ONE?

The following SAS program is submitted:

%macro execute;

<insert statement here>

proc print data = sasuser.houses;

run;

%end;

%mend;

Which of the following completes the above program so that it executes on Tuesday?

Given the SAS data sets:

The following SAS DATA step is submitted:

What data values are stored in data set WORK.COMBINE?

Following SAS program is submitted:

data temp(<insert option here>);
infile 'rawdata';

input x $ y z;

run;

RAWDATA is a file reference to an external file that is ordered by the variable X.

Which option specifies how the data in the SAS data set TEMP will be sorted?

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;

<insert Where statement here>

run;

Which WHERE statement successfully completes the program and produces a report?

The following SAS program is submitted:

%micro cols1;

name age;

%mend;

%macro cols2;

height weight

%mend

proc print data=sashelp.class;

<insert VAR statement here>

Run

Which VAR statement successfully completes the program and produces a report?

This question will ask you to provide missing option.

Which option is required to complete the program correctly?

Given the following SAS data sets ONE and TWO:

ONE TWO

NUM CHAR1 NUM CHAR2

1 A 2 X
2 B 3 Y

4 D 5 V

The following SAS program is submitted creating the output table THREE:

data three;

set one two;

run;

THREE

NUM CHAR1 CHAR2

1 A

2 B

4 D

2 X

3 Y

5 V

Which one of the following SQL programs creates an equivalent SAS data set THREE?

Which one of the following SAS SORT procedure options eliminates identical consecutive observations?

Given the following SAS data set ONE:

ONE

DIVISION SALES

A 1234

A 3654

B 5678

The following SAS program is submitted:

data _null_;

set one;

by division;

if first.division then

call symput('mfirst',sales);

if last.division then

call symput('mlast',sales);
run;

Which one of the following is the value of the macro variable MFIRST when the above program finishes execution?

The following SAS program is submitted:

data temp;

array points{2,3} (10,15,20,25,30,35);

run;

What impact does the ARRAY statement have in the Program Data Vector(PDV)?

The following SAS program is submitted:

<insert statement here>;

%let development = ontime;

proc print data = sasuser.highway;

title "For &dept";

title2 "This project was completed &development";

run;

Which one of the following statements completes the above and resolves title1 to "For research&development"?

This item will ask you to provide a segment of missing code.
Given the input data set shown on the left and the output data set shown on the right:

In the text below, enter the code that will complete the program to produce the output set shown above on the right.

Case is ignored and standard SAS syntax rules apply.

The following SAS program is submitted:

%micro test(var);

%let jobs=BLACKSMITH WORDSMITH SWORDSMITH;

%let type=%index(&jobs, &var);

%put type = &type;

%mend;

%test(SMITH)

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

Given the SAS data sets:

A SAS program is submitted and the following is written to SAS to:

What would allow the program to successfully execute without errors?