delete rows

[sasphd]

I want to delete rows.

this is my program

data flux0;

set flux;

if mtna='T' then delete;

run;

I have this message???????????????

ERROR: LIKE operator requires character operands.

[Astounding]

Nope.  No way.  Didn't happen.  That message could not possible emerge from that DATA step.

Check for a missing semicolon on the statement before the DATA statement.  Make sure you have a blank before the word "then".  Otherwise, you will just have to post your log.

Good luck.

[art297 · Accepted solution]

I'm going to guess that you left off a colon (i.e., =: rather than =), but that your problem is that you are trying to delete records that contain .T, not the character value 'T'.

Try the following:

data flux0;

  set flux;

  if mtna =.T then delete;

run;