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
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
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.