SQL Connection
I have a SQL database stored on a virtual computer and JMP is on a different computer. Can I create a connection between the SQL database and JMP without having them on the same computer?
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesI have a SQL database stored on a virtual computer and JMP is on a different computer. Can I create a connection between the SQL database and JMP without having them on the same computer?
Dear JMP & Community, I'm trying to set up a Custom DOE where one of the factors has three levels, and each level of this factor MUST be present in each random block only once. Situation: We have a DOE where we know there will be 4 continuous variables that can range between low and high values. We have an additional factor that is a three-level categorical factor. The DOE must be grouped into ...
Hello, I am creating a column formula that works half-right. Using a formula as I don't know JSL.For each Account grouping ==> return the earliest date for that Account IF the Capture value ="TRUE". ELSE leave a blank.Some Accounts don't have any TRUE values and should return nothing but missing v...
Hi,I have an interesting situation (at least to me) for a DOE. I need to design an experiment with 13 variables. Variable X1 and X2 (both numeric) cannot be in the experiment at the same time. If X2 is selected then the X2*X3 <= 1200. Furthermore, the ratio of X6 to X5 must be a whole number.The goal of the experiment is to improve wafer uniformity as measured by etch depth across the diameter of ...
I attached a sample data set and script for reference. I want to generate multiple Normal Quantile distribution charts based upon a set of categorical variables in Col2. In this case there are 16 unique variables in Col2 but that could vary. Currently I am subsetting the data for categorical variable from Col2, then generating the Normal Quantile distribution chart. I just repeat this process for ...
Dear JMP & Community, I'm trying to set up a Custom DOE where one of the factors has three levels, and each level of this factor MUST be present in each random block only once. Situation: We have a DOE where we know there will be 4 continuous variables that can range between low and high values. We have an additional factor that is a three-level categorical factor. The DOE must be grouped into ...
I am trying to set a link ID in JSL, but when setting it in JSL, the link ID seems to be set in the table like it should, but the link reference in the other table that is supposed to reference it does not work.
If I remove the link ID and set it by right clicking on the link ID, everything works fine.
I use this:
dfps:name( "Country" ) << Set Property( "Link ID", 1 );
Can't see what is wrong ...
Hi guys, Recently my company has just upgraded license to JMP16.1 and the previous software i written in vb.net which calls the JMP COM Library is not working anymore. I couldn't find JMP library in COM Reference and manually adding the jmp.tlb from C:\Program Files\SAS\JMP\16\ give me this error below: I tried to reinstall back JMP14 and the TLB is working fine so i guess the problem is not from ...
Hello everyone,
I'm new to jmp and I was wondering a simple thing.
When I do the chi square test I want to compare a binary/dihcotomic variable in my Y (0 or 1) to another dihcotomic variable in the X that is 0 this time vs 1+2+3 together. (in this column I have 4 values from 0 to 3 (0,1,2,3) but I want to first analyze them in only two groups: 0 vs 1+2+3)
How can I unite 1 with 2 and 3 in only one...
Hello, I designed a study with 5 factors (week, lot, etc.) for two different labs, and one of the labs followed the design out of order. They still completed all the parts of the study and the design is still balanced, they just switched the order of the design for weeks 2 and 3. I am analyzing the data for both labs combined. So lab 1 ran the design in order of weeks 1-2-3-4, but lab 2 ran the d...
I have found that hovering over a variable is very useful feature in JMP Script Window/Editor when debugging the script. I have been working with very long script which I have divided to smaller pieces by using Include-feature. I am able to pass variable content correctly between the included scripts but it looks like hovering do not work on included script windows (showing empty variable content ...
Dear community, For the probability profiler as used to analyse data in choice experiment analysis, I am wondering how to optimally set the baseline scenario to compare probability profiler data. Following for instance von Wedel & Hagist (2022), utilize the probability profiler to compare the baseline of the combination of attributes with the lowest marginal utilities. While such an analysis is ...
Hello everyone, passing by to say hello and to share that I created a YouTube Channel with JMP 17 Video Tutorials in english, spanish and portuguese.As an enthusiast about Problem Solving, passionated about JMP and a JMP Partner, I hope you'll come with me, subscribe to the channel and enjoy all the videos that are there and yet to come.https://www.youtube.com/@planaconsultoria Best regards!
If you're looking for some data wrangling puzzles, the Hanukkah of Data series of daily puzzles is underway at https://hanukkah.bluebird.sh/5783/. They're on day 2 of 8 now. As far as I can tell, you can do them whenever and there's no competitive part. I'm doing them in JMP, of course!
HI all,I have a question about an error I'm getting when using @stan_koprowski's slope and intercept add-in. I've posted my question on the add-in's thread but due to the much lower exposure compared to discussion posts, I thought that it might be a good idea to ask here as well. I made a mock data table with three groups and several observations in each group. When I run the add-in I am getting t...
A practical introduction for new users, trial users, and anyone who needs a refresher Registe...
Do you face challenges with restrictive data formats from EDS, XRD, or Raman instruments? Are the ex...
REGISTER HERE If you teach with JMP Student Edition, you should be aware of some lesser known...
Do you want to efficiently and interactively explore data to uncover patterns and see relationships...