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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.