JMP User Community

Latest Discussions

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

985 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

893 views | 1 replies
How to insert a list into another list

In Iterate through all combinations of values from ARBITRARY number of lists I posted an answer that required inserting a list into another list of lists. The InsertInto function unpacks the inserted list into elements, which is not what I want. I used an assignment statement to the element one beyond the end of the list, which does insert the list as an element. Another choice is to wrap the list...
Craige_Hales

Discussions |
May 18, 2021 7:37 AM

3884 views | 4 replies
How to connect formulas to dedicated colums instead of row number

Hey everybody,From my predecessor I inherit some data files with these kind of formulas (see also attached file):
Match( :Phase, "Preparation", (:Date_time[2] - :Date_time[1]) / 3600, "Cultivation", (:Date_time[5] - :Date_time[3]) / 3600, "Harvest", (:Date_time[7] - :Date_time[6]) / 3600 ) I would like to exchange the row numbers with dedicated Timepoints, so that it doesn't matter at what ro...
mkunzi

Discussions |
May 18, 2021 6:43 AM

1309 views | 2 replies

Previous
Next

Latest Discussions

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

985 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

893 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
Alert in model extrapolation control feature

In the extrapolation control feature available in JMP 16 Pro, I've had several cases where the profiler contains feasible ranges when extrapolation control is turned on, but when I clicked "Output Random Table", the alert "Unable to find any random feasible points" appears. How to fix this problem? Thanks!
Xinjie

Discussions |
May 18, 2021 3:55 AM

1080 views | 1 replies
Iterate through all combinations of values from ARBITRARY number of lists

Can somebody suggest a solution to this.I have multiple lists. I need to iterate through all possible combinations of values from these lists. The problem is that the number of lists I'm taking values from is decided at runtime. So I cannot write two nested 'for' loops for two lists and then three nested 'for' loops for three lists. I need somehow to pass\parse names of the lists (probably as a li...
miguello

Discussions |
May 17, 2021 5:06 PM

2196 views | 1 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

1178 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