Welcome to the JMP User Community!

Latest Discussions

• Joining differnt size data sets

   I am trying to pull a data point from one data table into another data table. Above is an example. A simple join does not seem to get me where I need to go. The data table on the left in reality is quite large(800K rows). I would like to match between the two data tables based on jar id and seq id. Then create a new column in the table on the left with the TOTE ID and populate it with data from t...

  Sciguy_1

  Discussions |

  Jun 14, 2019 12:07 PM

  4814 views | 3 replies

• Pasting Clipboard into external documents using JSL

  I am trying to use JSL to automatically copy and paste a large number of images generated in JMP into Microsoft word. I've figured out how to copy them images using the "picture_box << Copy Picture;" functionality. However I am unsure how/if there is an easy way to paste the images into microsoft word once they are coppied thanks!

  Arthur_Wesley

  Discussions |

  Jun 14, 2019 10:17 AM

  4937 views | 4 replies

• How do I script Tabulating a document and then saving that Tabulated data into a Data table on my hard drive?

  I would like to tabulate some data from document 'Data1', make this tabulated data into a new data table, and then save the new data as document 'Data2', here is my first high level stab at this and doesn't seem to work, any quick guidance?   dt = Open( "Data1.jmp", invisible ); (Data Table( "Data1" ) << tab = dt << Tabulate( Add Table( Column Table( Grouping Columns( :Code LLT ) ), Row Table...

  zjuv007

  Discussions |

  Jun 14, 2019 8:32 AM

  6475 views | 4 replies

• Read a CSV and text file with JSL

  I have a CSV file that contains parameter names and tolerances. I have another text file that contains raw data. I am trying to write a script in JSL to read both CSV and text files and then apply the screening criteria in CSV file to the data in text file. CSV file format is liek below: #     Parameter    Tolerance 1     Height           30 2     Diameter       50   TXT file format is ID    Heigh...

  RV1

  Discussions |

  Jun 14, 2019 2:00 AM

  10716 views | 3 replies

• SAS code in JMP?

  I would like to know if there is a way I can run a SAS code (below) in JMP. Or how I can emulate the SAS code below in JMP.      proc mixed Class year week treatment rep; model stdmisummax=year|week|treatment/ddfm=kr residual; random rep(year) treatment*rep(year); repeated week/type=ar(1) subject=treatment*rep(year); run;     My factors are: Treatment, week (repeated measure), year, rep (replicate...

  bordini

  Discussions |

  Jun 13, 2019 2:59 PM

  32351 views | 19 replies