11-03-2016 11:36 AM
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,
11-03-2016 11:49 AM
data want; set have; _var = input(substr(var,3),best.); if 6 <= _var <= 16; drop _var; run;