Online File

How to use this page

---

Rick Aster: Professional SAS Programming Secrets: Contents

Chapter 9
Program 9h
Exception data set

---

*
  Professional SAS Programming Secrets
  Program 9h
  Exception data set
*;
data work.planetdensity work.planetx;
   set work.planet;
   if mass < 0 then mass = .;
   if radius < 0 then radius = .;
   else diameter = radius*2;
   if radius > 0 and not missing(mass) then
       density = mass/(4/3*constant('pi')*radius**3)*10e9;
   else density = .;
   if radius >= 100 and mass >= .0005 and density > .01 then
       output work.planetdensity;
   else output work.planetx;
run;