topic Macro in Prxchange didnt' work in SAS Programming

Macro in Prxchange didnt' work

ybz12003 — Mon, 15 Mar 2021 15:24:17 GMT

Hello Experts,

I would like to replace 'CLEFT LIP / CLEFT PALATE / CLEFT PALETTE' with 'UAIRWAY' in the sample dataset 'Have.' I created a macro list 'Uairway_name.' I found the macro could not be recognized in the Prxchange command. Please help me to fix it. Also, is there any limitation for the text length in the Prxchange? My real texts need to be replaced are over 500 character long.

data Have;
      infile datalines delimiter='/';
  input Disease : $300.  ;
datalines;
	CLEFT PALETTE, ADHD, CHRONIC RHINITIS /
	HAVING A GTUBE, ENCEPHALOMALACIA, HIDRADENITIS, AUTISM/
	ENCEPHALOPATHY, GTUBE SUPPORTIVE, HEP C EXPOSURE /
	AUTISM SPECTRUM, SPEECH & COGNITIVE DELAY, CLEFT LIP
;
run;

data AIRWAY_Name;
  infile datalines dsd;
  input  Name : $50. ;
datalines;
	CLEFT LIP, 
	CLEFT PALATE,
	CLEFT PALETTE
	;
run;

options noquotelenmax;
proc sql;
	select trim(Name) into : Uairway_name separated by '|'  from AIRWAY_Name;
quit;

%put &Uairway_name;

data dataout;
	set Have;
	Disease2 = prxchange('s/[^,]*(&Uairway_name.)[^,]*/UAIRWAY/i',              -1, Disease); 
run;

Re: Macro in Prxchange didnt' work

Tom — Mon, 15 Mar 2021 15:41:09 GMT

The macro processor ignores strings bounded by single quotes. Use double quotes instead.

PS Why did you indent your in-line data lines?

Re: Macro in Prxchange didnt' work

ybz12003 — Mon, 15 Mar 2021 16:48:07 GMT

I put double quote in the macro list, still did not work.

proc sql;
	select quote(trim(Name)) into : Uairway_name separated by '|'  from AIRWAY_Name;
quit;

%put &Uairway_name;

Re: Macro in Prxchange didnt' work

Tom — Mon, 15 Mar 2021 16:53:36 GMT

Don't add quotes into your strings. Use double quotes when referencing you macro variable.

The macro processor ignores the strings in single quotes so:

'&mvar'

Is the string &mvar.

While

"&mvar"

Will replace &MVAR with value of the MVAR macro variable.

Re: Macro in Prxchange didnt' work

ybz12003 — Mon, 15 Mar 2021 17:39:19 GMT

Tom, it's working. Thanks.