filtering column of sas data table

[akhilesh_joshi]

Hi All,

I have a data table. In a particular column of the table, I have values ranging from x_1 to x_16. I want to subset the data table by having values only from x_6 to x_16 in the column. Is there a way I can achieve it by using Macro?

Would appreciate any help in this problem.

Thanks and regards,

Akhilesh

[Kurt_Bremser]

data want;
set have;
_var = input(substr(var,3),best.);
if 6 <= _var <= 16;
drop _var;
run;