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

Note! Following A00-212 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 Advanced Programming Questions and Answers

Question 1

The following SAS program is submitted:

proc contents data = testdata.one;

run;

Which one of the following SQL statements produces similar information about the column attributes as the above CONTENTS procedure?

Options:

A.

proc sql;

show testdata.one;

quit;

B.

proc sql;

describe testdata.one;

quit;

C.

proc sql;

show table testdata.one;

quit;

D.

proc sql;

describe table testdata.one;

quit;

Buy Now
Question 2

Given the following SAS data set ONE:

ONE

GROUP SUM

A 765

B 123

C 564

The following SAS program is submitted:

data _null_;

set one;

call symput(group,sum);

run;

Which one of the following is the result when the program finishes execution?

Options:

A.

Macro variable C has a value of 564.

B.

Macro variable C has a value of 1452.

C.

Macro variable GROUP has a value of 564.

D.

Macro variable GROUP has a value of 1452.

Question 3

The following SAS program is submitted:

%macro test(var);

proc print data = sasuser.class;

where age > &var;

run;

%mend;

Which type of parameter is the macro variable VAR?

Options:

A.

default

B.

keyword

C.

positional

D.

command