topic Re: macro in SAS Programming

macro

deleted_user — Tue, 19 Jan 2010 16:36:51 GMT

%let qtr = 2009-12TestNS;

data _null_;
Call symput('qtrdata',%substr(&qtr,1,7));
run;

%put &qtr &qtrdata;

70 %put &qtr &qtrdata;
2009-12TestNS 1997

Do you know why it is doing &qtrdata = 1997??

I'm expecting &qtrdata = 2009-12

Re: macro

DanielSantos — Tue, 19 Jan 2010 16:56:10 GMT

Yes.
[pre]
Call symput('qtrdata',%substr(&qtr,1,7));
[/pre]
will resolve to:
[pre]
Call symput('qtrdata',2009-12);
[/pre]
So 2009-12 = 1997.

SAS is doing an implicit numeric to char conversion and assigning '1997' to QTRDATA.

enclose your value into double quotes, like this
[pre]
Call symput('qtrdata',"%substr(&qtr,1,7)");
[/pre]
or

switch the macro function %substr to its datastep equivalent, and use double quotes arround QTR
[pre]
Call symput('qtrdata',substr("&qtr",1,7));
[/pre]
Cheers from Portugal

Daniel Santos @ www.cgd.pt

Re: macro

deleted_user — Tue, 19 Jan 2010 17:19:33 GMT

Thank you!! It works.

how do i do it without call symput and just %let?

%let qtr = 2009-12TestNS;

%let qtrdata = ???

Re: macro

Peter_C — Tue, 19 Jan 2010 17:39:09 GMT

%Qsubstr( %superQ(qtr), 1,7 )
I've used the macro quoting functions to protect the minus sign from being treated as syntax

Re: macro

Peter_C — Tue, 19 Jan 2010 17:43:43 GMT

macro quoting is overkill here, as this saslog snippet indicates[pre]49 %let qtr = 2009-12TestNS;
50 %let qtrdata = %substr( &qtr, 1,7 ) ;
51 %put &qtrdata ;
2009-12
[/pre]
PeterC

Re: macro

deleted_user — Tue, 19 Jan 2010 17:43:46 GMT

I tried doing this.

233 %let qtr = 2009-12TestNS;
234
235 %let qtrdata = %Qsubstr(%superQ(qtr), 1,7 )||PROD;
236
237 %put &qtr &qtrdata;
2009-12TestNS 2009-12||PROD

I'm expecting &qtrdata = 2009-12Prod

Re: macro

Peter_C — Tue, 19 Jan 2010 17:46:59 GMT

in the macro language of SAS, that concatenation symbol is unneccessary and is being treated as text[pre]
53 %let qtr = 2009-12TestNS;
54 %let qtrdata = %substr( &qtr, 1,7 )PROD;
55 %put &qtrdata ;
2009-12PROD[/pre]

Re: macro

deleted_user — Tue, 19 Jan 2010 17:58:51 GMT

ah! thanks a lot!