JMP User Community

Latest Discussions

How to create database connection reference to a SQL server?

Hello Everybody,
I have an issue with creation of variable (or reference) after connecting to a database. I wanted to create variable conn that I could use later to run different queries. At the beginning, however, I needed to create 2 connections since I needed data from different databases, but on the same SQL server (the same user name and password are required). For both connections I need to p...
lukasz

Discussions |
May 11, 2020 1:00 PM

4072 views | 2 replies
Date-Time Formats

I have date-time data in a column of form:2020-04-30T17:29:48.967-04:00 This data was loaded from a database. JMP recognizes it only as a string of characters.How can I convert this into a JMP datetime format?P.S. I do not care about the timezone (-04:00).
jfsilves

Discussions |
May 11, 2020 10:16 AM

1963 views | 1 replies
PCA/Factor Analysis with ordinal data

I have a dataset from social sciences that contains many ordinal categorical variables with > 2 levels which are linked to scores like 1 2 3..I was asked if there are correlations between these ordinal variables so question: how to carry out correlation and PCA/Factor Analysis with this kind of data? Thanks for help!
frankderuyck

Discussions |
May 11, 2020 8:52 AM

7230 views | 11 replies
How to perform MANOVA with continuous variables which are not normally distributed (non-parametric)

I am performing an analysis of hemoglobin values at 3 different time points between cases and controls. The data is not normally distributed. How should I go about with MANOVA in such a setting? Also is there an alternative test that I can apply in JMP to see the differences in the cases & controls at these 3-time points.
Uday

Discussions |
May 11, 2020 7:48 AM

2463 views | 4 replies
One Way ANOVA figure for Scientists

I get asked about this one figure a lot. Almost as many times as I've made it. A google search for ANOVA images brings up this figure with hundreds of different data sets. I put together a Blog Post with a Script for how to make the figure. There are a number of subtle variations out there too. So... How do you make this figure? I'm thinking of making launch dialog that includes opti...
Byron_JMP

Discussions |
May 9, 2020 7:32 AM

1793 views | 1 replies

Previous
Next

Latest Discussions

PCA/Factor Analysis with ordinal data

I have a dataset from social sciences that contains many ordinal categorical variables with > 2 levels which are linked to scores like 1 2 3..I was asked if there are correlations between these ordinal variables so question: how to carry out correlation and PCA/Factor Analysis with this kind of data? Thanks for help!
frankderuyck

Discussions |
May 11, 2020 8:52 AM

7230 views | 11 replies
How to perform MANOVA with continuous variables which are not normally distributed (non-parametric)

I am performing an analysis of hemoglobin values at 3 different time points between cases and controls. The data is not normally distributed. How should I go about with MANOVA in such a setting? Also is there an alternative test that I can apply in JMP to see the differences in the cases & controls at these 3-time points.
Uday

Discussions |
May 11, 2020 7:48 AM

2463 views | 4 replies
One Way ANOVA figure for Scientists

I get asked about this one figure a lot. Almost as many times as I've made it. A google search for ANOVA images brings up this figure with hundreds of different data sets. I put together a Blog Post with a Script for how to make the figure. There are a number of subtle variations out there too. So... How do you make this figure? I'm thinking of making launch dialog that includes opti...
Byron_JMP

Discussions |
May 9, 2020 7:32 AM

1793 views | 1 replies
Working with dates

Hi, I have a set of data with information from 2010 to 2020. I'm trying to create a formula column for data before and after 2012 so that that I can compare these 2 sets of data. How do I manipulate the date data? Thanks.
SCWong

Discussions |
May 8, 2020 12:46 PM

4537 views | 4 replies
For Smoother lines, can the volume/density of data be used to adjust the thickness of the Smoother line?

I often use Smoother+Overlay to check how independent categorical variables affect dependent continuous variables in a time trend plot. But one issue I often encounter is when different categories have different volumes of data, the smoother lines are equally as big even if one category has 200 data points and another category has 4 data points. This can create busy plots where it's hard to distin...
markschwab

Discussions |
May 8, 2020 8:27 AM

3748 views | 4 replies

Previous
Next

Latest Discussions

How do I have two different chart types in a single graph using two axis?

While doing some research to answer this question, I found this article on the JMP community that helped me get started. How do I do a combination bar and line plot using Overlay Plot? Using the big class sample data example of height and weight I was able to create a bar chart for weight and a line plot for height on the same chart using the Overlay Plot. To do this, first clear the row s...
Bass_Masri

Discussions |
Apr 28, 2020 4:28 PM

4549 views | 0 replies
How do I calculate z-scores at different aggregation levels?

Hello, How do I use JSL to calculate Z-scores at different levels of aggregation? I am working with cancer mortality data (1999 - 2015) at the county-level. I need to calculate Z-scores to compare each county to the others within a state and all counties within the country. I cannot simply use the standardize function because it automatically takes an average of rates--which is invalid unless the...
Jmsouch

Discussions |
Feb 26, 2020 7:04 AM

2116 views | 0 replies
Calling Windows API ImageViewer.dll to display JPG files.

I am working with a very large database of image files and want to be able to display the file for the user for visual inspection from a script. I have been able to get the following code to load the DLL but get an error requesting a signature argument. Does anyone know how to get a signature string from the system to pass to the DLL. ERROR MESSAGE FORM LOG: Second argument to CallDLL must be a ...
DMeakin1

Discussions |
Jan 17, 2020 10:19 AM

1953 views | 0 replies
Running script from command line on MAC

Not a mac person. Does anyone know how to run a jsl script from command line on a mac? I specifically mean WITHOUT "//!" at the top of it. I have this but it only opens the file unless I have the "//!" open -g -W -a /Applications/JMP\ Pro\ 15.app/ $(pwd)/myscript.jsl
vince_faller

Discussions |
Jan 10, 2020 2:26 PM

1611 views | 0 replies
how to add confounding variable

I am working with a multi level data. Data is attached.In this dataset, I have 8- X variable: cumulative risk (continuous), all other risk (dichotomous). 3- Y variables: insurance and practice (dichotomous) and time (continuous)I have one confounding variable Age (continuous). I will have to add random effect to X variable. But I am confused how to add confounding variable to this analysis. Can an...
billi

Discussions |
Jan 6, 2020 9:39 AM

1565 views | 0 replies