filtering column of sas data table

Reply
Contributor
Posts: 40

filtering column of sas data table

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

Super User
Posts: 7,859

Re: filtering column of sas data table

Posted in reply to akhilesh_joshi
data want;
set have;
_var = input(substr(var,3),best.);
if 6 <= _var <= 16;
drop _var;
run;
---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 1 reply
  • 212 views
  • 0 likes
  • 2 in conversation