JMP User Community

Latest Discussions

SQL pulls to SQLserver without setting a machine data source?

Hi JMP community,I am playing with a ODBC connection to a SQLserver, and everything works nice when i connect via open table or query builder. I have then created my own query in JSL to be used with the open database() command, and that works well as well. Right now my connection string looks like this SQLconnect="DSN=MyDatabase;Description=MyDatabase;Trusted_Connection=Yes"; MyDatabase is referr...
DSA

Discussions |
Jan 26, 2018 6:33 AM

5239 views | 2 replies
How can I get only one sheet of excel file as JMP data table?

Hi there, new to the site so forgive me if this has been answered already. Can I import an Excel workbook and only import the first sheet without knowing the name of the sheet? I am trying to loop through multiple excel files and just import the first sheet of each file.
iamericha

Discussions |
Jan 25, 2018 9:05 AM

8526 views | 6 replies
Help on Repeated Measures - Multiple Comparisons

Trying to assess differences within each time point though can't figure out how. New JMP user, using non-Pro version. Response variable is colonization rate over 30 and 60 days, the factors are site (3) and treatment (3). I am using the Manova > Repeated Measures analysis. What I would like to look at is for each site, does the treatment have an effect on the colonization rate for 30 days and ...
janiakd

Discussions |
Jan 25, 2018 9:04 AM

5419 views | 6 replies
Formula Data Type Issue? - Wrong output when comparing two columns

Hi, I'm getting a strange issue in JMP that I can't seem to explain. In my table I am comparing values in two columns. Column "A" is just a simple continuous, numeric column with integer values ranging from 0-100. Column "B" is another simple continous, numeric columns with numbers ranging from 0 - 1, all with precision up to two decimal places. I then create a column "C" to directly compare "A" a...
melissacch

Discussions |
Jan 25, 2018 6:11 AM

7987 views | 5 replies
confirmatory factor analysis

Could JMP perform CFA? I know it does EFA (multivariate--principal component). But does it have the capacity for CFA? Thank you!
xiaoyaj0

Discussions |
Jan 24, 2018 6:21 PM

4867 views | 3 replies

Previous
Next

Latest Discussions

Help on Repeated Measures - Multiple Comparisons

Trying to assess differences within each time point though can't figure out how. New JMP user, using non-Pro version. Response variable is colonization rate over 30 and 60 days, the factors are site (3) and treatment (3). I am using the Manova > Repeated Measures analysis. What I would like to look at is for each site, does the treatment have an effect on the colonization rate for 30 days and ...
janiakd

Discussions |
Jan 25, 2018 9:04 AM

5419 views | 6 replies
confirmatory factor analysis

Could JMP perform CFA? I know it does EFA (multivariate--principal component). But does it have the capacity for CFA? Thank you!
xiaoyaj0

Discussions |
Jan 24, 2018 6:21 PM

4867 views | 3 replies
How do you customize box plot in JMP preferences?

How do you customize box plot in JMP preferences? I am looking to customize the box plot line color and line width one time in JMP preferences. Currently, each time I generate a JMP box plot, I right click on the graph, click on to customize, and change line color and line width of box plot. I do this every time because I don’t like the red color and thin line width on the box plot. Instead, I li...
sam2018

Discussions |
Jan 24, 2018 1:13 AM

6450 views | 4 replies
Joining Two Datasets Using Closest Date Match

Hello all. I am attempting to join two datasets in JMP using a unique identifier plus a closest date match. I have some code here that runs and is pretty close to what I need but I am having trouble with it keeping many to one matches. One unique identifier "EMP_ID_UID" could (or could not) have several "Transaction Dates" and multiple "MED_SCAN_DTIMES" will match one "Transaction Date" (because...
sagrim

Discussions |
Jan 22, 2018 1:22 PM

4726 views | 1 replies
Nonlinear regression using vba automation

Hello, I currently have a working JMP script which automatically fits my raw data using a predictor formula fit1 = Nonlinear(
Y( :Name( "-60" ) ),
X( :Formula ),
Iteration Limit( 100 ),
Newton,
Finish
);
fit1 << Prediction Formula;
fit1 << Close Window; I am now trying to automate this side of things from Excel using VBA. Is it possible to automatically run this non linear regression using vba and paste ...
rinosaur

Discussions |
Jan 22, 2018 1:08 PM

3849 views | 1 replies

Previous
Next

Latest Discussions

Sub-sampling data analysis in JMP

In Biology (Plant Sci. and Agriculture) usually we have sub-sampling data for replicates. It's very difficult to analyze these data in commonly use Stat S/W (SPSS/Minitab) because MSS(Error) is calculating wrongly. Without taking averages of samsamples, the easiest S/W for this is using JMP and I need some assistance for this. I've found very useful Youtube video about subsampling in JMP (CRD: S...
Kynda

Discussions |
Nov 15, 2017 2:32 PM

3913 views | 0 replies
Conceptual question about the profit matrix

This issue has been discussed previously, but I keep finding myself confused about how to use the profit matrix. My question is conceptual in nature, so let's just use some simple numbers. Suppose I have data on customer churn and I build a predictive model for churn (the particular technique does not matter for this question). My decision errors are not symmetric, however, so I want to modify ...
dale_lehman

Discussions |
Nov 10, 2017 6:02 AM

2802 views | 0 replies
Confirmation of Repeated Measures Analysis, when sphericity if voilated

Hi Everyone, I would like confirmation on the appropriate analysis to run on a repeated measures design.Experimental design:Independent variable: Nutrient treatment (Control, Low, Med, High),Dependent variable: basal diameter, 5 replicates (plants)Repeated measurements were taken at Weeks 0, 1, 4, 7, 10, & 12Split data-> Fit Model-> Y: basal 0, basal 1, 4, 7, 10, 12, Add: Nutrient treatmentPers...
uamiller

Discussions |
Oct 23, 2017 8:07 AM

2902 views | 0 replies
Cox Proportional Hazard - adjusting risk ratio with std dev

I'm working with someone who is using SAS and I'm trying to do the same analysis in JMP. When I questioned their hazard ratio they said it was adjusted by the standard deviation. They commented:In order to obtain results in units of 1 standard deviation – you simply get the standard deviation value for parameter of interest and introduce it in the PH regression statement, for example:proc phreg ...
Maureen

Discussions |
Aug 22, 2017 1:18 PM

3513 views | 0 replies
JSL How do I wrap the title text of a OutlineBox?

Hi all, I often use the Set Title() message to overwrite the OutlineBox titles of charts, distributions, etc. My first issue is that the OutlineBox does not support the Set Wrap() message. Is there any replacement I could use? To work around the missing Set Wrap(), I started inserting newlines "\!n" in the tiitle text. After doing this, I have noticed a second issue: Whatever number of newlines I ...
AlexanderKrebs

Discussions |
Jun 13, 2017 5:38 AM

4564 views | 0 replies