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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.