topic Re: Why zero observation ? in SAS Programming

Why zero observation ?

Attyslogin — Wed, 22 Jun 2016 13:44:43 GMT

why output of this program contains no observation ? can anyone explain it to me...thanks

Given data :

money dataset has 5 observations.

people dataset has observations

My program is :

data empsal;

set money (in=money) people(in=people);

if money and people;

run;

empsal contains 0 observations...why so ? 😞

Re: Why zero observation ?

RW9 — Wed, 22 Jun 2016 14:01:00 GMT

You are "setting" the second dataset After the first, there is no merge, hence:

if money and people;

Is never true, the records all come from money in the first instance, and then from people in the second, never both. Perhaps you mean to merge the data?

Re: Why zero observation ?

Attyslogin — Wed, 22 Jun 2016 14:22:04 GMT

no with respect to merge i know how this program gonna behave....thanks for your valuable response.

Understood the concept !