JMP User Community

Latest Discussions

How To send a data table as an argument into a function

Hello everyone, So I have been trying to do this for a while now and I can't get my head around it. I'm making a script to export multiple picture from a few different folders. I have created an "import" function and a "trim" function.Import = Function ({path}, dtimport= Multiple File Import ( // the import arguments )<< Import Data; Return (dtimport); }; Trimtables = Function ({table, arg1,...
bobmorrane

Discussions |
Jan 14, 2020 8:06 AM

4804 views | 5 replies
How to get multiple open data table file names for JSL?

Hi:
Assuming that two datatable files have been opened but no table Numbers have been entered in advance, how do can get multiple datatable file names that have been opened?How to jump from the current file to another file?Thank you!
lwx228

Discussions |
Jan 14, 2020 6:44 AM

10687 views | 4 replies
log2 transformation using new formula column

How can I log2 transformation many columns (hundreds) all at once? Is there a way of doing log2 transformation using the new formula column?
Thanks, Neal
rexneal

Discussions |
Jan 14, 2020 5:07 AM

4960 views | 4 replies
Fit Y by X plot or correlation plot for multiple params

I want to do Fit Y by X plot for multiple parameters for 2 groups of data like below. If i only want to perform 1 params, it is pretty straight forward. I will just need to split the temp from row to column, and manually choose param1 temp1 vs param1 temp2. But if i have 100 parameters, it seem not so practically. Is there any other systematic or easy way to achieve this? Tempparam1param2param3p...
OneNorthJMP

Discussions |
Jan 13, 2020 4:38 PM

9485 views | 5 replies
JMP csv import automatically converting hex to dec

Hello, I have a csv file with one of the columns containing data such as 0x62, 0x68, etc. When importing the csv into JMP using JSL open(infile), it is found that JMP automatically converts the column into a Numeric datatype, changing 0x62 to 98 (decimal) in the process. Manually importing the csv not using script, the same issue (auto-converts). It only happened to one of the computers, other com...
ylee

Discussions |
Jan 13, 2020 5:46 AM

4350 views | 4 replies

Previous
Next

Latest Discussions

log2 transformation using new formula column

How can I log2 transformation many columns (hundreds) all at once? Is there a way of doing log2 transformation using the new formula column?
Thanks, Neal
rexneal

Discussions |
Jan 14, 2020 5:07 AM

4960 views | 4 replies
JMP csv import automatically converting hex to dec

Hello, I have a csv file with one of the columns containing data such as 0x62, 0x68, etc. When importing the csv into JMP using JSL open(infile), it is found that JMP automatically converts the column into a Numeric datatype, changing 0x62 to 98 (decimal) in the process. Manually importing the csv not using script, the same issue (auto-converts). It only happened to one of the computers, other com...
ylee

Discussions |
Jan 13, 2020 5:46 AM

4350 views | 4 replies
How do I do a count formula

I have a data set that had 19 million rows. Within that data set I want to count the number of instruments a customer has. I have the customer data in one column and the instruments in another column. My goal is to select customers that only have 1 instrument. Thanks
VR

Discussions |
Jan 10, 2020 4:56 PM

3502 views | 2 replies
Running script from command line on MAC

Not a mac person. Does anyone know how to run a jsl script from command line on a mac? I specifically mean WITHOUT "//!" at the top of it. I have this but it only opens the file unless I have the "//!" open -g -W -a /Applications/JMP\ Pro\ 15.app/ $(pwd)/myscript.jsl
vince_faller

Discussions |
Jan 10, 2020 2:26 PM

1667 views | 0 replies
How to show the exact P-value when running Partial Correlation

I just ran a Partial Correlation with 3 Variables : Paternal Care, Maternal Care and Self-Competence while controlling for Paternal Control and Maternal Control. I did this by going to Analyze-> Fit Model-> Add Paternal Care, Maternal Care and Self-Competence to Y while adding Paternal Control and Maternal Control to Model Effects.I want to know the P-value of the Partial Correlation but can't fin...
nguyentandat234

Discussions |
Jan 8, 2020 2:59 AM

2996 views | 4 replies

Previous
Next

Latest Discussions

Running script from command line on MAC

Not a mac person. Does anyone know how to run a jsl script from command line on a mac? I specifically mean WITHOUT "//!" at the top of it. I have this but it only opens the file unless I have the "//!" open -g -W -a /Applications/JMP\ Pro\ 15.app/ $(pwd)/myscript.jsl
vince_faller

Discussions |
Jan 10, 2020 2:26 PM

1667 views | 0 replies
how to add confounding variable

I am working with a multi level data. Data is attached.In this dataset, I have 8- X variable: cumulative risk (continuous), all other risk (dichotomous). 3- Y variables: insurance and practice (dichotomous) and time (continuous)I have one confounding variable Age (continuous). I will have to add random effect to X variable. But I am confused how to add confounding variable to this analysis. Can an...
billi

Discussions |
Jan 6, 2020 9:39 AM

1603 views | 0 replies
Difference between std error in "Parameter Estimates" and "Least Squares Means Table"?

I am running mixed effects models and have noticed that the standard error for an effect in the "Parameter Estimates" table is different from the standard error reported in the Least Squares Means table for the same effect. How are they calculated differently? Thanks!
Ranae

Discussions |
Nov 26, 2019 11:44 AM

1681 views | 0 replies
How can I run a .py python script and python scripts compiled as .exe from JMP

Hello, So I've written a JMP UI, and once I gather data from the user I have a button that dumps the form data to a CSV.Now I need to launch my python script and other .exe (as an administrator), my python scripts pick up the user input from the CSV and perform the next steps.Right now it's a .py but I may need to run it through py2exe and compile it into an exe later so a solution that supports...
xxvvcczz

Discussions |
Oct 30, 2019 6:44 PM

2078 views | 0 replies
Analysis of covariance (ANCOVA) for Split plot Design

Hi, I have a problem where I want to do ANCOVA and It is new for me.We have,Main plot data (2 treatments)Subplot data (10 treatments)Yield datawe want to add lodging (%) score as a covariate. How to do it? (I have seen some video tutorial from Youtube but its not easy to understand for me) Your cooperation will be highly appreciated.
Harun-Or-Rashid

Discussions |
Oct 29, 2019 9:03 PM

1441 views | 0 replies