I have three macros below which creates three excel reports with multiple sheets inside. **12 months** %metrics(score =y,vintage=y,excel=excel1); **06 months** %metrics(score =y,vintage=y,excel=excel2) **18 months** %metrics(score =y,vintage=y,excel=excel3) when i run this SAS it creates three excel sheets with multiple sheets in winscp location sas/output I want to know how to create a single excel picking up particular sheets from each three excel and output it into new excel document below these three macros and output it in same winscp location.
... View more
