Puting variable in a string...

[aj34321]

Dear All,

I'm not sure what wrong i'm doing in below statement but the required output is not generating. Below should generate

C:\CC_MTD_2013-03.xlsx

%let pMTD = '2013-03';

%let pCardMarketingFile = "C:\CC_Mtd_"&%substr(&pMTD,2,7)&".xlsx";

Request experts advice on this..

Thanks a lot.

Rgds, Anil

[damanaulakh88]

Hi Anil,

Below code is working:-

=====================================================

%let pMTD = '2013-03';

%let pCardMarketingFile = "/shared/BatchServer/CC_Mtd_%substr(&pMTD,2,7).xlsx";

%PUT &pCardMarketingFile;

=====================================================================

Below is the output in the log:-

======================================================================

10         %let pCardMarketingFile = "/shared/BatchServer/CC_Mtd_%substr(&pMTD,2,7).xlsx";

11        

12         %PUT &pCardMarketingFile;

"/shared/BatchServer/CC_Mtd_2013-03.xlsx"

======================================================================

/Daman

[aj34321]

Thanks once again....

[Jagadishkatam]

Hi Anil,

Just a small change you need to do like below

the below code will create the macro variable pMTD with value 2013-03.

%let pMTD = '2013-03';

you need to use the pMTD macro variable like below

%let pCardMarketingFile = "C:\CC_Mtd_&pMTD..xlsx";

check the highlighted portion &pMTD. there is another . before the xlsx, &pMTD. will resolve to 2013-03 and the another . separates the filename from the extension. Hope this helps you.

Thanks,

Jagadish