Hi: I would expect you to get an error message when you try to open the Excel file -- I believe you have your quoting wrong in the FONTFAMILY attribute. When I try a version of your template with this: fontfamily = '"Times New Roman", Arial, sans-serif'; (because I don't have Lucida Grande on my system), I get an error message from Excel. But, if I have this: fontfamily = 'Times New Roman, Arial, sans-serif' ; then I don't have an error message from Excel. Also, aside from the sheet_interval='none' issue, typically, I find border colors, border styles and border widths generally ignored by Excel, So I believe you can simplify your template. Also, if you plan to share your template with other people, then you will generally need to write the template to an item store on a shared drive or server where other folks can get to it. cynthia Also, with sheet_interval='none' you are telling TAGSETS.EXCELXP that you do NOT want a multi-sheet workbook, but that you want ALL your procedure output in one worksheet. ... View more

Nope, it handles different types as well ... View more

The first subject won't be 22 years old until 12/22/16 but the program results in an age of 22 now even though the subject is only 21.   The yrdif function can be used to correctly calculate age in years in 9.3 and 9.4 but that won't work for months or weeks.   One can read about Billy Kreuter's classic solution to the age calcualtion problem here: http://www.pauldickman.com/teaching/sas/age.php http://staff.washington.edu/billyk/TechTips_SC4Q98.pdf   Billy's code can be modified to get age in months or weeks.   Paul ... View more

True, Thats also might be an option. ... View more