The only thing I can imagine is you need to enumerate all these integer . OR use proc fcmp + proc format to make it better. Code: Program proc format; picture fmt 45,46,47,48,49,50,51,52,53,54,55='09' other='09.9'; run; data class; set sashelp.class end=last; output; if last then do;output;end; run; ods tagsets.excelxp file='/folders/myfolders/x.xml'; proc tabulate data=class; class sex; var weight; table sex,weight*pctn*format=fmt. ; run; ods tagsets.excelxp close; Xia Keshan Xia Kesan
... View more