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
Assume that I have a macro var that holds a list of dataset names. I then
use it for a merge:
Now I need to know if any of the dataset has missing record. Usually I
can do something like this:
merge a(in=a_) b(in=b_) c=(in=c_);
if not (a_ and b_ and c_) then put a_= b_= c_=;
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.