Afaik SAS does not directly support .xlsm Proc Export: DBMS=data-source-identifier
You could use Python package openpyxl for writing to this .xlsm. From a design perspective: I'd keep the "raw" data in separate sheets.
For SAS to interface with Python:
If you've got SAS Viya then use Proc Python, if you've got SAS9.4 then call the Python script via call system() or the like (needs option XCMD set).
... View more
