topic Re: Dropping some, not all, variables with the same prefix in SAS Programming

Dropping some, not all, variables with the same prefix

ama220 — Fri, 17 Mar 2023 14:51:26 GMT

Hello:

I have a set of variables that start with the same prefix. I would like to drop some of them.

E.g., Variables are AC1 AC2 AC3 AC4 ...... AC100.

I'd like to retain the first 10 ACx variables and delete the rest after that.

Thanks for your help!

PaigeMiller — Fri, 17 Mar 2023 14:53:55 GMT

drop ac11-ac100;

ama220 — Fri, 17 Mar 2023 15:40:18 GMT

Thanks! I was tried the same code but on a different dataset. No wonder it did not work earlier.