topic if-then in SAS Programming

if-then

pchen002 — Sat, 30 Sep 2017 08:27:05 GMT

The following SAS program is submitted:

data work.passengers;

if OrigPassengers = . then

OrigPassengers = 100;

TransPassengers = 100;

OrigPassengers = .;

TotalPassengers = sum (OrigPassengers, TransPassengers) +0;

run;

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

Answer is 100, why not 200??

Please help, thanks!!!

Re: if-then

Norman21 — Sat, 30 Sep 2017 08:31:01 GMT

Missing + 100 + 0 = 100

If you move your IF statement further down, the answer will be 200.

Re: if-then

Astounding — Sat, 30 Sep 2017 12:36:32 GMT

Statements within the DATA step execute in order. Leaving out TransPassengers from the analysis, that means:

(1) set OrigPassengers to 100

(2) set OrigPassenters to .

(3) compute TotalPassengers

At the time TotalPassengers is computed, OrigPassengers is missing.

Re: if-then

Kurt_Bremser — Sat, 30 Sep 2017 15:54:28 GMT

@pchen002 wrote:

The following SAS program is submitted:

data work.passengers;

if OrigPassengers = . then

OrigPassengers = 100;

TransPassengers = 100;

OrigPassengers = .;

TotalPassengers = sum (OrigPassengers, TransPassengers) +0;

run;

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

Answer is 100, why not 200??

Please help, thanks!!!

Why should it be 200? In the sum() function, missing values are considered zero.

Start reading the f*cking documentation, your continuing questions on extremely simple issues start to reveal you as a person with an allergy to think on your own.

Re: if-then

Andygray — Sat, 30 Sep 2017 17:33:04 GMT

@pchen002 Although this is a open technical forum, Kindly do not consider this as school homework forum or education forum. The spirit of the discussions should be kept interesting for everybody, which means both the original poster as well as for responders. The questions that you post will add really no value to many if not all.

Re: if-then

Reeza — Sat, 30 Sep 2017 23:07:08 GMT

Ok... @Kurt_Bremser I think there's a bit of piling on here that needs to stop. Not that the point isn't correct but this seems to cross over the considerate/polite boundary. Please remember that you're not required to respond and that's the best way to not support this type of behaviour. And yes, I've done this myself at times, so I do get it 😉

@pchen002 please use some consideration in your posts. Here's a post that explains how to post good questions https://stackoverflow.com/help/how-to-ask

If you're genuinely attempting to learn please show an attempt and you'll find a lot of support and help. But so far, you've posted questions, not responded to follow ups and the questions are literally copy and paste from whatever study material you're using.

And another point - good study material explains the examples/questions and doesn't depend on the free help of others. Consider the SAS certification guide which has fully explained problems and examples. It's worth the small price, or consider checking with your University library or Safari tech books which have the guides.

Good Luck.

Re: if-then

pchen002 — Sun, 01 Oct 2017 01:36:21 GMT

Thank you!

Re: if-then

pchen002 — Sun, 01 Oct 2017 01:36:34 GMT

Understood, thank you!!!