SAS Components Different types

[ryanhawkeyejedi]

where Funded_DT <> "01JAN1900";

ERROR: Expression using not equals (^=) has components that are of different data types.

Im not sure what I need to do to get this to run without erroring. Thanks

[Reeza · Accepted solution]

You specify a date literal with an d at the end of the variable, otherwise SAS assumes that its just a character variable, and how would it know otherwise 😉

I personally prefer the NE rather than <> for not equals, but its a preference. I think at one time SAS didn't interpret it as not equals, so you may want to verify that it does in your version.

where Funded_DT ne "01JAN1900"d;

[SASKiwi]

where Funded_DT <> "01JAN1900"d;

[ryanhawkeyejedi]

Thank you both for your help...Im still a newbie. 🙂 I appreciate both quick responses! Happy Holidays!!!

[ndp]

Use where Funded_DT <> "01JAN1900"D; Hopefully you are using apprpriate option YEARCUTOFF

[ryanhawkeyejedi]

What is YEARCUTOFF?

[SASKiwi]

The YEARCUTOFF option sets the century for SAS dates if one is not specified. For example if you had used 01JAN00 instead of 01JAN1900 - does that mean 1900 or 2000?

In your case you are specifying the century so I don't think YEARCUTOFF applies.