I have a dataset that has variables named Amin to Amax. E.g. A121, A122 up to A314. min and max are created in some procedure before. I would like automatically to do the following 1) to keep variables greater than e.g. A150 i.e. A150, A151, up to A(max(xx)) i.e. Data newdata; set olddata; keep A150-Amax; run; 2) drop all above e.g. A180 i.e. keep Amin - A180 i.e. Data newdata; set olddata; keep Amin-A180; run; Thanks
... View more