Help using Base SAS procedures

Export to Excel causing odd formatting

Reply
Regular Contributor
Posts: 152

Export to Excel causing odd formatting

Hello

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.

&export_sample_fileA;

set &sample_list_obs;

keep Seq_No ChartNo RegNo coder age_years sex admdate admit entry instfrom

format admdate ddmmyy10. DischDate ddmmyy10.;

run;

EXPORT DATA= &export_sample_fileA

OUTFILE= &export_tool

DBMS=EXCELCS REPLACE;

"RawData_A";

run;

Ask a Question
Discussion stats
  • 0 replies
  • 152 views
  • 0 likes
  • 1 in conversation