topic Re: Data Step Delete Statement in SAS Programming

Data Step Delete Statement

Ody — Thu, 26 Nov 2015 22:28:28 GMT

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. 🙂

Re: Data Step Delete Statement

Reeza — Thu, 26 Nov 2015 22:36:46 GMT

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);

Re: Data Step Delete Statement

Ody — Thu, 26 Nov 2015 22:40:07 GMT

Thanks for the quick reply.

Makes sense.