parsing datetime field
I'm trying to parse a date+time but without success.a = "11/9/2012 8:58:19 AM";b = Parse Date(a, "d/m/y h:m:s"); // Returns "."Is there a way to parse a date+time like this?

Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesI'm trying to parse a date+time but without success.a = "11/9/2012 8:58:19 AM";b = Parse Date(a, "d/m/y h:m:s"); // Returns "."Is there a way to parse a date+time like this?
Hello, I'm a bit of a JMP beginner was hoping to get some help with the following:Is there anyway to increase the default number of levels from 30, to something higher?I'm trying to build a regression tree on some data, with various categorical variables with levels ranging from 31-111.Cheers for any helpJP
Hi,I have a JMP script that produces a table (of analyzed data) with test names in the first column.I was wondering if I could link each test name to a script that would then produce a series of graphs.Does anyone know if that is at all possible?Thanks,Olivia
I am generating new columns by adding some columns. The columns to add, I get the names from a file and build the names as a array list. The column names and number of columns could change. When the number of columns change, I am having to edit the formula to reflect the change. Using the column names array list, is there a way of dynamically adding them in the formula, without having to specify e...
Hello,I'm new to JMP and I have a simple question:I have the attached kind of data.Now I need the following.For every item from TypeA and one Matrix2 (=GroupBy) --> Done by Sorting in the TableI have a range of distance values (such as the once highlighted in bold in the csv)and now I need a new column with the min-max normalized distance values: e.g. for row1:(1296,732785897795 - min(1296,7327858...
I'm trying to parse a date+time but without success.a = "11/9/2012 8:58:19 AM";b = Parse Date(a, "d/m/y h:m:s"); // Returns "."Is there a way to parse a date+time like this?
I am generating new columns by adding some columns. The columns to add, I get the names from a file and build the names as a array list. The column names and number of columns could change. When the number of columns change, I am having to edit the formula to reflect the change. Using the column names array list, is there a way of dynamically adding them in the formula, without having to specify e...
I am using the latest version of JMP and am looking for a way to disable the mean diamonds in my ANOVA output graph. I know you can uncheck the mean diamonds option once you have made the graph, this is what I have been having to do everytime. I am inquiring about a permanent removal solution to the mean diamonds in my ANOVA output box plot graph.
I'm trying to write a script to correctly calculate power for split-unit designs in the Custom Designer and Design Evaluator. The issue is that the correct degrees of freedom aren't used and while they can now be changed, each time the degrees of freedom or signal to noise ratio is changed the outline boxes for Power Analysis collapse and there's a lot of unnecessary button clicking going on. Al...
For example, I have a table dt with n columns, X1, X2, ..., Xn. I need to draw distributions for EACH column, X(i), like below (repeat n times): Distribution( Continuous Distribution( Column( :X1), Horizontal Layout( 1 ), Vertical( 0 ), Normal Quantile Plot( 1 ), Capability Analysis( LSL( 4 ), USL( 22 ), Target( 13 ) ) ));How can I use a loop to do this? I tried the following, but it is not s...
Hi,I am doing a regression analysis for which I got the following equation-Permeation flux= 11.395-0.058 (size)+ 4.136 (elasticity) -0.055 (size *elasticity)I got a interaction profile between size and elasticity but I dont know how to interpret this. I am attaching the profile (untitled)...Can anybody help me understand what this figure suggest.Regards,Shaan
Would someone be able to explain to me if it is possible to control for one of my IV's when performing linear regression? I would like to control for tenure when predicting compensation from performance. I do not want to use a stepwise method. Any help would be greatly appreciated.Thank you!
I tried to create an Bland-Altman plot using the matched pairs option in JMP. Unfortunately, the plot doesn't include the common +-1,96 sd-line and I haven't figured out how to insert this line into the plot. It's no problem to calculate the sd, but I don't know how to integrate it into the plot.Does anyone have an idea on this?Thanks a lot!
Hello I have a sample of 159 individuals and I want to run an exploratory factor analysis and confirmatory factor analysis using SAS .How much individuals should I consider in ordrer to run both of them ? Is there a rule to choice?What are the SAS command associated?Can we do them by JMP,Thank you
I would like select in a data table some variables from a list that I have copied from a previous analysis or from another data table containing those names in cells. Would some body know a straightforward way to do that?ThanksYves
A practical introduction for new users, trial users, and anyone who needs a refresher Registe...
Jump into Graphing Date: Tuesday, September 16Time: 1:00 – 2:30 p.m. ETDuration:&nbs...
Elaborate on Elaborate: Advanced Interactive Reporting & AI-Enhanced Development In this...
Una introducción práctica para nuevos usuarios, usuarios con licencia de prueba o cualquier persona...