One of my columns in my output dataset has the following values: 040,048,078,135,136,137,138,140,141 I used the following code to get that: cat("040,"||"048,"||"078,"||"135,"||"136,"||"137,"||"138,"||"140,"||"141") as col But when I use ODS ExcelXP to generate excel output, I am losing the commas and it is displaying a single large number. I used the following code in proc report to retain the leading zeroes and the text format, but not able to retain the commas. define col /Display style(column)={cellwidth=200pt tagattr='Format:@'};
... View more