quote, unquote, concatenate of macro variables

acordes — Tue, 19 Mar 2019 18:16:22 GMT

The code does what I want him to do, but it seems so overcomplicated what I do...

The final macro variable resolves to

O:\Arne\OUTINSIGHTS\heat_ALL_retail_2017_2018_AB_CD.htm

That's correct, but there has to be an easier way to achieve this.

Bye, Arne

OPTIONS MLOGIC SYMBOLGEN;

%LET BRA = "ALL";
%LET PRO1= "AB";
%LET PRO2="CD";
%LET YE1=2017;
%LET YE2=2018;


%LET H1=%SYSFUNC(CATX("_",&PRO1, &PRO2)); 
%let H2=%sysfunc(translate(%superq(H1),%str( ),%str(%")));
%PUT &H2;

%LET NA=  %SYSFUNC(CATX("",O:\Arne\OUTINSIGHTS\heat_,%SYSFUNC(DEQUOTE(&BRA.)),_retail_,&YE1,_,&YE2,_, &H2.,.htm)); 
%let NA1=%sysfunc(translate(%superq(NA),%str( ),%str(%")));
%LET NA2=%sysfunc(COMPRESS(&NA1));





FILENAME HT_APP "&NA2";
ODS GRAPHICS ON/ IMAGEMAP=ON IMAGENAME=&BRA. width=7in height=5in;
ODS HTML FILE=HT_APP NOGTITLE GPATH='O:\Arne\OUTINSIGHTS\' (url='');

title "%SYSFUNC(DEQUOTE(&BRA.)) Retail &YE1. &YE2. %SYSFUNC(DEQUOTE(&PRO1.)) %SYSFUNC(DEQUOTE(&PRO2.)) :  ";

Re: quote, unquote, concatenate of macro variables

PaigeMiller — Tue, 19 Mar 2019 18:38:47 GMT

@acordes wrote:

The code does what I want him to do, but it seems so overcomplicated what I do...

The final macro variable resolves to

O:\Arne\OUTINSIGHTS\heat_ALL_retail_2017_2018_AB_CD.htm

That's correct, but there has to be an easier way to achieve this.
%LET BRA = "ALL";
%LET PRO1= "AB";
%LET PRO2="CD";

Macro variable values are almost never surrounded by quotes. Then you don't need to de-quote them later.

So, after you remove those annoying quotes, to get &NA2

%let na2 = O:\Arne\OUTINSIGHTS\Heat_&bra._retail_&ye1._&ye2._&pro1._&pro2..htm;

topic quote, unquote, concatenate of macro variables in SAS Programming

quote, unquote, concatenate of macro variables

Re: quote, unquote, concatenate of macro variables