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.
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;
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.
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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.