JMP User Community

Latest Discussions

Count up

Hello!I need to create a run chart with phases. Each phase is defined by a change in a certain column.COL1 COL2 COL3T=1, R02, P=2, T2=3, R03=5 0 5T=1, R02, P=2, T2=3, R03=5 0 5T=1, R02, P=2, T2=3, R03=5 0 5T=1, R02, P=2, T2=3, R03=5 0 5T=1, R02, P=2, T2=3, R03=5 0 5T...
peder

Discussions |
Oct 5, 2013 6:28 AM

9986 views | 3 replies
Mapping a Network Drive with a DLL

Hello,I'd like to be able to map (and then unmap) to a specific network drive as part of a JSL file using a DLL. Through talking to some internal IT people they've pointed me to mpr.dll and the WNetAddConnection2 and WNetCancelConnection2 functions. However, I'm not an expert programmer and so even though I've looked at the examples in the Scripting Guide and the examples on this discussion board ...
drc_lewis

Discussions |
Oct 2, 2013 6:15 AM

9887 views | 3 replies
using JSL to rename 'Oneway( )' output filename?

I have been using 'output table name( )' to rename all of my summary tables, but this does not seem to work for with oneway( ):
example:dt_Oracle<<Oneway( Y( :Average ), X( :TOOL_ID ), Each Pair( 1 ), Box Plots( 1 ), Comparison Circles( 1 ), X Axis Proportional( 0 ), Grand Mean( 0 ), By( :Rec ), output table name("OneWay_"||tool||"_Average by Tool_ID_"||startDate||"_to_"||endDate||"_origin...
jmpbeginner

Discussions |
Sep 30, 2013 12:13 PM

8575 views | 2 replies
How to convert string date into datetime value

Hi all, Using JMP10 I import csv data with string date like yyyy-mm-dd-hh:mm:ss:SSSSS , example 2013-09-01-14:02:33:759000. For jmp it is CHARACTER How to convert this string date format into a "real" datetime (NUMERIC) like yyyy-mm-dd hh:mm:ss or yyyy/mm/dd h:m:s ? Thanks geof
geof

Discussions |
Sep 26, 2013 6:44 AM

25978 views | 5 replies
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

18897 views | 3 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

3224 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

3310 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

12738 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

3952 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

6993 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

3224 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

4126 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

3590 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

6267 views | 0 replies