JMP User Community

Latest Discussions

How to store Import Settings of Open() function in a separate expression

I need to open CSV files with various settings.One of the examples is below:dt = Open( filePath, Import Settings( End Of Line( CRLF, CR, LF ), End Of Field( Comma, CSV( 0 ) ), Strip Quotes( 1 ), Use Apostrophe as Quotation Mark( 0 ), Use Regional Settings( 0 ), Scan Whole File( 1 ), Treat empty columns as numeric( 0 ), CompressNumericColumns( 0 ), CompressCharacterColumns( 0 ),...
miguello

Discussions |
Apr 7, 2022 9:54 AM

1368 views | 3 replies
3-way Anova_ Lost DFs problem

Hello, in my experiment I have two group of different cultures, each group is made of female and male (gender) and each participants can give correct and incorrect response, to the stimuli which are black/n/white or coloured. I tryed to perfom a 3-way anova with the fit model Y=response time (continuos variable) and X I did a full cross with culture, gender and colour; I also nest subjects with ge...
Valee

Discussions |
Apr 7, 2022 5:52 AM

764 views | 1 replies
请问表格文件损坏能否修复？

大家好! 压缩格式的表格文件能否修改？谢谢！
lala

Discussions |
Apr 7, 2022 5:51 AM

996 views | 2 replies
Read CSV line by line to find where data starts

I need to load aCSV file which might be in number of different formats. And I need to find what line my data starts on. I know that the column names start after a certain line, let's say "[Data starts here]".This is what I do:ex = Load Text File( filePath ); words = Words( ex, "\!n\!r" ); headersLocation = Loc(words, "[Data starts here]");and then I use headersLocation+1 to specify where my heade...
miguello

Discussions |
Apr 7, 2022 1:02 AM

1557 views | 2 replies
How can i add "competing casuse lines" in a Kaplan- Meier plot

Hi,I am trying to do a Kaplan Meier plot eg comparison of survival across 2 treatments (Placebo vs drug) ( i am using <JMP PRO 16>). Once i get my "failing" plot, i would like to control for a covariate eg age or sex. I would like to have in the same Kaplan Meier plot the additional 2 lines, of the corrected result for the covariate (eg sex). However, what JMP does is to create a second plot with ...
Eleni

Discussions |
Apr 6, 2022 12:50 PM

1946 views | 6 replies

Previous
Next

Latest Discussions

3-way Anova_ Lost DFs problem

Hello, in my experiment I have two group of different cultures, each group is made of female and male (gender) and each participants can give correct and incorrect response, to the stimuli which are black/n/white or coloured. I tryed to perfom a 3-way anova with the fit model Y=response time (continuos variable) and X I did a full cross with culture, gender and colour; I also nest subjects with ge...
Valee

Discussions |
Apr 7, 2022 5:52 AM

764 views | 1 replies
请问表格文件损坏能否修复？

大家好! 压缩格式的表格文件能否修改？谢谢！
lala

Discussions |
Apr 7, 2022 5:51 AM

996 views | 2 replies
JSL vs VBA

我想看看代码之间如何互相转换。谢谢!具体的内容在下面(看看英文的标题、社区的自动翻译的效果怎样)。
lala

Discussions |
Apr 6, 2022 2:48 AM

1223 views | 3 replies
How to select column from 1 to n

I am trying to select transpose column by the column number,Considering there are too many column, is there a way to select from column(1) to column(n)I am currently using below method which won't work when n>9999.Thanks Transpose(
columns(
Column( 3 ),
Column( 4 ),
.............
Column( 9999 ))
Stokes

Discussions |
Apr 6, 2022 1:33 AM

1611 views | 2 replies
Script colonne CV pour une sous sélection du tableau

Bonjour, J'essaie de faire un script qui me permettrai d'obtenir le CV entre différentes données d'un même échnatillon. J'ai 3 échantillons différents, chacun avec 7 répétitions. Je dois faire le CV pour les 3 premières répétitions seulement, les autres me servant pour une autre étape.
Comment dois-je procéder? Je suis novice en script. Voilà ce que j'ai fait mais 2 soucis:
- seule la première li...
mgerusdurand

Discussions |
Apr 5, 2022 12:38 PM

1217 views | 2 replies

Previous
Next

Latest Discussions

Column Switcher Button Removed from Plot Window Toolbar in JMP 16 for Mac

Recently switched from JMP15 for Mac to JMP16 for Mac. I was surprised to see the column switcher button removed as an option in an analysis/plot window. It used to reside up top next to the local data filter button (see black circle). The option to customize it back is also missing and has been replaced by a 'properties' button. This may also prove useful but I'm new to it. To get the colum...
datanaut

Discussions |
Mar 17, 2022 3:18 PM

842 views | 0 replies
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

599 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

771 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