This is how I solved this. I used the Poor/Rich SAS Users Proc Export (http://www.sascommunity.org/wiki/A_Poor/Rich_SAS_Users_Proc_Export) macro. I have an Excel template with the color coding, font and date formatting. The code below uses the macro to copy the template and put the data in the right places in the report. I also format all dates as 03/14/2001 with locale = English (U.S.). I found out that you choose a date format with an asterisk and it will use the locale information stored in the recipients computer to determine if it should be displayed mm/dd/yyyy or dd/mm/yyyy. options missing = ' ';
/* This puts the main part of the report starting in cell A9 */
%exportxl(data=MedDev,
outfile=&RepDir.\MedDev Report.xlsx ,
sheet=Tabelle1,
type=N,
usenames=L,
range=A9,
replace=Y,
template=&RepDir.\MedDev template.xltx ,
templatesheet=Tabelle1,
useformats=Y,
method=I,
server_path=);
/* This puts the run date into cell C8 */
%exportxl(data=RunD,
outfile=&RepDir.\MedDev Report.xlsx ,
sheet=Tabelle1,
type=M,
usenames=N,
range=C8,
replace=Y,
template=,
templatesheet=,
useformats=Y,
method=I,
server_path=);
... View more