filtering column of sas data table

akhilesh_joshi — Thu, 03 Nov 2016 15:36:42 GMT

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

Re: filtering column of sas data table

Kurt_Bremser — Thu, 03 Nov 2016 15:49:14 GMT

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

topic filtering column of sas data table in SAS Programming

filtering column of sas data table

Re: filtering column of sas data table