Date:         Wed, 7 Apr 2010 17:20:56 -0400
Reply-To:     Ya Huang <ya.huang@AMYLIN.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ya Huang <ya.huang@AMYLIN.COM>
Subject:      Merge and test which data has missing without knowing the dataset
              name?

Hi there,

Assume that I have a macro var that holds a list of dataset names. I then
use it for a merge:

data all;
 merge &dslist;
by keys;
run;

Now I need to know if any of the dataset has missing record. Usually I
can do something like this:

data all;
 merge a(in=a_) b(in=b_) c=(in=c_);
by keys;
if not (a_ and b_ and c_) then put a_= b_= c_=;
run;

From the log, I can tell which dataset has missing records.

But for a macro var &dslist, I will not know how many datasets are
there, let alone write a if statement. So, easiy way to tell which
data has missing record?

I probably can use meta data to construct a dslist with in= in it,
I'm looking for easier way.

Thanks

Ya