|
View previous topic :: View next topic
|
| Author |
Message |
srinivaspsai
New User
Joined: 22 Jul 2010
Posts: 1
Location: pune
|
|
|
|
Hi,
I have a requirement where i need to read a sas dataset having 4 variables and if any missing values are present in any of the fields then an email will be genrated stating the same.
Is there any function or logic how to do the same? |
|
| Back to top |
|
 |
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
| Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA
|
|
|
|
Are the 4 variables all numeric? If so, this untested code should get you started:
| Code: |
DATA _NULL_;
SET DDNAME.SASDB END=EOF;
RETAIN MISSFLAG 0 ;
IF VAR1 = . OR VAR2 = . OR VAR3 = . OR VAR4 = . THEN MISSFLAG = 1;
IF EOF AND MISSFLAG = 1 THEN DO;
<<send the email logic>>
END;
|
As always with SAS, though, there are other ways to do it. |
|
| Back to top |
|
|
|
|
