topic If Date1 is not equal to Date2, print "BAD" in Date2. in New SAS User

If Date1 is not equal to Date2, print "BAD" in Date2.

Thanyada — Tue, 05 Nov 2019 17:06:20 GMT

data date;

input date1 date2;

datalines;

25000 25000

25010 25000

25150 25150

;

I would like to use proc format or another method to print If date1 is not equal to date2, print "BAD" in date2.

how can I do with this situation?

Thank you for your assistance

Re: If Date1 is not equal to Date2, print "BAD" in Date2.

unison — Tue, 05 Nov 2019 17:17:44 GMT

Since Date1 and Date2 are date fields (numeric) you're going to have trouble printing "BAD" within the column Date2. You might try something like proc format on the difference? Format the value of 0 as "BAD". But either way you do it you're output will need to be in a character column.

-unison

Re: If Date1 is not equal to Date2, print "BAD" in Date2.

mkeintz — Tue, 05 Nov 2019 17:20:46 GMT

A format, whether from the SAS format library, or defined by a user can only be assigned to a variable, not to a combination of variables. So you would have to make a new variable signaling whether DATE1=DATE2. And if that is the case, you could assign that new variables a character value of 'BAD' or 'GOOD', and thereby avoid the need for a format entirely. I.e. making a new variable is the "another method" that I would suggest.

You can do this in a DATA step, with an IF test on the equality of date1 and date2, containing a THEN clause that conditionally assigns the desired value.

Re: If Date1 is not equal to Date2, print "BAD" in Date2.

ballardw — Tue, 05 Nov 2019 20:47:29 GMT

With existing numeric date values then one approach to achieve your goal is to 1) assign a "special" value to the date2 variable and 2) have a custom format to display the desired text. One way:

proc format library=work;
   value baddate
   .B='Bad Date'
   other = [date9.]
   ;
run;
data have;
   input date1 date2;
   if date1 ne date2 then date2=.B;
   format date1 date9.  date2 baddate.;
datalines;
25000 25000
25010 25000
25150 25150
;
proc print data=have;
run;

The .B is a "special missing" value. SAS allows 27 special missing values ._ and .A through .Z. The special missing do not get used as numeric values like normal missing but you can have different display values to display different results for special cases.