Pre-Summer Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Note! Following A00-211 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

Verified By IT Certified Experts

CertsTopics.com Certified Safe Files

Up-To-Date Exam Study Material

99.5% High Success Pass Rate

100% Accurate Answers

Instant Downloads

Exam Questions And Answers PDF

Try Demo Before You Buy

Certification Exams with Helpful Questions And Answers

SAS Base Programming for SAS (r) 9 Questions and Answers

Question 1

Given the SAS data set PRICES:

PRICES

Prodid priceproducttypesalesreturns

K1255.10NETWORK152

B132S 2.34HARDWARE30010

R18KY2 1.29SOFTWARE255

3KL8BY 6.37HARDWARE12515

DY65DW 5.60HARDWARE455

DGTY23 4.55HARDWARE672

The following SAS program is submitted:

data hware inter cheap;

set prices(keep = productype price);

if producttype = ‘HARDWARE’ then output hware; else if producttype = ‘NETWORK’ then output

inter; if price le 5.00;

run;

if producttype = ‘HARDWARE’ then output hware; else if producttype = ‘NETWORK’ then output

inter; if price le 5.00;

run;

How many observations does the HWARE data set contain?

Options:

A.

0

B.

2

C.

3

D.

4

Buy Now
Question 2

The following SAS program is submitted:

data work.totalsales;

set work.monthlysales(keep = year product sales);

retain monthsales {12} ;

array monthsales {12} ;

do i = 1 to 12;

monthsales{i} = sales;

end;

cnt + 1;

monthsales{cnt} = sales;

run;

The data set named WORK.MONTHLYSALES has one observation per month for each of five years for a total of 60 observations.

Which one of the following is the result of the above program?

Options:

A.

The program fails execution due to data errors.

B.

The program fails execution due to syntax errors.

C.

The program runs with warnings and creates the WORK.TOTALSALES data set with 60 observations.

D.

The program runs without errors or warnings and creates the WORK.TOTALSALES data set with 60 observations

Question 3

The following SAS program is submitted:

data WORK.OUTDS;

do until(Prod GT 6);

Prod + 1;

end;

run;

What is the value of the variable Prod in the output data set?

Options:

A.

(missing)

B.

6

C.

7

D.

Undetermined, infinite loop.