JMP User Community

Latest Discussions

col mean with byVar argument not running in script

I am trying to use the Col Mean function with 2 additional columns to group by. The formula works perfectly when I manually enter it, but when I copy it into my script and run I get only one (incorrect) number in the first row. If I click in to view the formula and then hit apply the column the properly populates. This seems to be specific to trying to add the byVar argument as my col mean formula...
chappe

Discussions |
Feb 7, 2023 1:10 PM

2063 views | 4 replies
Reason: Unable to open in ReadWrite mode.

Hello,I'm trying to save the report window as PDF and HTML file but it's saving only half of them and during HTML file creation it's showing this error:"There was an error writing the Web output file V:\User\User Reports\Beverly Jones\Yield Tracking\23Jul2015\Fill Yield (g\AdjAs L).htm.Reason: Unable to open in ReadWrite mode. The system cannot find the file specified."Log Snapshot:Code:display=Fu...
vs90

Discussions |
Feb 7, 2023 11:18 AM

12346 views | 2 replies
Combinations of a list put into columns

I'm trying to take a list of things and make all possible pairs of combinations appear in a set of two columns. I currently have a script generated that does permutations (plus repeates of the same value in col a vs col b) but I'm struggling on how to reduce it down to combinations. For example, if the list of things was 1, 2, 3, 4, 5 then I don't need both 1/2 and 2/1, or 1/1. Below is my scrip...
JM13

Discussions |
Feb 7, 2023 10:26 AM

4228 views | 9 replies
How to fix the lower control limits to 0 for time based processes

I'm creating a control chart for a time based process and I get a negative control limit. Since this is a time variable with a minimum value of 0 then showing negative time is not appealing. How do I fix the LCL to 0 and not show negative control limits?
chanela

Discussions |
Feb 7, 2023 9:44 AM

14030 views | 6 replies
Counting and Using Row Identifier

Hello All,

Wanted to ask a question regarding counting of rows. I am attaching a data table which should hopefully illustrate the example.

So I have data where the main variable is density of features. There is a unique value of the density per each ROI, per each sample (ID). In the normalized variable I am taking each density value per each ROI per each sample with unique ID and dividing by the wh...
Ekarshalev

Discussions |
Feb 7, 2023 8:58 AM

3471 views | 7 replies

Previous
Next

Latest Discussions

col mean with byVar argument not running in script

I am trying to use the Col Mean function with 2 additional columns to group by. The formula works perfectly when I manually enter it, but when I copy it into my script and run I get only one (incorrect) number in the first row. If I click in to view the formula and then hit apply the column the properly populates. This seems to be specific to trying to add the byVar argument as my col mean formula...
chappe

Discussions |
Feb 7, 2023 1:10 PM

2063 views | 4 replies
Combinations of a list put into columns

I'm trying to take a list of things and make all possible pairs of combinations appear in a set of two columns. I currently have a script generated that does permutations (plus repeates of the same value in col a vs col b) but I'm struggling on how to reduce it down to combinations. For example, if the list of things was 1, 2, 3, 4, 5 then I don't need both 1/2 and 2/1, or 1/1. Below is my scrip...
JM13

Discussions |
Feb 7, 2023 10:26 AM

4228 views | 9 replies
Counting and Using Row Identifier

Hello All,

Wanted to ask a question regarding counting of rows. I am attaching a data table which should hopefully illustrate the example.

So I have data where the main variable is density of features. There is a unique value of the density per each ROI, per each sample (ID). In the normalized variable I am taking each density value per each ROI per each sample with unique ID and dividing by the wh...
Ekarshalev

Discussions |
Feb 7, 2023 8:58 AM

3471 views | 7 replies
Authenticate DBC user and pass before storing them for future use

Hi,I am writing some code to pull data from an ODBC connection. I want to test if the username and password entered are valid. The script is as follows: dbc = Create Database Connection("Driver={Oracle in instantclient11_1}; DBQ=" || target || "; UID=" || user || ";PWD=" || pass || ";FBS=12800000;");I found some solutions suggesting checking if dbc is empty to see if the connection was created as ...
SivaSubram5313

Discussions |
Feb 7, 2023 4:52 AM

1323 views | 2 replies
対応分析のデータをクレンジングする方法を教えてください。

対応分析をする前に、データをクレンジングしたいのですが、目的変数の項目が多い場合、いちいち入力することはなく分析をできる方法教えてください。
Chisa315

Discussions |
Feb 6, 2023 4:51 PM

1059 views | 1 replies

Previous
Next

Latest Discussions

JMP Script Window - Hovering over a variable do not show the value stored in the variable if passed between scripts

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 ...
JanneI

Discussions |
Jan 27, 2023 5:51 AM

801 views | 0 replies
Choice experiment: probability profiler baseline assumptions

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 ...
Declan_JMP

Discussions |
Jan 23, 2023 3:54 AM

1616 views | 0 replies
Can we find some tutorials videos in YouTube?

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!
Matheus_Plana

Discussions |
Jan 15, 2023 10:27 AM

1657 views | 0 replies
Data puzzles via Hanukkah of Data is underway

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!
XanGregg

Discussions |
Dec 19, 2022 11:21 AM

825 views | 0 replies
Slope and Intercept Collector error "matrix must be non-singular in access or evaluation of 'Inv' , Inv/*###*/(x` * x)"

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...
Lavik17

Discussions |
Dec 19, 2022 10:20 AM

965 views | 0 replies