JMP User Community

Latest Discussions

Error tracing: JMP tries to "help"

JMP helps the user to "trace" errors in JSL code: It doesn't indicate the line of code where the error "happens".
It tries to find out where the actual error is in the code and shows this line.In the below example, the error message just shows up if line 6 is uncommented --> error "happens" in line 6.
But the erroneous code (Graph Bulder without "i") is in line 4.And JMP, indeed mentions line 4 -> ...
hogi

Discussions |
Nov 13, 2022 6:38 AM

1331 views | 1 replies
connect to SQL databse programmatically

Hi,I am trying to connect to an SQL database in a script using theOpen Database command.Now, when I work interactively, I create a "Machine Data Source" fromthe database conect widget. When I connect, a window opens up askingfor username and password. When I insert them, I can succesfully connectto the database and import tables into JMP.So I would like to try the same from a script. Unfortunately...
paologrigis

Discussions |
Nov 12, 2022 2:32 PM

66073 views | 11 replies
How to change point color in a control chart based on stratification?

By default I get a black marker colour for all plotted points on an individuals chart, as shown in attached file.Supposed I want to stratify in some way and change the marker, or point, colour. In the attached this is the second column (column titled "Material").How could I do this? For example, make all the values on the chart associated with 'A' be green, the 'B' values black and the 'C' values ...
scottahindle

Discussions |
Nov 12, 2022 7:41 AM

8216 views | 4 replies
How to send messages to an already existing local data filter inside a graph builder window

Is it possible to send messages to a local data filter inside a graphbuilder object?Unfortunately, it's not possible to define a varaible "ldf" inside the graphbuilder code - to send the messages to "ldf".Do I have to "pipe" the message "through the gb object"? View more...dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt << Graph Builder( Size( 534, 464 ), Show Control Panel( 0 ), Graph Spacing(...
hogi

Discussions |
Nov 12, 2022 5:51 AM

2295 views | 6 replies
GLM / Poisson with Overdispersion // use of AICc

Hello. I have encountered the following issue while modeling with GLM/Poisson the data in the attached table (Response = Count, Regressor = X). Data visual exploration suggests a clear relationship between X and Count, but comparison of AICc for model with X vs null model favors the Null model (just intercept). Scripts to reproduce the two models are embedded. I believe I have found an explanatio...
matteo_patelmo

Discussions |
Nov 11, 2022 9:59 PM

2827 views | 6 replies

Previous
Next

Latest Discussions

Error tracing: JMP tries to "help"

JMP helps the user to "trace" errors in JSL code: It doesn't indicate the line of code where the error "happens".
It tries to find out where the actual error is in the code and shows this line.In the below example, the error message just shows up if line 6 is uncommented --> error "happens" in line 6.
But the erroneous code (Graph Bulder without "i") is in line 4.And JMP, indeed mentions line 4 -> ...
hogi

Discussions |
Nov 13, 2022 6:38 AM

1331 views | 1 replies
Excluding data from Graph Based on Value

Is there a way to graph data, if it occurs 2 or more times?

For instance:
Column 1: Family Name
Column 2: Rooms of the House with a Television in it

Is there a way for me to sort and graph my data to only include families with 2 or more Televisions?
ClusteredTable4

Discussions |
Nov 11, 2022 6:07 PM

1573 views | 3 replies
Opening a specific date range from SQL tables

I open a lot of tables from SQL and I would like to be able to open just the previous 7 days. So when I run the script I want it to look at the date/time column on the sql table and open only the data for the previous 7 days. Here is my open table script:
Open Database(
"DSN=0.20;UID=****=****;APP=JMP;WSID=VJDSTATION;DATABASE=BioControl;",
"SELECT * FROM dbo.VisitLog", "VisitLog"
); The column I want...
JocelynJohnson

Discussions |
Nov 11, 2022 1:29 PM

1597 views | 1 replies
Regex Issure with Decimals and Whole Numbers

Hello! Using JMP 16.2: I have a column with whole numbers and decimal numbers. I want to create a new column that flags the whole numbers (or the decimals). Column Name: ValueColumn Inputs:0.533.76810etc. I have tried several versions of the following Regex using a column formula:Regex(Value,"\d+\,\d+", "Decimal")Regex(Char(Value),"\d+\,\d+", "Decimal")I have also tried parentheses and brackets t...
Maerawlings

Discussions |
Nov 11, 2022 10:11 AM

2293 views | 3 replies
How to add the date to file name while uploading a file to s3 bucket using alteryx

I have a workflow in alteryx where I am downloading two files from two different urls. After making the required modifications I want to upload them to the s3 bucket as well as save a copy locally. I want to add the current date while saving the file in both cases. I was successful in using a formula tool to rename the file saved locally. But unable to do for the copy being uploaded to s3. Can any...
pavanroast

Discussions |
Nov 11, 2022 3:03 AM

1058 views | 1 replies

Previous
Next

Latest Discussions

Linear mixed model not showing "Random Effect" noise in simulator/monte carlo

I have fit a Mixed Model via the Fit Model platform in JMP Pro. When opening up the 'Prediction Profiler', and inspecting the Profiler itself, I can see the as expected predicted response and its as expected confidence interval in [], which reflects the variation due to the Random Effects I have fit. However, when I run the 'Simulator' with equal experimental variables as above, and after adding ...
Vartian

Discussions |
Nov 8, 2022 5:38 AM

865 views | 0 replies
Monte Carlo / Simulator from Mixed Model not showing "Random Effect" noise

I have fit a Mixed Model via the Fit Model platform in JMP Pro. When opening up the 'Prediction Profiler', and inspecting the Profiler itself, I can see the as expected predicted response and its as expected confidence interval in [], which reflects the variation due to the Random Effects I have fit. However, when I run the 'Simulator' with equal experimental variables as above, and after adding n...
Vartian

Discussions |
Nov 4, 2022 12:48 PM

677 views | 0 replies
How do I save plots/images at a specific size when they are generated in a project?

Hi,when I generate images within a project the window size attribute is ignored (the plot is always maximized). How do I prevent this to define a specific image size, esp. when the plots are saved? Best regards,Ole @martindemel
OHS

Discussions |
Nov 4, 2022 6:53 AM

689 views | 0 replies
JMP 17 Trial - windows server not supported

Dear members of the forum, I have just came across this issue during an attempt to install JMP 17 trial version on a windows server. Any ideas? Edit: I contacted JMP support and they confirm that the trial version will not work on windows server.
ron_horne

Discussions |
Nov 1, 2022 2:20 PM

1202 views | 0 replies
How to run JSL script in user opened JMP session instead creating a new seesion by JMP.dll?

Currently I developed a windows application based on Interop.JMP.dll. The application contains a functionality to generate JSL file and run it in JMP but I got a issue now. It seems can only create a new session and run it by application instead of using the session that user opened first. I'd like to confirm whether it's possible to run JSL in the session by user opened manually. Appreciate it if...
SquaresDingo505

Discussions |
Oct 24, 2022 7:23 PM

740 views | 0 replies