Advance SAS CertifIcation Exam Question 17

Which ODS statement option terminates output being written to an HTML rile?

A - END

B - QUIT

C - STOP

D - CLOSE

Answer: D

Question: 18

The SAS data set PETS is sorted by the variables TYPE and BREED.

The following SAS program is submitted:

proc print data = pets;

var type breed;

sum number;

run;

What is the result?

A - The SUM statement produces only a grand total of NUMBER.

B - The SUM statement produces only subtotals of NUMBER for each value of TYPE.

C - The SUM statement produces both a grand total of NUMBER and subtotals of NUMBER for

each value of TYPE.

D - Nothing is produced by the SUM statement; the program fails to execute.

 Contact Details :

K.Naveen SAS Trainer 
+91-9177856619 (INDIA) 
001-214-347-4655 (USA)
Knaveen.sas@gmail.com 
goodonlinetrainings@gmail.com  
For further details:
www.sasonlinetraining.training

Advance SAS CertifIcation Exam Question 16

The following SAS program is submitted:

data work.accounting;

set work.department;

length jobcode $ 12;

jobcode=’FAl’;

run;

The WORK.DEPARTMENT data set contains a character variable named JOBCODE with a

length of 5.

What is the result?

A - The length of the variable JOBCODE is 3.

B - The length of the variable JOBCODE is 5.

C - The length of the variable JOSBODE is 12.

D - The program fails to execute due to errors.

 Contact Details :

K.Naveen SAS Trainer 
+91-9177856619 (INDIA) 
001-214-347-4655 (USA)
Knaveen.sas@gmail.com 
goodonlinetrainings@gmail.com  
For further details:
www.sasonlinetraining.training

Advance SAS CertifIcation Exam Question 15

Given the SAS data set PRICES:

PRICES

prodid price producttype sales returns

K12S 5.10 NETWORK 15 2

B132S 2.34 HARDWARE 300 10

R18KY21.29 SOFTWARE 25 5

3KL8BY 6.37 HARDWARE 125 15

DY65DW 5.60 HARDWARE 45 5

DGTY23 4.55 HARDWARE 67 2

The following SAS program is submitted:

data hware inter soft;

set prices (keep = producttype price);

if price le 5.00;

if producttype = ‘HARDWARE’ then output HWARE;

else if producttype = ‘NETWORK’ then output INTER;

else if producttype = ‘SOFTWARE’ then output SOFT;

run;

How many observations does the HWARE data set contain?

A - 0

B - 2

C - 3

D - 4

 Contact Details :

K.Naveen SAS Trainer 
+91-9177856619 (INDIA) 
001-214-347-4655 (USA)
Knaveen.sas@gmail.com 
goodonlinetrainings@gmail.com  
For further details:
www.sasonlinetraining.training

Advance SAS CertifIcation Exam Question 14

Given the SAS data set AGES:

AGES

AGE

---------

The variable AGE contains character values. The following SAS program is submitted:

data subset;

set ages;

where age> 12;

run;

How many observations are written out to the data set SUBSET?

A - 0

B - 1

C - 2

D - 3

 Contact Details :

K.Naveen SAS Trainer 
+91-9177856619 (INDIA) 
001-214-347-4655 (USA)
Knaveen.sas@gmail.com 
goodonlinetrainings@gmail.com  
For further details:
www.sasonlinetraining.training