topic Re: Sas Help Dates in New SAS User

Sas Help Dates

UMR13 — Tue, 11 Jun 2019 18:39:15 GMT

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.

Re: Sas Help Dates

ebowen — Tue, 11 Jun 2019 18:50:06 GMT

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;

Re: Sas Help Dates

ebowen — Tue, 11 Jun 2019 18:51:23 GMT

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

Re: Sas Help Dates

UMR13 — Tue, 11 Jun 2019 19:02:42 GMT

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