Today’s Friday Function is a utility that converts a datetime into a day of the week, expressed as a string. JSL contains a function Day Of Week which gives the day as a number; this number is used as an input into a Choose function to convert it to a string.
Monthly Archives: October 2016
Box-Cox Transformation
Box-Cox transformations have always been a feature that has been tucked away under the red triangle options of Fit Model. In version 13 of JMP this functionality is brought to the foreground. It appears as default output when you choose the Effect Screening emphasis.
(more…)
Column Exists
This Friday’s function is a simple utility to determine whether a column exists in a table.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
Column Exists = Function({dt,colName},{Default Local}, Try( lstNames = dt << Get Column Names(string); pos = Loc(lstNames,colName); If (NRows(pos)==0, retVal = 0 , retVal = 1 ) , retVal = 0 ); Return(retVal) ); |
Typically I use this in conjunction with an Assert function:
1 2 3 |
Assert( Column Exists(dt,col), "Column Not Found" ); |
The Last 9 Months
This has been a busy year for Pega Analytics. I’d like to take a few moments to review what we have been doing, and what is in the pipeline.
The beginning of the year saw two major initiatives: creating a new website and building a new introductory course for JMP.
Over the summer we built a course that was specifically designed to align with the book Visual Six Sigma. First delivery of the course has just taken place to rave reviews! The course was designed to be modular, so we’ll be looking to deliver individual components of the course, for example, running a module on Definitive Screening Designs.
In addition to delivering training courses Pega Analytics specialises in the JMP Scripting Language, and we’ve been involved in some really interesting projects during the year. One such project has been the development of an Ambr Connector for importing data from a TAP Biosystem into JMP.
Virtual Columns
This is one of a series of posts highlighting new features available in version 13 of JMP.
Joining tables has gotten much easier in version 13 of JMP. In fact you can get the benefits of joined data without actually performing the join! This new feature is referred to as a virtual join, and gives you access to virtual columns in a data table.
Friday’s Function
I have a library of utility JSL functions that I rely on to perform common tasks. Each Friday I will publish one of them; starting today.
Take This JSL Challenge
Calendar Box
New Formula Editor
This is one of a series of posts highlighting new features available in version 13 of JMP.
The formula editor has had a big revamp. If you liked the old editor, don’t worry, it works the same way, but it has been re-designed to utilise screen space more efficiently and enhance the workflow.