topic Re: IF-THEN/DELETE on SAS university edition not working? in SAS Studio

IF-THEN/DELETE on SAS university edition not working?

syk — Tue, 12 Sep 2017 05:28:05 GMT

What am I doing wrong? The statement is exactly the same format from the documentations I've read and the DELETE statement should be blue but it's greyed out.

Re: IF-THEN/DELETE on SAS university edition not working?

Tom — Tue, 12 Sep 2017 05:33:27 GMT

What is the question? Are you really talking about what COLOR the text is in the program editor?

If you want to see if the code works, run it.

Re: IF-THEN/DELETE on SAS university edition not working?

syk — Tue, 12 Sep 2017 05:37:18 GMT

I've ran the code the delete statement is definitely not processing through, and as you can see from the captured image the delete statement is not even recognized as a sas statement.

Re: IF-THEN/DELETE on SAS university edition not working?

Miracle — Tue, 12 Sep 2017 05:41:36 GMT

By the way, your sum statement should be

Total=sum(qtr1,qtr2,qtr3,qtr4);

Re: IF-THEN/DELETE on SAS university edition not working?

Tom — Tue, 12 Sep 2017 05:57:47 GMT

@syk wrote:

I've ran the code the delete statement is definitely not processing through, and as you can see from the captured image the delete statement is not even recognized as a sas statement.

You posted a photograph of an editor screen. The color coding that an editor does is just the editor's attempt to make your code look pretty. The editor does not actually contain the SAS parser/compiler or the SAS macro processor.

If you want to see whether the SAS code is correct you need to actually run the code.

If you want to tell whether the DELETE statement ran we would need to see the LOG to see how many observations the data step read in and how many it wrote. We would also need to see the data since it could very well be that no obervations meet the IF condition so that the DELETE statement will never run.

If you had really typed something other than delete (perhaps de1ete) then you would have seen an error message in the SAS log that the statement was invalid.

Re: IF-THEN/DELETE on SAS university edition not working?

syk — Tue, 12 Sep 2017 06:02:19 GMT

I've tried both conditions for the IF statement to produce 50 observations (the question wanted 50) but when I ran it again with the counter-logic it produced 88 observations (initial number of observations) so the delete statement did not work. And no I did not spell delete incorrectly. And as you can see for some reason when the delete statement is within the IF statement it's not picked up by the compiler, but by itself it is..

Re: IF-THEN/DELETE on SAS university edition not working?

Tom — Tue, 12 Sep 2017 06:03:11 GMT

@syk wrote:

I've tried both conditions for the IF statement to produce 50 observations (the question wanted 50) but when I ran it again with the counter-logic it produced 88 observations (initial number of observations) so the delete statement did not work. And no I did not spell delete incorrectly.

That is a totally different question.

Why would you expect that running that data step would produce 50 observations?

There is nothing in the code that would do that. It might do that if there are exactly 50 observations that do NOT get deleted by that IF statement. But we would need to see the data.

Re: IF-THEN/DELETE on SAS university edition not working?

Tom — Tue, 12 Sep 2017 06:06:58 GMT

Ignore the colors. Look at the log. SAS will put an erorr message in the log is you ask it to run invalid code. Until you actually submit the code to run the editor is just an editor. It doesn't really know whether you are typing SAS code or your shopping list.

Re: IF-THEN/DELETE on SAS university edition not working?

syk — Tue, 12 Sep 2017 06:11:58 GMT

You're right the statement is really meaningless I was just simply showing the compiler is not picking up the delete statement, and the log had no errors.

if Total>=50 and NumQtrs=4; <--- this statement produced 50 observations like the questioni wanted.

so shouldn't

if Total<50 and NumQtrs^=4 then delete;

produce 50 observations as well?

Re: IF-THEN/DELETE on SAS university edition not working?

Tom — Tue, 12 Sep 2017 06:16:21 GMT

@syk wrote:

You're right the statement is really meaningless I was just simply showing the compiler is not picking up the delete statement, and the log had no errors.

if Total>=50 and NumQtrs=4; <--- this statement produced 50 observations like the questioni wanted.

so shouldn't

if Total<50 and NumQtrs^=4 then delete;

produce 50 observations as well?

No. Apply DeMorgan's law. https://en.wikipedia.org/wiki/De_Morgan%27s_laws

NOT (A and B) is the same as (NOT A) or (NOT B).

Re: IF-THEN/DELETE on SAS university edition not working?

Kurt_Bremser — Tue, 12 Sep 2017 06:42:41 GMT

DeMorgan is one of the foundations of programming. As soon as one touches the first composite condition, one does not only have to know DeMorgan's laws, one needs to internalize them to the point where the hands automatically type the correct conversion.

@syk: the coloring in the SAS enhanced editor is not complete; some keywords are not caught correctly. Follow my Maxims 4 and 2.

Re: IF-THEN/DELETE on SAS university edition not working?

Reeza — Tue, 12 Sep 2017 15:14:43 GMT

if Total>=50 and NumQtrs=4; <--- this statement produced 50 observations like the questioni wanted.

so shouldn't

if Total<50 and NumQtrs^=4 then delete;

produce 50 observations as well?

No, you have two conditions joined by an AND so you theoretically have 4 different possibilities (2X2)

Total >= 50 and NumQtrs=4

Total < 50 and NumQtrs=4

Total >= 50 and NumQtrs^=4

Total < 50 and NumQtrs^=4

Re: IF-THEN/DELETE on SAS university edition not working?

ballardw — Tue, 12 Sep 2017 17:28:41 GMT

If Total is missing then Total<50 is True.

If NumQtrs is missing then NumQtrs ^= 4 is True.

So if you have missing values for the selection variables you may have more or fewer results than you think you should.