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?
data | subsample2; |
set subsample1; | |
if SIC between 4900 and 4999 or | |
6000 and 6999 then delete; |
run;
Try this
data subsample2;
set subsample1;
if 4900 le SIC le 4999 or
6000 le SIC le 6999 then delete;
run;
Try this
data subsample2;
set subsample1;
if 4900 le SIC le 4999 or
6000 le SIC le 6999 then delete;
run;
try:
if 4900<=sic<=4999 or 6000<=sic<6999 then delete;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.