topic Re: Removing/Deleting Observations in SAS Programming

Removing/Deleting Observations

holy9ner — Mon, 27 Jun 2016 14:50:36 GMT

data reg.regnoouttest;
set reg.regnoout;
delete point {4 30 157 163 164 165 167 171};
run;

i am trying to run the this code and it tells me that I have an syntax error, and is expecting a semicolon. I do not understand why this is happening. I am literlaly typing this word for worf from an example on sas webstie. Can anyone help

Re: Removing/Deleting Observations

Reeza — Mon, 27 Jun 2016 15:17:38 GMT

Really? Post the link please.

It it should be

if point in (list of values here) then delete;

Re: Removing/Deleting Observations

howarder — Mon, 27 Jun 2016 20:04:12 GMT

I believe that the "delete point" portion of the code is only used in the SAS\IML product. Try using the following:

if point in (4 30 157 163 164 165 167 171) then delete;

Re: Removing/Deleting Observations

LinusH — Wed, 29 Jun 2016 13:10:20 GMT

Or a bit more efficient:

where point not in (4 30 157 163 164 165 167 171);