topic Re: SAS Components Different types in SAS Programming

SAS Components Different types

ryanhawkeyejedi — Tue, 22 Dec 2015 20:51:00 GMT

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

Re: SAS Components Different types

Reeza — Tue, 22 Dec 2015 21:02:24 GMT

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;

Re: SAS Components Different types

SASKiwi — Tue, 22 Dec 2015 21:02:38 GMT

where Funded_DT <> "01JAN1900"d;

Re: SAS Components Different types

ryanhawkeyejedi — Tue, 22 Dec 2015 21:06:20 GMT

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

Re: SAS Components Different types

ndp — Tue, 22 Dec 2015 21:06:39 GMT

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

Re: SAS Components Different types

ryanhawkeyejedi — Tue, 22 Dec 2015 21:08:38 GMT

What is YEARCUTOFF?

Re: SAS Components Different types

SASKiwi — Tue, 22 Dec 2015 23:25:46 GMT

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.