Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
abhi_dp
Level I

How do I create a Table 1 of this kind in JMP?

What is the easiest way to create a Table 1 of this kind that compares the characteristics of the population and provides p values too?

4 REPLIES 4
Highlighted
txnelson
Super User

Re: How do I create a Table 1 of this kind in JMP?

The display table you have is a hybrid table, in that the types of data change from row to row. So given that, the different rows will have to be calculated differently from one row to another. For the most part, a script will have to be written that steps through the row requirements and use the Oneway(Fit Y by X) platform to calculate the p values, and the Summary Platform, or the Summarize() function to get the counts, means, percentages etc. Then the values probably need to go into a Display Table Box() or into a data table. Nothing difficult, just laborious.
Jim
Highlighted
abhi_dp
Level I

Re: How do I create a Table 1 of this kind in JMP?

Thank you! I wish there was an easier way This kind of Table is essential for almost every observational study in clinical journals. R has a very nice package for this: https://cran.r-project.org/web/packages/tableone/vignettes/introduction.html
Highlighted
txnelson
Super User

Re: How do I create a Table 1 of this kind in JMP?

Have you looked into JMP Clinical and how it may handle these types of reports?
Jim
Highlighted
abhi_dp
Level I

Re: How do I create a Table 1 of this kind in JMP?

Thanks for the suggestion. I wish I could afford it but I will check it out. There is a SAS macro for it, but I am not sure how to use it in JMP
https://www.hsph.harvard.edu/donna-spiegelman/software/table1-for-windows/