1. Replace entire report with a formatted report from ODS EXCEL Re : I won't rewriting all formulas, even complex . In this way my colleagues can modify the formulas without knowing sas 2. Update your Excel template to use Tables and update your SASOUT table only and change it to allow the rest to flow through so step 2-4 should disappear. You can use FCOPY to copy the template to a new file. RE: The problem is that the length of the sasout is not standard 3. Investigate requirements again and see if another tool is more appropriate, such as a BI tool like Visual Analytics (Tableau/PowerBI). RE: unavaible I find a code that use VBA for modify excel: options noxwait noxsync; %let vba_loc=%sysfunc(getoption(WORK))\vbscript.vbs; %let open_workbook = &path.\Analisi\Test.xlsx; data _null_; file "&vba_loc"; put "Set objExcel = CreateObject(""Excel.Application"") "; put "objExcel.Visible = True "; put "objExcel.DisplayAlerts=False"; put "Set wb = objExcel.Workbooks.Open(""&open_workbook"")"; put "wb.sheets(""headings"").Range(""B12"") = ""Prova"""; put "wb.save"; x "'&vba_loc\'"; run; But I haven't found everything I need. It can be a solution ?
... View more
