Tips and Tricks for JSL Scripting in JMP - Enhance Your Data Analysis Skills
Explore helpful links, starting points, and tips for JSL scripting in JMP. Learn how to annotate errors, streamline your workflow, and handle complex data tasks effectively. Whether you're a beginner or looking to advance your skills, this guide has something for everyone.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
E N D
Presentation Transcript
JMP User Group Meeting JSL Scripting101 Presenter: Anshuman Singh Date: 4/27/2015 Location: Greenville, SC
Helpful Links https://www.youtube.com/watch?v=bX4oOErDCYo https://www.youtube.com/watch?v=5TUQ_itD1Tg https://community.jmp.com/message/25472#25472 http://www.jmp.com/support/help/Help_with_Learning_JSL.shtml http://blogs.sas.com/content/jmp/2014/08/08/tips-for-the-new-jsl-user/ 2 GE Title or job number 9/27/2024
JSL- Where to start? 1. Not the most user friendly language to learn. 2. You mostly wont need to learn it unless you want to do a repetitive task with consistent results 3. JMP helps you create JSLs and then you can modify them to your needs. 4. You should have the visual of the output you are looking for. 5. The functions, statements, loops and calculations are mostly similar to C/C++, except when you get into embedding sql, matlab, R etc in its code. So a little programming experience will reduce the learning curve. 6. One HUGE help: Scripting Guide PDF book under the Help menu in JMP 7. Sample data sets within JMP and checking their saved scripts 8. JSL Syntax reference PDF within JMP help menu is good for functions search. 9. JSL scripting index is awesome! It will have all the functions and their example JSL script . 3 GE Title or job number 9/27/2024
JMP - Help 4 GE Title or job number 9/27/2024
JMP Help Index: JSL building blocks Go to Help > search the help > type JSL building 5 GE Title or job number 9/27/2024
JSL Tips and Tricks Annotate error lines in log: under preferences > general JSL code folding: under preferences > script editor Commenting an entire section by highlighting. Split window vertically or horizontally. Saving script to data table for future use Big Class! Bootstrap: reset seeds Boston Housing! Bracket highlighter to check for missing brackets. Double click to select 1 entire section contained within the bracket. Reformat script: select code > right click > reformat script for correct indentation. Autocomplete Function shortcut: ctrl+space JSL profiler and debugger example problem! 6 GE Title or job number 9/27/2024
Example Problem I had 5 minutes interval data for 4 years each for 80 units. The data was obtained in 80 separate files; 1 for each unit. Each file is nearly 40MB big with nearly 500,000 rows. My task: Modify the table, add a few columns Create summary of each table Filter data out of the summary table Save all these summary tables in another folder Concatenate all these summary tables for further post processing. 7 GE Title or job number 9/27/2024
Where do I start? Open the csv file in Excel, and click on the JMP tab, to convert it into JMP data-table. Once obtained in JMP, right click on source > edit > script. Copy this script in a new script window. To create new columns, check out this link: https://community.jmp.com/docs/DOC-7272 copy the portion of the script you need. Create summary table and again do, source > edit > script. Copy paste it in main script. Found this to create a script for a subset table https://community.jmp.com/thread/66075 Also used it to filter unwanted data. Found this to figure out how to save the new modified summary table http://www.jmp.com/support/help/Data_Tables_3.shtml 8 GE Title or job number 9/27/2024
Questions? 9 GE Title or job number 9/27/2024
