topic selecting variables with similar suffix in SAS Programming

selecting variables with similar suffix

Emma_at_SAS — Thu, 22 Apr 2021 17:49:42 GMT

In my dataset, I want to create three subsets of variables with the suffix [x] [y] [z].

If these were prefix, I knew how to do it in a data set and using (keep=prefix:). Is there an easy way for suffix?

Thanks

Re: selecting variables with similar suffix

PeterClemmensen — Thu, 22 Apr 2021 17:58:31 GMT

Not as easy as the : operator for the prefix.

However, it can be done. A Google search will probably give you a few ways quickly.

Re: selecting variables with similar suffix

sbxkoenk — Thu, 22 Apr 2021 18:04:44 GMT

Hello,

Unfortunately there's no easy way with a wildcard.

You can do this (to be adapted and applied to your situation):

proc sql noprint;
 select distinct name into: names separated by ' '
 from dictionary.columns 
 where     libname='SASHELP' 
       and memname='CLASS'
       and upcase(name) like '%HT';
quit;
%PUT &=names;

data want;
 set sashelp.class(drop=&names);
run;
/* end of program */

Cheers,

Koen