topic Re: delete rows in SAS Procedures

delete rows

sasphd — Tue, 11 Nov 2014 17:58:15 GMT

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.

Re: delete rows

Astounding — Tue, 11 Nov 2014 18:50:12 GMT

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.

Re: delete rows

art297 — Tue, 11 Nov 2014 19:17:01 GMT

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;