Cynthia - thanks for the response. I guess I should have given more details. I have a files that use more memory in the ODS process than my system allows, so to get around that, I'm writing 1 observation to the formatted Excel file, then writing the rest of my observations to a delimited text file, which I'm then importing into the Excel file. I was hoping to find a way to format the whole sheet when I write the one observation, but it would make sense that SAS can only control the observations it's writing. So I just have to manually update the formats of the Excel columns prior to the text import.
... View more