btw, if you include the macro usage is as below:

%inc 'P:\SAS\Macros3\mac3_excel_text_ods.sas'; %mac3_excel_text_ods (ds=D204.D204_final,char=isn sitecode,/*TRY ALL.*/ path=c:\temp, filename=temp.xls, title=Title);