As you suggested, Tom, I solved this issue by switching to ODS EXCEL (working code listed below). I believe you may be right and that the problem is caused by hidden special characters (some of my data contains names imported from external sources). I'm sure there is a way to "clean" them automatically, but since exporting the data straight to Excel eliminates this issue, I'm taking the easy way out. Thank you again! ods listing close;
ods excel options (frozen_headers="3" frozen_rowheaders="2" embedded_titles="yes")
file="mypath/myfilename.xlsx";
%macro tabs (sheetname, dataname, keepstatement);
ods excel options (sheet_name="&sheetname.");
proc print data=&dataname.;
title "Top Candidates For &sheetname.";
run;
%mend tabs;
%tabs (Tab1, Dataset1,);
%tabs (Tab2, Dataset2,);
%tabs (Tab3, Dataset3,);
ods excel close;
ods listing;
... View more