A variable value from user - sql query
I try to get a variable value from the user and use it as a SQL query
How can I add to a query?Thanks!
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resources
I try to get a variable value from the user and use it as a SQL query
How can I add to a query?Thanks!
Hi, I want to use JSL to plot y1 (in log scale) vs. x1 for only Case == a AND Parameter value ==1 and then fit a line to this y1 (in log) vs. x1 (in linear scale). Casex1y1Parametera1.0567061.0583451a1.9146622.4959311a1.8815962.4147522b1.7925292.2089761b1.4524591.5721732b1.4697821.5996462d1.1726291.1884251d1.6139621.8477372d1.5403131.7165453b1.3078251.3604631d1.9344862.5459052a0.650081.9156941b0....
I'm having trouble getting the display I want out of Graph Builder, and I'd like some help.My data is a 3-level-categorical test result; the test is performed monthly.My result column is 1-byte integer, ordinal, with value labels (0 = "low", 1 = "medium", 2 = "high").My time column is numeric, continuous, m/y format. (The test is perfomed once a month on the same calendar day each month.)I would l...
Hello,I'm trying to write a function that refers to a certain row of a column and trying to make it dynamic where I can run it on any column name. Using the Big Class table as sample, I'm trying to run the calculation on the height column but I couldn't get it working unless its hardcoded in the function. Also the lag function doesn't seem to work within a function. This is the script that I have....
How to save a datatable as a script. It's easy but when I Google it the top results aren't the answer. So I'm going to answer my own question.
Hi, I want to use JSL to plot y1 (in log scale) vs. x1 for only Case == a AND Parameter value ==1 and then fit a line to this y1 (in log) vs. x1 (in linear scale). Casex1y1Parametera1.0567061.0583451a1.9146622.4959311a1.8815962.4147522b1.7925292.2089761b1.4524591.5721732b1.4697821.5996462d1.1726291.1884251d1.6139621.8477372d1.5403131.7165453b1.3078251.3604631d1.9344862.5459052a0.650081.9156941b0....
Hi Everyone,I have a query. If I have a table like below. If I plot TIME on X-axis and group the X-axis by TYPE. It will shows all five values on X-Axis for both groups, even if their is no data for that. It unnecessarily using the graph space. One way is I can nest the X-axis(TIME) with column TYPE but this works only when both columns are of type nominal. Is their a way if both columns are of di...
Hi there!I'm a masterstudent in bio-engineering and I'm currently working on my thesis, which includes a lot of data processing. I have 66 features of a signal in about 248 windows (each 5 seconds), which are the input of my classifier. The ouput is the level of a specific symptom, an ordinal variable. I wanted to apply 'feature selection' before the classification because I want to know what phys...
Seems like default graphic for oneway is dots. How do I change that to bars?
I have a question I can't seem to figure out. If I connect to a database, with joins, for example with the query builder. Then I generate a dashboard with graphs. If the database values change, will the graphs be modified automatically too? Or does JMP download the data from the database and, therefore, it will be static? Thanks, Juan Pablo.
One way to select possible number of clusters in hierarchical methods is to identify the relatively large changes in distance as number of clusters change (see table below). When I look at the actual distance measure from the table (clustering history below dendogram), there is a bigger jump from 3 clusters to 4 than from 4 to 5 (smaller), suggesting 4 may be the right decision. However, when you ...
I have a data set from a two-choice rodent feeding trial. We were testing the effectiveness of 10 deterrents by coating them on seeds and offering them to rodents alongside control seeds that were uncoated. The explanatory variable is which of the 10 deterrents the treatment seed was coated with, and the response variable is the proportion of control seed and treatment seed consumed. The question...
Dear JMP Community, When I run repeated measures ANOVAs with JMP (RMS, with Subject as a random factor), I have noticed that when a certain factor is crossed with Subject, the corresponding DF Den stays independent while the DF Dens for the other factors are put together as “Residual”. Please see Images 1-3 of the attached file on how “DF Den” under “Test Denominator Synthesis” change across imag...
I'm working with a dataset of about 27,000 rows and am trying to use 9 factors to predict a response using the partition function and a decision tree. I'm using both k-means and validation. When I tell JMP to Go, it will split 100-200 times, however the Split History shows me very little improvement after about 20 splits. For what I'm trying to do, I want to back up to the 20th split, but I don'...
I'm involved in a project where we are applying lasso to build a logistic regression model from a "black box" set of predictors. I need to get JMP Pro before trying out JMP's implementation. I'm doing all the analysis in R at present. Does JMP Pro also include group lasso? I've found through using JMP Cluster Variables (CLUSVAR) that I can naturally group my predictors prior to group lasso. F...
Una introducción práctica para nuevos usuarios, usuarios con licencia de prueba o cualquier persona...
JMP Live offers JMP users collaborative analytics software to share analyses from JMP to a secure, c...
French Mastering JMP Transformez des données brutes en informations exploitables grâce à l’éditeur d...
EMEA Mastering JMP Experimenting with microbial and mammalian systems brings a multitude of data; bi...