Puting variable in a string...

Reply
Frequent Contributor
Posts: 75

Puting variable in a string...

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

Frequent Contributor
Posts: 81

Re: Puting variable in a string...

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

Frequent Contributor
Posts: 75

Re: Puting variable in a string...

Thanks once again....

Trusted Advisor
Posts: 1,128

Re: Puting variable in a string...

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

Thanks,
Jag
Ask a Question
Discussion stats
  • 3 replies
  • 192 views
  • 0 likes
  • 3 in conversation