A00-212 Practice Exam Questions with Answers SAS Advanced Programming Certification

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?

The following SAS program is submitted:

%let first = yourname;

%let last = first;

%put &&&last;

Which one of the following is the result in the log of the %PUT statement?

Given the following SAS data set ONE:

ONE

COUNTRY CITY VISIT

USA BOSTON 10

UK LONDON 5

USA DALLAS 10

UK MARLOW 10

USA BOSTON 20

UK LONDON 15

USA DALLAS 10

The following SAS program is submitted:

proc sql;

select country, city, sum(visit) as TOTAL

from one

group by country, city

order by country, total desc;

quit;

Which one of the following reports is generated?

Given the following partial SAS log:

NOTE: SQL table SASHELP.CLASS was created line

Create table SASHELP.CLASS(bufsize=4096)

(

Name char(8);

Gender Char(1);

Age num;

Height num;

Weight num

);

Which SQL procedure statement generated this output?

The following SAS program is submitted:

data temp;

array points{3,2}_temporary_ (10,20,30,40,50,60);

score = points{2,1}

run;

Which one of the following is the value of the variable SCORE in the data set TEMP?

Which one of the following is true regarding the KEEP statement?

The following SAS program is submitted:

%let value=9;

%let add=5;

%let newval=%eval(&value/&add);

What is the value of the macro variable NEWVAL?

The SAS set WORK CHECK has an index on the variable Code and the following SAS program is submitted.

proc sort data=WORK.CHECK;

by Code;

run;

What describes the result of submitting SAS program?

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?

This question will ask you to provide missing option.

Which option is required to complete the program correctly?

The following SAS program is submitted:

date view=sauser.ranch;

describe;

run;

What is the result?

The SAS data set TEMP has the following distribution of values for variable A:

A Frequency

1 500,000

2 500,000

6 7,000,000

8 3,000

Which one of the following SAS programs requires the least CPU time to be processed?

The following SAS program is submitted:

%let first=yourname;

%let last=first;

%put &&&last;

What is written to the SAS Log?

CORRECT TEXT

The following SAS program is submitted:

%macro check(num=4);

%let result=%sysevalf(&num+0.5);

%put result is &result;

%mend;

%check(num=10)

What is the written to the SAS log?

Given the following SAS program:

proc sql;

select product, type, sum(sales) as revenue

from one

group by product, type;

quit;

Which one of the following clauses should be added to the program to sort the output by PRODUCT and decreasing REVENUE?

Given the following SAS program:

What will be the output from the PRINT Procedure?

This question will ask you to provide a missing reference.

Given the SAS data set SASUSER HIGHWAY:

The following SAS program is submitted:

What macro variable reference completes the program to create the WORK.NOT and WORK SERIOUS data sets?

Which MACRO option is responsible for this partial SAS log?

When is it appropriate to create indexes on a SAS data set for efficient processing?

Which option forces the use of a specific index from a data set?

Given the following SAS data set SASUSER.HIGHWAY:

SASUSER.HIGHWAY

STEERING SEATBELT SPEED STATUS COUNT

absent no 0-29 serious 31

absent no 0-29 not 1419

absent no 30-49 serious 191

absent no 30-49 not 2004

absent no 50+ serious 216

The following SAS program is submitted:

%macro highway;

proc sql noprint;

select count(distinct status)

into :numgrp

from sasuser.highway;

%let numgrp = &numgrp;

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 by the above program?

The SAS data set ONE consists of five million observations and has 25 variables.

Which one of the following SAS programs successfully creates three new variables

TOTREV, TOTCOST, and PROFIT and requires the least CPU time to be processed?