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
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
Thanks once again....
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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.