JMP User Community

Latest Discussions

File Saving and Overwriting

I have a JSL scripts that opens and closes serval sheets. While they're open, it merges the documents into a single file, then saves the file into a local folder. The script currently overwrites the existing file in the local folder. Is there a script that would populate a new file in a subfolder (ideally, distinguished by tagging the a timestamp of creation onto the title "Merged") every time the...
Arocha1

Discussions |
Feb 11, 2022 12:57 PM

3411 views | 5 replies
JSL Saving EXCEL format and Keeping Leading Zeroes

Greetings, I have a JMP file that has leading 0s in several of the columns that I want to keep. Data Type is Character... and Modeling Type is Nominal When I save the file into EXCEL format using the JSL code below, the leading 0s disappear. Is there anyway to keep them in?
du = Cust_join << Save( Concat("C:\file",Format( Today(), "yyyymmdd" ),".xlsx") );

I suppose script some code that puts an a...
fat_angus

Discussions |
Feb 11, 2022 7:09 AM

2188 views | 5 replies
Model 'locked' to first point value

I'm studying a decay process as shown for a number of samples below. The higher the starting point, the faster the decay. The idea is to predict the value at any timeopint from measured Initial value. I would like to 'lock' the model so that at timepoint zero, the predicted value is exactly the measured Initial value. If not, predictions as short time times can be very off for some samples, as in ...
Ake

Discussions |
Feb 11, 2022 5:43 AM

2996 views | 6 replies
How to merge multiple graphs to one?

Greetings from Japan, I'm Ryo and want to create merged graph like below image in JMP.I've just tried several settings but seems difficult for me...Does anyone can help me how to reach this? Thank you and kind regards,
ryotaro_seiren

Discussions |
Feb 10, 2022 1:34 PM

2531 views | 2 replies
SAS to JSL - Do Loops...

I am a long time SAS user being forced to learn JSL... Things I found easy in SAS seem so difficult in JSL... Could someone show me how Do Loops work in JSL by sharing with me JSL code that would generate the following nested do loop table using JSL? data frustration; do temp = 1 to 10 by 1; do press = 5 to 20 by 5; do time = 1 to 1000 by 20; output; end...
fat_angus

Discussions |
Feb 10, 2022 12:03 PM

5673 views | 12 replies

Previous
Next

Latest Discussions

JSL Saving EXCEL format and Keeping Leading Zeroes

Greetings, I have a JMP file that has leading 0s in several of the columns that I want to keep. Data Type is Character... and Modeling Type is Nominal When I save the file into EXCEL format using the JSL code below, the leading 0s disappear. Is there anyway to keep them in?
du = Cust_join << Save( Concat("C:\file",Format( Today(), "yyyymmdd" ),".xlsx") );

I suppose script some code that puts an a...
fat_angus

Discussions |
Feb 11, 2022 7:09 AM

2188 views | 5 replies
Model 'locked' to first point value

I'm studying a decay process as shown for a number of samples below. The higher the starting point, the faster the decay. The idea is to predict the value at any timeopint from measured Initial value. I would like to 'lock' the model so that at timepoint zero, the predicted value is exactly the measured Initial value. If not, predictions as short time times can be very off for some samples, as in ...
Ake

Discussions |
Feb 11, 2022 5:43 AM

2996 views | 6 replies
How to merge multiple graphs to one?

Greetings from Japan, I'm Ryo and want to create merged graph like below image in JMP.I've just tried several settings but seems difficult for me...Does anyone can help me how to reach this? Thank you and kind regards,
ryotaro_seiren

Discussions |
Feb 10, 2022 1:34 PM

2531 views | 2 replies
Have a y function change with a local data filter.

I'm trying to draw on a graph some curve. But that curve is different for some set of variables. I'm wondering if anyone has a good way to make yfunction() change based off what's selected in a local data filter. For instance, if I change age from 12 to 13, below, I want a cosine wave instead of sin wave or something like that. Note: this is for JMP live, so I don't think filter change hand...
vince_faller

Discussions |
Feb 10, 2022 6:11 AM

1588 views | 4 replies
Move "Group Y" to the left side of the graph plot in Graph Builder

Is there a way I can move the "Group Y" in Graph builder so it is on the left side of my graph, rather than the right side (default location)?
Raybob

Discussions |
Feb 9, 2022 11:46 AM

2088 views | 4 replies

Previous
Next

Latest Discussions

No table linking after saving the project?

Hi,when I generate a summary table with the option "link to original data table" (selected by default), the two tables are linked:By selecting a row in the summary table the corresponding rows in the original table are selected.Cool.This also works for selections in Graphs and Dashboards.Very cool! Now my problem:After saving both tables to a project file, (precisely: after close & re-open the pro...
hogi

Discussions |
Feb 3, 2022 4:19 AM

598 views | 0 replies
Setting Guardbands on Test Limits Using EMP

Hello. I am trying to use the EMP tool to help set guardbands to my test limits based on my gauge R and R data from a final test machine.I used 10 devices and measured these devices 5 times each, across 5 different test sites on the machine.I need to know how much to guardband my Upper and Lower specs. I am having trouble understanding how to apply the data in the EMP report. I feel like this is a...
Jbritsch04

Discussions |
Feb 2, 2022 8:49 AM

769 views | 0 replies
How to introduce lower bounds for simulated data in Profiler platform

Hi JMP community, (JMP Pro 16.0.0) I'm hoping to find out if there is a way to include lower bounds to simulated data in the Profiler platform. I have several predictors going into a model, but few data points to fit. So, in order to generate simulated ("synthetic") data, I use the Prediction Profiler platform along with the multivariate correlation structure of the data to generate thousands ...
SDF1

Discussions |
Feb 1, 2022 11:09 AM

589 views | 0 replies
Query Builder filtering on date stored in Varchar(20)

Query Builder - date filter.SQL ServerJMP version 16.2In the database (SQL Server) I get the Date field called RETURNDATE in ‘varchar20’ – I would like to use the Calendar functionality in the filter to select my dates I tried to create a calculated column (Calc1) and specify CAST([RETURNDATE] as date), which he doesn’t like. Using SQL outside Query BuilderSELECT TOP (1000) [LABJOBNO] ,[DESPA...
HansD

Discussions |
Jan 25, 2022 6:12 AM

1391 views | 0 replies
M1 Macbook Pro JMP Capabilities

Hi all,
I'm thinking about upgrading from my windows set-up and running a M1 Macbook Pro as my primary set up. I wanted to open up the discussion and see if any other JMP users were using the newest Macbook Pro and if they have run into any hurdles yet? I do a lot of R/Python integration. I do have a decent set up right now, but want to know if anyone else has tested out this connection and knows ...
MikeDereviankin

Discussions |
Jan 21, 2022 1:52 PM

789 views | 0 replies