JMP User Community

Latest Discussions

JSL creating a spine line for changing group each time

Hello,I have this script: dt = Current Data Table(); listX = {"1","2"}; listY = {"test1", "test2", "test3"}; fybx = dt << FitYByX( Y( Eval( listY ) ), X( Eval( listX ) ), Fit Where( :Group == "BL", Fit Spline( 0.1, Standardized, {Line Color( {213, 72, 87} )} ) ), try(Fit Where( :Group == "Value0", Fit Spline( 0.1, Standardized, {Line Color( {57, 177, 67} )} ) )), try(Fit Where( :Group...
itzikd

Discussions |
May 19, 2021 2:29 AM

1819 views | 2 replies
Constrained variables query

Hi,Can anyone advise a simple way to indicate that either a factor or an effect is constrained within limits ? Examples would include numbers expressed as %'s which must therefore lie between 0 & 100, such as Purity or the Yield of a reaction. This would be especially useful if it can be applied to a data table column, for example, rather than needing to be built into a custom design, thus enabl...
NickT

Discussions |
May 18, 2021 11:54 PM

1729 views | 4 replies
Handling maintenance schedules in repairable systems simulation (RSS)

Hi all, I didn't find a particular topic that addressed this so I was hoping to get some help from some of you folks that use RSS. Basically there's two things I'm trying to do in the simulation engine to account for real-life response for maintenance cycles:1) If I have two parallel components, both of which have failures and scheduled items, I would like to be able to suspend the scheduled item ...
Norman

Discussions |
May 18, 2021 5:03 PM

1162 views | 1 replies
How to recode column names using jsl?

I need to remove the first word from ALL column names and it can be easily done in the Recode Column Names. However, there is no way to save this task as a script in the recode window. I don't see it in the action recorder of JMP 16 either. Can someone help me with writing the JSL code that can do this job for me?
shasheminassab

Discussions |
May 18, 2021 3:05 PM

1864 views | 2 replies
JMP import Excel from columns that are not continuous

My example here is: I have an excel table currently with 50 columns and is continuously growing. I only want to import first 4 column and last 5 column at any time. How do I achieve that with JMP script.
aaronjiang

Discussions |
May 18, 2021 1:41 PM

986 views | 1 replies

Previous
Next

Latest Discussions

Constrained variables query

Hi,Can anyone advise a simple way to indicate that either a factor or an effect is constrained within limits ? Examples would include numbers expressed as %'s which must therefore lie between 0 & 100, such as Purity or the Yield of a reaction. This would be especially useful if it can be applied to a data table column, for example, rather than needing to be built into a custom design, thus enabl...
NickT

Discussions |
May 18, 2021 11:54 PM

1729 views | 4 replies
Handling maintenance schedules in repairable systems simulation (RSS)

Hi all, I didn't find a particular topic that addressed this so I was hoping to get some help from some of you folks that use RSS. Basically there's two things I'm trying to do in the simulation engine to account for real-life response for maintenance cycles:1) If I have two parallel components, both of which have failures and scheduled items, I would like to be able to suspend the scheduled item ...
Norman

Discussions |
May 18, 2021 5:03 PM

1162 views | 1 replies
JMP import Excel from columns that are not continuous

My example here is: I have an excel table currently with 50 columns and is continuously growing. I only want to import first 4 column and last 5 column at any time. How do I achieve that with JMP script.
aaronjiang

Discussions |
May 18, 2021 1:41 PM

986 views | 1 replies
PostgreSQL query update issue

While creating query in postgreSQL we need to use double quotes around every column name. In JMP scripts it is not allowing us the query with double quotes and throwing error. Note: We are able to connect postgreSQL server successfully. While running query we are getting error saying "," or ")" missing.
MayurRJaiswal

Discussions |
May 18, 2021 9:36 AM

894 views | 1 replies
Screen for important effects from multiple nominal variables with 1 continuous response, using historical data

Hello,I'm new to JMP and I'm learning about statistical analysis. I would like some pointers on what I'm trying to achieve. Let's say I am working on expressing a protein using a bacteria.
I have one response : Yield (mg/mL)I have multiple (nominal) elements regulating the expression in the bacteria : - Type of expression promoters : PromA, PromB, PromC, PromD, ... etc (I have 20+ choices) - Type...
Marie-Eve

Discussions |
May 18, 2021 6:37 AM

2402 views | 5 replies

Previous
Next

Latest Discussions

Can I control text size in a word cloud inside a dashboard container?

Hi all,I have a dashboard with a data filter, a map, and a word cloud that looks like image 1 below. I have two formatting issues with the word cloud I'd like to fix. First, by design, when I make different selections using the data filter, the subset of records that are shown in the map changes and the word cloud applies only to that selection. However, when I change the data filter selection, th...
caseylott

Discussions |
Apr 28, 2021 12:03 PM

1264 views | 0 replies
多重比較での生存曲線の書き方　Bonferroniなど

4群での生存曲線をJMPproでの書き方を教えて下さい。また、JMPで「環境設定グループ」から「レポート」を選択し、「ローカルデータフィルター」を出せればできる方法も紹介されていたのですが、「ローカルデータフィルター」を出せません。どの方法でもよいので、JMPProで、多重比較法を用いた生存曲線の書き方をどなたか教えてください！宜しくお願い致します。
27070

Discussions |
Apr 20, 2021 1:41 AM

2270 views | 0 replies
Fantasy Baseball League

I am in a 16 team fantasy baseball league. Each week we tabulate totals for home runs, batting average, stolen bases, wins, saves, era, etc. If my team has the most home runs, I win that category for the week. We track 10 statistics so after each week I may have a final score of 6-3-1. My question is how can I use JMP to check what my score would have been if I had played each of the other 14 team...
atlas100

Discussions |
Apr 19, 2021 1:29 PM

968 views | 0 replies
Generation of overdispersed poisson count data (vs gamma poisson)

Hello, I would like to reconcile the parametrization used in the Random Gamma Poisson(lambda, sigma)with the over-dispersion parameter as estimated in generalized linear model platform. Take for instance the attached table. Here the generating function is Random Gamma Poisson(exp(1+3*:X1),10)Running glm with poisson/log + overdispersion I obtain: Overdispersion = 6.09. Is there any way to link...
matteo_patelmo

Discussions |
Apr 12, 2021 9:53 AM

1179 views | 0 replies
JSL Syntax Change is coming: Name() is being deprecated

Hi All, I just read here that the JSL syntax for referencing a column using the Name() parser is going away. The new syntax is currently in use and at some point the old syntax will be removed entirely. There's a lot of people here who script, so thought it would be good to post something here. I know I have a lot of code I'll need to change! Better to be ahead of the curve and change it befor...
SDF1

Discussions |
Apr 7, 2021 10:14 AM

884 views | 0 replies