BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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
2 REPLIES 2
Cynthia_sas
Diamond | Level 26
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
deleted_user
Not applicable
Thanks a lot!
:-)

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1143 views
  • 0 likes
  • 2 in conversation