topic pick a list of variables using strings in SAS Programming

pick a list of variables using strings

rykwong — Wed, 12 Jul 2017 16:38:29 GMT

Dear SAS communities

I can use hx_: to pick out all the variables with names starting with "hx_"

but is there a way to pick out all the variables with names that end with some specific text? for example: I want to pick out all the variables "diabetes_year", "ami_year", "menopause_year" by using "_year", is there such code?

thanks

Raymond

Re: pick a list of variables using strings

art297 — Wed, 12 Jul 2017 16:43:03 GMT

You'd have to show where you are doing the task but, more than likely, you can use the reverse function, e.g.,

if reverse(varname) =: 'reay_';

Art, CEO, AnalystFinder.com

Re: pick a list of variables using strings

Tom — Wed, 12 Jul 2017 17:08:04 GMT

There is no way to do specify a variable list based on the ending of the name.

You could build a list of names by querying the metadata of the data source.

proc contents data=have noprint out=contents; run;
proc sql noprint;
%let varlist=;
select varnum,name
  into :dummy,:varlist separated by ' '
  from contents
  where upcase(name) like '%^_YEAR' escape '^'
  order by varnum
;
quit;
data want ;
  set have ;
  max_year_value = max(of . &varlist );
run;

Re: pick a list of variables using strings

Reeza — Wed, 12 Jul 2017 17:24:23 GMT

Not directly. A lazy way is to specify all numeric variables and store your results in a table. Then you can filter the results easily using the code from @art297 to filter the results.

If you want to limit the results before hand you can use the solution from @Tom