topic How to keep variables end(not begin ) with same characters in SAS Procedures

How to keep variables end(not begin ) with same characters

George_S — Fri, 30 Mar 2012 17:53:21 GMT

data one;

input a b c a_123 b_123 x_123 y_123 z_123;

run;

data two;

set one;

keep a_123 b_123 x_123 y_123 z_123;

run;

My question is if there are too much variables end with '_123'(I can't list all of them here),how to keep these variables in an easy way?

I know ':' operator can keep variables start with special characters but not end with.

Thanks!

Re: How to keep variables end(not begin ) with same characters

Linlin — Fri, 30 Mar 2012 18:01:24 GMT

How about:

(note: libname and memname must be capital letters)

proc sql noprint;

select name into : names separated by ' '

from dictionary.columns

where libname='WORK' and memname='HAVE' and upcase(name) like '%_123' ;

quit;

data want;

set have(keep=&names);

run;

Linlin

How to keep variables end(not begin ) with same characters

kuridisanjeev — Wed, 04 Apr 2012 09:04:10 GMT

Just curious....

How to do this in Data Step???

How to keep variables end(not begin ) with same characters

Haikuo — Wed, 04 Apr 2012 11:38:58 GMT

You could have more than one data step approaches. For one, you could use meta view for data step, such as sashelp.vcolumn, and use a combination of substr() and length to obtain the variable names. For two, you could use array vname to grab the variable names that meets criteria.

You could also use proc contents instead of SQL to get the variables names.

However, in case, by supporting operators such as 'like', 'contains', SQL is more native to the job.

Haikuo