topic Re: Remove quotes from macro variable LET in ODS and Base Reporting

Remove quotes from macro variable LET

metallon — Wed, 07 Oct 2015 09:24:14 GMT

Hi SAS Experts,

I am creating a macro variable %LET RepQuarter = '4th (October-December)'; and insert it later on

in my custom ods xml tagset.

        define event EmitMetaMainMessage;
           xdent;
           put "</Metas>" CR;
           put "<main>" CR;
           put "<year>&RepYear" ;
           put "</year>" CR;
           put "<quarter>&RepQuarter" ;
           put "</quarter>" CR;
       end;

But I need it without the quotes'. How can I remove those?

Bye

Re: Remove quotes from macro variable LET

RW9 — Wed, 07 Oct 2015 09:36:27 GMT

Hi,

Why have you put quotes on it in the first place?

%LET RepQuarter = 4th (October-December);

Problem solved. The next question is, why is data in a macro parameter?

Re: Remove quotes from macro variable LET

metallon — Wed, 07 Oct 2015 10:39:33 GMT

Greetings!
Unfortunately the problem is not solved be removing the quotes:

NOTE: Line generated by the macro variable "REPQUARTER".
252 4th (October-December)
__
22
76
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN,
CONTAINS, EQ, EQT, GE, GET, GT, GTT, LE, LET, LIKE, LT, LTT, NE, NET, OR, ^=, |, ||, ~=.

ERROR 76-322: Syntax error, statement will be ignored.

The next question is not really a problem I have. I use the variable at various points in the code.

Re: Remove quotes from macro variable LET

metallon — Wed, 07 Oct 2015 10:40:41 GMT

Hi RW9,

The problem is not solved by removing the quotes.

NOTE: Line generated by the macro variable "REPQUARTER".
252 4th (October-December)
__
22
76
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN,
CONTAINS, EQ, EQT, GE, GET, GT, GTT, LE, LET, LIKE, LT, LTT, NE, NET, OR, ^=, |, ||, ~=.

ERROR 76-322: Syntax error, statement will be ignored.

The second question is not really a problem I have. I just use the macro at various places in the code.

Re: Remove quotes from macro variable LET

Quentin — Wed, 07 Oct 2015 11:43:59 GMT

Agree with @RW9 about not adding the quotes in the first place. But if you want to remove them, you can use the DEQUOTE function.

1    %LET RepQuarter = '4th (October-December)';
2
3    data _null_;
4      put "<quarter>&RepQuarter" ;
5      put "<quarter>%sysfunc(dequote(&RepQuarter))" ;
6    run;

<quarter>'4th (October-December)'
<quarter>4th (October-December)

Re: Remove quotes from macro variable LET

RW9 — Thu, 08 Oct 2015 08:17:35 GMT

Yes, but then you haven't thought about the data, and the process then have you. If you need parameters, put them into a dataset, its is far easier to work with. Datasets are there to work with Data, macro variables are there as find and replace, and as you are seeing in your example, that find and replace fails as you are using it in multiple ways.