topic Macro quoting functions in SAS Programming

Macro quoting functions

SASSLICK001 — Sat, 23 May 2015 20:47:11 GMT

Hello All

I have the following code and trying to extract first word (QTcF) how can i achieve this?

data x;

input seq param $ 2-80;

datalines;

1 QTcB - Bazett's Correction Formula (msec)

;

run;

data y;

set x;

call symput ("param", cats(param));

run;

%put &param; ( this is not resolved in log)

When i am doing the following way i get an error in the log

%let x = %scan("&param",1,-));

%put &x;

ERROR: Open code statement recursion detected.

Re: Macro quoting functions

Jagadishkatam — Sun, 24 May 2015 02:40:53 GMT

First issue is that you are unable to create a macro variable where the value has a unbalanced quote. To avoid this you need to try the following code

data y;

set x;

call symputx('param', quote(trim(param)));

run;

%put &param;

it will create the param macro variable with value. Then to get the QTCB please try

%let x = %substr(%qsysfunc(scan(&param,1,'-')),2);

%put &x;

First it will extract the QTCB and then it will remove the first quote by substr.

Please try and let me know if it was helpful.

Thanks,

Jag

Re: Macro quoting functions

Quentin — Sun, 24 May 2015 02:57:07 GMT

Actually it's okay to have an unmatched quote inside a macro variable, as long as you macro quote it when you use it. The following should work:

%let x = %scan(%superq(param),1,-) ;

Worked for me on free SAS University Edition running on AWS. So cool to have that. Thank you SAS.

--Q.