topic Puting variable in a string... in SAS Programming

Puting variable in a string...

aj34321 — Tue, 12 Mar 2013 08:42:12 GMT

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

Re: Puting variable in a string...

damanaulakh88 — Tue, 12 Mar 2013 08:54:24 GMT

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";

12 %PUT &pCardMarketingFile;

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

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

/Daman

Re: Puting variable in a string...

Jagadishkatam — Tue, 12 Mar 2013 09:11:12 GMT

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

Re: Puting variable in a string...

aj34321 — Tue, 12 Mar 2013 09:23:13 GMT

Thanks once again....