Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
Choose Language Hide Translation Bar
Level I

Setting a default format for new columns?

When I'm working in JMP, I spend a non-negligible fraction of my time changing the column formats to keep my data legible. I am aware of the Standardize Attributes function, but even that is tedious for the number of times I find myself doing it.


Is there a way to change the defaults so that all new columns default to, for example "Fixed Dec" with 2 decimal points, instead of "Best" ?



Super User

Re: Setting a default format for new columns?

I searched, but did not find a preference for the setting of a default format in a JMP data table.  I think you should add it to the JMP Wish List.

Below is a simple script that will set all continuous columns to a given format.  You could either run this as a separate formula, or add it as a new option on the pull down menus or as an addin.  You could then run it on any new data table you desire.

Names Default To Here( 1 );
dt = Current Data Table();

colList = dt << get column names( string, continuous );

For( i = 1, i <= N Items( colList ), i++,
	Column( dt, colList[i] ) << format( "Fixed Dec", 7, 2 )
Article Labels

    There are no labels assigned to this post.