Sas Help Dates

[UMR13]

Hello, 

I am relatively new to SAS 

I have three data columns with completion dates over 3 days. Some days do not have a date and some do which would indicate completion. How do i check which cells have dates completed across the board for all three days.  

Thank you. 

[ebowen · Accepted solution]

If you're looking to find the observations in your data that have missing values, you could use the cmiss function to count the number of missing values in the date variables and then output those observations where there are more than one. It would look something like this:

data out;
set in;
if cmiss(date1,date2,date3) > 0 then output;
run;

[ebowen]

Or you could look for observations with no missing values by asking for:
if cmiss(d1,d2,d3) = 0 then output;

[UMR13]

Thank you very much for your speedy reply. This helped Tremendously.