SAS Institute A00-212 SAS Advanced Programming Exam for SAS 9 Online Training

SAS Institute A00-212 Online Training

The questions for A00-212 were last updated at Dec 24,2024.

Exam Code: A00-212
Exam Name: SAS Advanced Programming Exam for SAS 9
Certification Provider: SAS Institute
Latest update: Dec 24,2024

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?

A . %put the value is "&&&dept";
B . %put the value is "&&&dept";
C . %put the value is "&&&dept";
D . %put the value is %quote (&&&dept);

Reveal Solution Hide Solution

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?

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

Reveal Solution Hide Solution

Question #13

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

Reveal Solution Hide Solution

Question #14

Which SAS procedure changes the name of a permanent format for a variable stored in a SAS data set?

A . DATASETS
B . MODIFY
C . FORMAT
D . REGISTRY

Reveal Solution Hide Solution

Question #15

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?

A . 1234
B . sales
C . 5678
D . null

Reveal Solution Hide Solution

Question #16

The following SAS program is submitted:

%let first=yourname;

%let last=first;

%put &&&last;

What is written to the SAS Log?

A . First
B . Yourname
C . &&First
D . &yourname

Reveal Solution Hide Solution

Question #17

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?

A . a is pig
B . a set cat
C . a is frog
D . a is bird

Reveal Solution Hide Solution

Question #18

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

A . proc sql;
Select * from class
Where age<(select stop_age from threshold);
Quit;
B . proc sql;
Modify table class
Delete where age<(select stop_age from threshold);
Quit
C . proc sql;
Delete from class
Where age<(select stop_age from threshold);
Quit;
D . proc sql;
Alter from class
Delete where age<(select stop_age from threshold);
Quit;

Reveal Solution Hide Solution

Question #19

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?

A . A report showing the names of the columns in each table in SASUSER
B . A report showing the number of columns in each table in SASUSER
C . A report showing the numeric columns in each table in SASUSER
D . A report showing the number of numeric columns in each table in SASUSER

Reveal Solution Hide Solution

Question #20

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?