I am trying to move from one method of outputting data to an excel file (proc export) to another (ods excel). I am outputting to a UNIX server. When I use the ods excel method and import the file back in to SAS to compare, there is the character string " " in the place of every blank (example: y z is instead formatted as y z). Similarly, searching for "y z" in excel does not find the value in the ods excel file. Is there an option when outputting with ods excel to treat blanks as normal blanks (ASCII 32 instead of 255)? I am using 9.4M4 and the ods excel code is below: ods excel file="output.xlsx"
options(sheet_interval='none' suppress_bylines='no' sheet_name='All Items'
absolute_column_width='40,40,40,25,25,25,25,25,25,25,25,25,25,25' absolute_row_height='15')
;
proc print data=DATASET noobs label
style(header)={FONT_FACE='Albany AMT' FONT_WEIGHT=medium BACKGROUND=#FFFFFF COLOR=black}
style(column)={FONT_FACE='Albany AMT' asis=on width=1000% TAGATTR="Type:String"}
;
run;
ods excel close;
... View more