topic Re: Proc sql 'select' varialbes containing "somecharacters" in SAS Procedures

Proc sql 'select' variables containing "somecharacters"

Gjax21 — Fri, 20 Jul 2018 01:25:18 GMT

SAS 9.3

Is there a way to subset data where you select variables to include that have a certain number of letters occurring in them in a particular order?

For instance, I want to select, out of a long list of variables the ones ending in 'RR'

s1_dg_tif_FAD	s1_dg_tif_NAD	s1_dg_tif_RR

Re: Proc sql 'select' varialbes containing "somecharacters"

mkeintz — Fri, 20 Jul 2018 01:28:57 GMT

First us the metadata in dictionary.columns to identify the variables of interest, and save them as a space-separated list in a macrovar named VARLIST:

proc sql noprint;
  select distinct name into :varlist separated by ' '
  from dictionary.columns 
    where libname='WORK'and memname='HAVE'
	and name like "_RR";
quit;
%put &=varlist;

Then use that macrovar for your objective:

data want;
  set have (keep=&varlist);
run;

Re: Proc sql 'select' varialbes containing "somecharacters"

Gjax21 — Fri, 20 Jul 2018 01:31:10 GMT

Will give it a shot thanks

Re: Proc sql 'select' varialbes containing "somecharacters"

PGStats — Fri, 20 Jul 2018 05:49:16 GMT

to match names ending in "_RR", use the condition

trim(name) like "%^_RR" escape "^"

or the condition

prxmatch("/_RR$/i", trim(name))