Desktop productivity for business analysts and programmers

cross-tabular

Reply
N/A
Posts: 0

cross-tabular

Hi,
Is it possible to change the standard output of a created cross-tabular?
I'd like to change the numbers with my own format and use more decimals than the standard.

/Nicolas
SAS Super FREQ
Posts: 8,818

Re: cross-tabular

Hi:
Yes, it is possible to change the format used for all the calculated/displayed numbers in a cross-tabular table. If you are using PROC TABULATE or the Summary Tables Task, this is very easy to do. To change ALL numeric formats in the table, if you right-click in the table, when you are in "design" mode on the Summary Tables dialog box, there will be a choice for "Table Properties" and under Table Properties pop up window, there will be a tab for "Formats" -- on this tab, you can choose the format and number of decimal places. You can also select a standard numeric format to use or a user-defined format. There are up and down arrows that allow you to select the format overall width and number of decimal places.

For example, if I pick an overall width of 12 and 3 decimal places, then this is what EG generates for the PROC TABULATE statement:
[pre]
PROC TABULATE DATA=XXXX.YYYY FORMAT=12.3 ;
[/pre]

If there is a particular row or column statistic that you want to give a separate format, then you might need to right click on a cell header and modify the "Data Properties" format to be a different format (such as a different format for a grand total or ALL column).

cynthia
N/A
Posts: 0

Re: cross-tabular

Thanks a lot!
:-)
Ask a Question
Discussion stats
  • 2 replies
  • 122 views
  • 0 likes
  • 2 in conversation