Hi:    Excel has defaults for how it opens and renders the file that you create with ODS MSOFFICE2K_X. That destination creates an ASCII text file -- an HTML file -- that Excel knows how to open. But in the rendering department, Excel makes certain assumptions about column width, column type and column format that you may or may not want.   The way around this default Excel behavior is for you to send a specific Microsoft format instruction using the mso-number-format CSS style property. The way you send this style information to Excel from SAS is through the use of the HTMLSTYLE= style attribute.   There have been many previous forum postings about how to specify and use HTMLSTYLE in a STYLE= override; and the doc for MSOFFICE2K_X also shows an example under the topic "Formatting Data" http://support.sas.com/rnd/base/ods/odsmarkup/msoffice2k/index.html#formatting (see how AGE and HEIGHT  are each formatted with 2 decimal places)   In addition, this SAS Global Forum paper has extensive examples: http://support.sas.com/resources/papers/proceedings11/266-2011.pdf cynthia ... View more

Another way that might get a sufficient display is with PROC TABULATE. I've not used it for 7 variables, but have gotten up to 4 or 5. You may need to address the formatting as "Never" and "0" would be treated as distinct values. ... View more