Hello,
I’m trying to get a three page report produced with PROC TABULATE to look the same across the three pages. In particular there is one column that has all missing values on the middle page and I would like that column to have blank space, about the same width as the text that the formatted value of the numeric value in that column has on the other two pages. What I want is a uniform option like in PROC PRINT.
The closest I’ve come is to define my user format like this:
Proc format;
Value eryind_temp
0 = '(0 or Missing) to 25 cm²'
1 = '>25 to 81 cm² '
2 = '>81 cm² '
3 = '34.0 <- 37.6 °C (^ Gr)'
4 = '37.7 <- 38.6 °C (Gr 1)'
5 = '38.7 <- 39.3 °C (Gr 2)'
6 = '39.4 <- 40.5 °C (Gr 3)'
7 = '40.6 <- high °C (Gr 4)'
. = '...................................'
/* the line above is actually a period, several blanks and another period */
;
This sort of works but leaves a row of periods on each side of the column. What I’ve been looking for is some way to put a blank field in the column of missing values so that PROC TABULATE will not collapse it to a 0 or 1 character width.
Or any other suggestion you might have.
I'm off for the weekend, so I'll check in on Tuesday.
Thanks,
Paul
... View more