topic Re: How to delete observations in SAS Procedures

How to delete observations

Radwan — Tue, 26 Feb 2019 08:07:36 GMT

Hello every one

I have a small issue which is How to exclude some industry from my sample ?

as we know that SIC variable consists of numbers and alphabets (e.g., K1, G05, .. etc)

when i use IF sentence

data real; set rem;
if SIC=j66  then delete;
run;

it does not work

i get this message

NOTE: Variable j66 is uninitialized.

please how can do it

SASKiwi — Tue, 26 Feb 2019 08:17:03 GMT

If you don't put quotes around a value then SAS assumes it is a variable hence the note about the variable not initialised:

data real; set rem;
if SIC='j66'  then delete;
run;

RW9 — Tue, 26 Feb 2019 08:16:57 GMT

You need to put the string J66 in quotes exactly as it appears in the data:

data real; 
  set rem;
  if sic='J66' then delete;
run;

Or what may be quicker:

data real; 
  set rem (where=(sic ne 'J66'));
run;

Radwan — Tue, 26 Feb 2019 08:30:07 GMT

thanks
i got it
it works

Radwan — Tue, 26 Feb 2019 08:30:33 GMT

thaaaaaaaanx
it works