I want to send out a monthly report which the numbers are generated by SAS and then PROC EXPORT to a csv file. The csv file typically looks like below: However, this is not the final output as there's an Excel file with a nice looking template which looks like this. The Excel file also contains a formula like MOM% (month over month). What I want is, to link both. So that, the better looking Excel will automatically fill in the values based on the csv file generated by SAS. For example, if I run the March numbers, the better looking Excel will then be filled with the new numbers generated by SAS. Any advice on how to do so?
... View more