topic Mathematical Comparison Operators in SAS Programming

Mathematical Comparison Operators

twildone — Mon, 10 May 2021 22:30:05 GMT

Hi....I am trying to delete records when the Withdrawn Date is "less then" the Term Start Date. The code below gives me the right output. Can anyone explain to me why the ">" in this context is referring to "less than". Thanks

data Want;
	set Have;
		if 'Withdrawn Date'n > 'Term Start Date'n then delete;
run;

Re: re: Mathematical Function

ballardw — Mon, 10 May 2021 22:13:01 GMT

Because > is read "greater than" from left to right.

"Less than" would look like

if 'Term Start Date'n < 'Withdrawn Date'n  then delete;

A way to remember the "wide" end of the > or the < is the "Larger" value when true.

Re: re: Mathematical Function

Reeza — Mon, 10 May 2021 22:29:39 GMT

Maybe your logic is backwards. Your code is deleting records where the withdrawn date is after the term start date. It may only work by accident....so I'd be double checking things.

Re: Mathematical Comparison Operators

Reeza — Mon, 10 May 2021 22:30:50 GMT

FYI - I changed the subject line of your question, as you're really asking about mathematical comparison operators.
https://documentation.sas.com/doc/en/lrcon/9.4/p00iah2thp63bmn1lt20esag14lh.htm#n10lfrm906gpv7n1t7fue0g1ayqz

Re: re: Mathematical Function

twildone — Mon, 10 May 2021 22:55:14 GMT

Hi....when I run the code below, I am getting all the records where the Withdrawn Date is LESS than the Term Start Date. But am I correct that the if statement is processed from left to right?

data Want;
	set Have;
		if 'Withdrawn Date'n < 'Term Start Date'n then delete;
run;

Re: re: Mathematical Function

Reeza — Mon, 10 May 2021 23:10:14 GMT

Remember you're deleting records that MATCH your condition.
So anything left in the data set is the OPPOSITE of the comparison.

Re: re: Mathematical Function

SASKiwi — Mon, 10 May 2021 23:11:00 GMT

In your case it doesn't matter which direction you read your IF statement.

"Withdrawn Date < Term Start Date then delete" is equivalent to "Term Start Date > Withdrawn Date then delete"

The result set will be the same.

Re: re: Mathematical Function

twildone — Tue, 11 May 2021 16:52:13 GMT

Hi...I was able to track down where the problem is. The missing entries in the Withdrawn Date variable has decimal rather than blank space. I will double check where it has changed to decimal from a blank space. Thanks.

Re: re: Mathematical Function

Reeza — Tue, 11 May 2021 16:57:23 GMT

SAS shows numeric missing as a period, not as a blank space.