topic Re: Removing observations in SAS Programming

Removing observations

wschnell1 — Thu, 10 Oct 2013 02:44:11 GMT

Hi I have a data set and would like to remove certain firms:

Firms are identified by the SIC variable.

I would like to remove all firms between 4900-4999 and 6000-6999

How does the following code look?

run;

Mit — Thu, 10 Oct 2013 02:52:01 GMT

Try this

data subsample2;

set subsample1;

if 4900 le SIC le 4999 or

6000 le SIC le 6999 then delete;

run;

Linlin — Thu, 10 Oct 2013 02:54:41 GMT

try:

if 4900<=sic<=4999 or 6000<=sic<6999 then delete;