JMP User Community

Latest Discussions

How to handle NULL values in JSL script

Hi, I am very new to JSL, my background is pl/sql. I have an INSERT (see below) to an Oracle table that is failing on some rows that have null values in a few of the columns. In Oracle I would just use NVL e.g. NVL(STD_ERROR,0) How can I do this in JSL? In this case it's just column7 that is causing the problem but I would wrap all the columns in the function(?). Any help is greatly appreciate...
gerardmcl

Discussions |
Sep 24, 2013 11:46 AM

18903 views | 3 replies
Best method of analysis of multiple dependent variables in JMP

I need a predictive model for two response variables (that are dependent on each other) and multiple independent variables. I'm not very statistics-savvy but am comfortable with multiple regression; however, I'm not sure of the best way to approach a problem with multiple dependent variables. I've been studying some of the approaches (MANOVA, MANCOVA, multivariate multiple regression, structural...
kcros

Discussions |
Sep 24, 2013 11:37 AM

3226 views | 0 replies
Is there a way to represent how a row changes across columns?

I am looking at how survey responses change over time. Each participant is entered as a row. Is there a way to see how each participant's anwers vary over time? For example, we have a survey that was given annually for 3 years. For yes or no questions (answers coded 1 or 0), I would like know how many people answered 1 the first year, then 0 for the two subsequent years etc.Thank you.
hollyg

Discussions |
Sep 20, 2013 2:18 PM

3313 views | 2 replies
Color Map on Correlations

All, I am trying to come up with a nice qualitative explanation for the color map on correlations plot in the DOE Design Evaluation. My best explanation so far is that it is a measure of how distinguishable two effects are. For instance for the correlation plot below we can say that that main effects x1 and x2 are uncorrelated but the effects x1*x1 and x2*X2 have a correlation value near 0.5. H...
orthogonal

Discussions |
Sep 20, 2013 10:12 AM

12799 views | 1 replies
SAS to JMP....Will I Get What I Need?

HelloI have Base SAS 9.3 with Enterprise Guide and I've written quite a few programs in SAS code. Mostly I manipulate data from importing, change/create new fields, export to another medium like MS-Access. I link onto the MS-Access data via Crystal Reports and use that for my reporting.I currently have SAS through my employer but I pay the yearly license fees. However, I'm a contract employee a...
shellp55

Discussions |
Sep 20, 2013 9:19 AM

12742 views | 6 replies

Previous
Next

Latest Discussions

Best method of analysis of multiple dependent variables in JMP

I need a predictive model for two response variables (that are dependent on each other) and multiple independent variables. I'm not very statistics-savvy but am comfortable with multiple regression; however, I'm not sure of the best way to approach a problem with multiple dependent variables. I've been studying some of the approaches (MANOVA, MANCOVA, multivariate multiple regression, structural...
kcros

Discussions |
Sep 24, 2013 11:37 AM

3226 views | 0 replies
Is there a way to represent how a row changes across columns?

I am looking at how survey responses change over time. Each participant is entered as a row. Is there a way to see how each participant's anwers vary over time? For example, we have a survey that was given annually for 3 years. For yes or no questions (answers coded 1 or 0), I would like know how many people answered 1 the first year, then 0 for the two subsequent years etc.Thank you.
hollyg

Discussions |
Sep 20, 2013 2:18 PM

3313 views | 2 replies
SAS to JMP....Will I Get What I Need?

HelloI have Base SAS 9.3 with Enterprise Guide and I've written quite a few programs in SAS code. Mostly I manipulate data from importing, change/create new fields, export to another medium like MS-Access. I link onto the MS-Access data via Crystal Reports and use that for my reporting.I currently have SAS through my employer but I pay the yearly license fees. However, I'm a contract employee a...
shellp55

Discussions |
Sep 20, 2013 9:19 AM

12742 views | 6 replies
Change Column Name after performing Summary Function

Hello.Good day.Team,I will be needing your support on how to achieve my target table output.I have a sample data table. I made a Mean Summary for Group 1 and Group 2 Columns, separately.But i want to combine the two Mean Summary table into 1 table.However, since Group 1 and Group 2 has different Column NameDuring Concatenate this 2 Columns will have separate Columns.In order to have them in same C...
karem

Discussions |
Sep 17, 2013 12:56 PM

3954 views | 1 replies
JMP needs ODBC Driver to Open Excel Files

I just upgraded to JMP 11 yesterday. I cannot open Excel files. Doing a Google search I figured out I needed an ODBC driver. I have tried the actual technologies driver, to no avail. the OpenLink website is very confusing. They offer multiple drivers depending on what database you need to get access to. I don't know if Excel is an access database, MySQL, SQL Server or what. I am running JMP on a M...
atlas100

Discussions |
Sep 12, 2013 11:41 AM

7004 views | 4 replies

Previous
Next

Latest Discussions

Best method of analysis of multiple dependent variables in JMP

I need a predictive model for two response variables (that are dependent on each other) and multiple independent variables. I'm not very statistics-savvy but am comfortable with multiple regression; however, I'm not sure of the best way to approach a problem with multiple dependent variables. I've been studying some of the approaches (MANOVA, MANCOVA, multivariate multiple regression, structural...
kcros

Discussions |
Sep 24, 2013 11:37 AM

3226 views | 0 replies
How to do a clean uninstall of JMP9 on a Mac?

Wondering if this is as simple as dragging the application package to the trash. The OCD in me would like to also get rid of associated library and preference components. The manuals and online resources don't give any direction. And since I have JMP10 installed, I don't want to rip out resources shared with the new version.
uw_viromics

Discussions |
May 17, 2013 6:26 PM

3560 views | 0 replies
Mean Diamond Confidence Intervals

I'm doing a simple Oneway Analysis, ~10 groups each with # of data points ranging up to 20.I noticed that there are 2 95% CIs that are calculated:1. One set for each group in the Means and Std Dev report below the chart, where CIs are calculated off of the Std Dev of each individual group2. One set for the Anova, where the Std Dev of all groups are assumed to be the same (calculated off of the S...
gugiyu

Discussions |
Apr 23, 2013 2:39 PM

4128 views | 0 replies
Sensitivity and specificity calculation

Hi every one, Is there any suggestion to directly calculate sensitivity and specificity directly from JMP 9? I read some where there is some plug in or small app needs to be downloaded to JMP for this purpose Any ideasthanksAdil
adil

Discussions |
Mar 1, 2013 12:32 PM

3593 views | 0 replies
Chossing between Steel-Dwass All Pairs vs Dunn All Pairs for Joint Ranks

Hello,I have a time series (five time steps) of samples from a population of the same ~60 individuals, each sample being a haphazardly chosen (i.e. not completely random) subset of the 60. The sample sizes each time ranges from about 15 to up to 50, and the measurement I do for each individual in a sample is a continous variable that goes from 0 to 1.Since the sample sizes are different each ti...
avamk

Discussions |
Mar 1, 2013 11:54 AM

6269 views | 0 replies