Thanks RW9 for your suggestion, I finially use "Ods tagsets.ExcelXP" to generate an excel .xls file, and send it by attached email. I also remove "content_type="application/vnd.ms-excel" which I added before. It works. Only problem is when I try to open the excel file, it always gave me warning message "The file you are trying to open is in a different format than specified by the file extension. Verify that file is not corrupted and is from a trusted source before opening the file." Actually I opened it, it works well. My SAS is EG 4.3 on Unix, my excel on local machine is excel 2010. Thanks. ... View more

can you try use   CONTENT_TYPE= (or CT=) option in the FILENAME statement for the attachment as shown in the example below:    filename sendit email from="user@company.com"    to="someone@domain.com"    subject="Excel files from SAS"   attach=("myfile.xls" content_type="application/vnd.ms-excel");   official link: http://support.sas.com/kb/39/996.html   Mine works but my file corrupt, I guess because my SAS EG 4.3 version too lower. ... View more

  btw, something interesting I have to share, actually I got one more error message " "ERROR: An attachment record was truncated, LRECL is too small" when sending files as email attachment" , I fixed it by adding:  content_type="application/vnd.ms-excel" which is suggested officially : http://support.sas.com/kb/39/996.html Excel file is generated and sent as attched but it is corrupted and I can't open it at all. Any idea about this? Thanks. ... View more

thank you, but if I use DBMS=xlsx, I got error message "ERROR: DBMS type XLSX not valid for export." Mine is SAS EG4.3, excel is 2010.   I try to use DBMS=xls, file got generated but when I open it by excel2010, got another error message - find unreadable content in excel file. Not sure why. Thanks for help. ... View more

Thanks Cynthia and SASKiwi. Thank you RW9 - u got the point. The truth is I try to export to excel file but it doesn't work:   PROC EXPORT DATA=abc OUTFILE="/abc_&sysdate._&systime..xlsx" DBMS=EXCEL REPLACE; PUTNAMES=YES; RUN;   It is always said "ERROR: DBMS type EXCEL not valid for export." I am not sure why. Thanks. ... View more

Thank you, Patrick and Cynthia.   The reason I use TAGATTR on a3, because a3 is a number type but length is 16, when I export it to CSV file, it shows as scentific notation which I try to avoid. How could I do? Please help. a3/a2/a1 all substr from a long string which import from a CSV file. Please help, thanks! ... View more