Data Step Delete Statement

[Ody]

Happy Turkey Day all,

I have the following code;

date master;

set master;

if field1 = field2 then delete field2;

run;

This is giving me the following error:

ERROR Expecting a ;.

ERROR The option or parameter is not recognized and will be ignored. 

I've probably been looking at this too long, considering its turkey day and im working, but could use another set of eyes. 

Thanks in advance. 🙂

[Reeza · Accepted solution]

Delete in SAS erases a row not a variable. You can't delete a variable, you can set it to missing though.

if field1=field2 then call missing(field2);

[Ody]

Thanks for the quick reply.

Makes sense.