nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do I create a summary table with mean ± SD in the same column?

aimeeh60

I generate tables by hand that express mean ± SD in the same column. This is very time consuming. Is there a way to generate in a table in JMP that looks like the table below?

Thanks,

Time	Group 1	Group 2	Group 3
(hr)
1	mean ± SD	mean ± SD	mean ± SD
2	mean ± SD	mean ± SD	mean ± SD
3	mean ± SD	mean ± SD	mean ± SD

Accepted answers

KarenC

The non-scripting solution:

First you need to build a summary table which is really easy to do. There are two options, use the tabulate and when your table looks like what you want then use save to table option. Or alternately from the Tables menu select Summary. Put your grouping variables into the group (so in your case Group and Time) then select the data column and then in the "Statistics" drop down menu in the summary dialog box select mean and then again select std dev. Before you hit the OK button check the little "keep dialog open" button so that if your table is not what you want it is easy to go back to the dialog and try again (and don't worry, we all do this multiple times to get exactly what we want).

Now you have a table with a Group Column, a Time Column, a mean, and a std dev. Now you can add another column (double click to the right of your last column) and now right click on that empty column and select formula. You want to build a formula that concatenates the mean, the ± symbol, and the standard deviation. The only trick is that the mean and std dev are numbers so I have a 3 part concatenate (look that up in the formula functions) with a char function to convert numbers to characters. I also use the ^ option on the character function to get a space for the "7" to control the length of the character. Maybe someone has a better solution to get a constant 2 digits when converting a number to a character.

Char( :Name( "Mean(Data)" ), 7 ) || "±" || Char( :Name( "Std Dev(Data)" ), 7 )

Finally to get the layout you were looking for you would Split your table. Table menu, Split option, dialog box: split by = group, split columns = new column, and group = time, again utilize that "keep dialog open" to go back and redo when you put the columns in the wrong places.

All comments

txnelson

I have attached a script that illustrates how to do the 3 different solutions for your request. I think the 3rd one is the closest to what you want.

Sample data for summary table.jsl

aimeeh60

Thank you, Jim. The third option is exactly what I am looking for. How do I arrive at this format? I have very little experience creating data tables using JMP.

Thanks,

txnelson

The script that I encluded in the response has the jsl code to create the table. If you need more explanation after you look at the attached file, get back to me and we can walk through it.

aimeeh60

Hi Jim,

Unfortuantely, I can't follow the jsl code so I'll need step by step instrcution. I am happy to share my desktop for a virtual session.

Thanks.

ezorlo

I agree there should be a one click option to create mean ± SD

Mark_Bailey

This discussion is four years old. The place to submit requests for new features is the Wish List in the JMP Community. Please search for this topic first to see if someone else already submitted the request. If that is the case, then you can vote for it!