04-14-2012 03:15 PM
I am using SAS 9.3 exporting to Excel 2010.
I was using previous versions of both SAS (9.1) and Excel (2003 and 2007) and when using the code below, it overwrote the worksheet already entitled "RawData_A" without any formatting which is what I wanted. Now, it won't overwrite the current "RawData_A" worksheet but instead adds one called "RawData_A1" and all the columns have double lined borders. Why isn't it working the same as with other versions and how can I get to do as it did before? Thanks.
keep Seq_No ChartNo RegNo coder age_years sex admdate admit entry instfrom
format admdate ddmmyy10. DischDate ddmmyy10.;
EXPORT DATA= &export_sample_fileA