Thank you very much Cynthia. Your suggestions solved both of my problems! 1. The "options nobyline" statement took care of the text that I wanted to remove from my output. 2. To pass the value of the acad_group variable to the output filename. I inserted this code into my macro loop. PROC SQL NOPRINT;                     SELECT ACAD_GROUP INTO :AG                     FROM TEMP_GDR&I;           QUIT;           %LET AG=&AG;           %PUT VALUE OF AG IS &AG; and then called &AG in my file name. ods html file="c:\temp\college_x_term_&AG..xls" style=Styles.Custom           headtext="<style> td {mso-number-format:\@}</style>"; ... View more