topic Re: Aligning values in a table with different formats in SAS Programming

Aligning values in a table with different formats

den — Fri, 17 Jun 2011 12:03:53 GMT

Hi all,

I'm creating a table output using proc tabulate and proc template. The table is a population demographic report. The rows are the various demographics and the column has the output statistical values. See example below:

Variable Stat Value
Age n 200
mean 62.1
std 9.35

Gender n 200
female 100 (50%)
male 100 (50%)

I would like to align the values in the third column so that they appear with decimal points aligned eg

Age n 200
mean 62.1
std 9.35

Gender n 200
female 100 (50%)
male 100 (50%)

I've tried justifying the column both to the left and right neither of which aligns the decimal point. When I justify using the decimal alignment, d, all of the decimals align but this causes the (%) statistic to right align rather than the count (100) aligning with the decimal point eg

Age n 200
mean 62.1
std 9.35

Gender n 200
female 100 (50%)
male 100 (50%)

Any advice on this issue would be much appreciated.

Re: Aligning values in a table with different formats

ballardw — Fri, 17 Jun 2011 17:34:27 GMT

Your post got bitten by the forum options. You're going to have to work much harder to imply alignment as tabs and such don't work well and it uses a proportional font so spaces may not work quite as expected either.
Example:

111
OOO

It might help to show your table code to see which approaches you were attempting and which output destination is needed.

Re: Aligning values in a table with different formats

Ksharp — Mon, 20 Jun 2011 06:29:43 GMT

You can check format Dw.p and Bestd.

Ksharp

Re: Aligning values in a table with different formats

den — Tue, 21 Jun 2011 11:01:14 GMT

I got it sorted. In the end I had to create an extra column for the (%) and shorten the space between the count value and the (%) value.

Thanks