Welcome to the JMP User Community!

Latest Discussions

• SAS to JMP....Will I Get What I Need?

  HelloI have Base SAS 9.3 with Enterprise Guide and I've written quite a few programs in SAS code.  Mostly I manipulate data from importing, change/create new fields, export to another medium like MS-Access.  I link onto the MS-Access data via Crystal Reports and use that for my reporting.I currently have SAS through my employer but I pay the yearly license fees.  However, I'm a contract employee a...

  shellp55

  Discussions |

  Sep 20, 2013 9:19 AM

  12766 views | 6 replies

• Change Column Name after performing Summary Function

  Hello.Good day.Team,I will be needing your support on how to achieve my target table output.I have a sample data table. I made a Mean Summary for Group 1 and Group 2 Columns, separately.But i want to combine the two Mean Summary table into 1 table.However, since Group 1 and Group 2 has different Column NameDuring Concatenate this 2 Columns will have separate Columns.In order to have them in same C...

  karem

  Discussions |

  Sep 17, 2013 12:56 PM

  3958 views | 1 replies

• JMP needs ODBC Driver to Open Excel Files

  I just upgraded to JMP 11 yesterday. I cannot open Excel files. Doing a Google search I figured out I needed an ODBC driver. I have tried the actual technologies driver, to no avail. the OpenLink website is very confusing. They offer multiple drivers depending on what database you need to get access to. I don't know if Excel is an access database, MySQL, SQL Server or what. I am running JMP on a M...

  atlas100

  Discussions |

  Sep 12, 2013 11:41 AM

  7012 views | 4 replies

• JSL code for File Open if file exists

  Hi Folks,I have some JSL code that opens a series of files (both a *.jmp and *.dat) and then performs various data management activities on them (namely, testing for presence of new data and then concatenating only the new data). The code runs fine as long as all the files are present.  There are some cases where a particular data file hasn't been collected and I want the JSL code to run for those...

  terapin

  Discussions |

  Sep 12, 2013 7:27 AM

  14366 views | 2 replies

• Create Associative Array from Column Values

  I would like to create an associative array from column values.  I am curious if anyone in the JMP community has a clever solution.  I am using JMP10.  An example is below.// For the following data table:example = New Table( "Example Data", Add Rows( 27 ),  New Column( "Lot", Character, Nominal, Set Values( {"A", "A", "A", "A", "A", "A", "A", "A", "A", "B", "B", "B", "B", "B", "B", "B", "B", "B", ...

  robot

  Discussions |

  Sep 10, 2013 11:05 AM

  10400 views | 2 replies