Click on the Comments to view the Answers

Wednesday, January 27, 2010


The following SAS program is submitted:

data work.passengers;
if OrigPassengers = . then OrigPassengers = 100;
TransPassengers = 100;
OrigPassengers = .;
NonPaying = 10;
TotalPassengers = sum (OrigPassengers, TransPassengers);

Which one of the following is the value of the TOTALPASSENGERS variable in the output data set?

A. 100
B. 110
C. 200
D. . (missing numeric value)


SASGuru said...

Answer: A

Sum function ignores missing value

Anonymous said...

I think answer is C bcoz of the IF condition which says that if origpasseger is missing then its value is 100.

moneybiz said...

I think its A since, the origpasseger in if condition is being replace with the missing value.

Munni said...

Yes, it is true. Answer is "A". If the same IF statement is used after the statement: "OrigPassengers = .;" then the answer would be "C".

Ravi Kishore said...

Answer is A
we are using sum function it ignores the missing value.

Rujuta........ said...

A. 100

siva said...

Answer A

Unknown said...

Answer A

Ryan Lo said...

Answer is A.

yuvraj said...

Answer is A.

kinnari said...

Answer is A as Sum functions ignores missing values

niit said...

Answer is D

Stevina Rumao said...

Ans A

Pandu Krishna said...
This comment has been removed by the author.
Pandu Krishna said...


H. C. said...


Harsh Mohan said...

For latest and updated SAS certification dumps in PDF format contact us at
Refer our blog for more details

Chelsea Stone said...


rob said...

The answer is D. Sum of a missing value is missing, adding 100 to that you still have a missing value (see question 22 in the official SAS practice exam.

Post a Comment

Technology Top Blogs On our way to 1,000,000 rss feeds - Blog Directory - blogarama - the blog directory Blog Directory

SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.

Other brand and product names are trademarks of their respective companies.

This blog is not responsible for any kind of copyright violation. This blog just collects the links hosted or posted by other servers/people/search engines.The creator of this page or the ISP(s) hosting any content on this site take no responsibility for the way you use the information provided on this site.If anybody has any copyright claim on it and doesn’t wish the information provided to be shown on our site, please do respond to this email. We shall remove them off immediately. Any inconvenience is regretted. Please do mention your exact grievance/problems with respect to certain third party links. We assure you that appropriate action will be taken off. Thank you