Shannon Conners' Blog

Latest Posts

• Merging city and state info into a table with 9 digit zip codes

  In my last post, I detailed how to obtain 9 digit zip codes and their X and Y coordinates from a table available from the SAS support site. I passed this information along to the customer in question and he was able to merge in the 9 digit zip information into his table. His next question regarded obtaining the city and state information corresponding to these 9 digit zips. I did a little digging ...

  shannon_conners

  Shannon Conners' Blog |

  Oct 18, 2016 5:50 PM

  2542 views | 0 replies
  

• Importing 9 digit zip code files into JMP

  Recently, a customer asked me about how to get a table of 9 digit zip codes with latitude and longitude values that could be imported into JMP to merge with an existing JMP data table that contained 9 digit zip codes. This question was new to me, and I had a suggestion from someone else that perhaps SAS PROC GEOCODE would be helpful. However, I knew the customer wasn't a SAS programmer so I was ho...

  shannon_conners

  Shannon Conners' Blog |

  Oct 18, 2016 5:48 PM

  3432 views | 0 replies
  

• Creating a JMP 12 Recode script from a Lookup Table containing original and new values

  I posted this entry on the main JMP blog today.  Jeff suggested it would be helpful to share this content on my community blog too, so that it is searchable in here as well.  I have been using the revamped JMP 12 Recode platform quite a lot since its early days and found it to be helpful for so many of my data cleanup projects.  But starting as an early user had its disadvantages...to find out why...

  shannon_conners

  Shannon Conners' Blog |

  Oct 18, 2016 4:48 PM

  1928 views | 0 replies
  

• Using a custom map as a selection filter in JMP 12

  For Discovery 2014, I shared how I used JSL to process nearly four years of text-based food logs and Excel-formatted activity data for visualization with JMP’s Graph Builder.  I posted extensively on the graphs that went along with my project in a JMP blog series here.  In comparison, importing data from my handwritten workout logs into JMP has been a very manual process!  I dedicated some early m...

  shannon_conners

  Shannon Conners' Blog |

  Oct 18, 2016 3:43 PM

  2108 views | 0 replies
  

• Digging into My Diet and Fitness Data With JMP

  This is a longer (and yes, you guessed it, a more personally detailed!) version of a blog I wrote that will appear on the JMP blog in the near future..If you’re a regular reader of the JMP blog, then you already know that those of us who work for JMP have taken a page from the Hair Club for Men.  I don’t mean in the use of their products, but rather in the use of our own products.  From our outsid...

  shannon_conners

  Shannon Conners' Blog |

  Oct 18, 2016 2:38 PM

  2804 views | 0 replies
  

• Using JSL to import BodyMedia® FIT® food log files into JMP

  In my previous blog post, I described how I imported my BodyMedia® Activity Summary data files from Excel into JMP. Today, I will share how I automated importing nearly four years of my BodyMedia® food logs into JMP. I have also uploaded an add-in to the JMP File Exchange that you can use to import your own Activity Summary and Food Log files, as well as CSV-formatted food log files from the popul...

  shannon_conners

  Shannon Conners' Blog |

  Oct 30, 2014 6:29 AM

  1967 views | 0 replies
  

• Using JSL to import BodyMedia® FIT® activity monitor data into JMP

  This is very similar to the version of this post from the JMP blog...just cross-posting it in case you missed it there!In an earlier blog post, I introduced the topic of my JMP Discovery Summit 2014 e-poster titled “Analysis of Personal Diet and Fitness Data With JMP” and shared my interests in quantified self (QS) analysis projects. For my poster project, I exported two different types of data fi...

  shannon_conners

  Shannon Conners' Blog |

  Oct 18, 2014 2:06 AM

  2150 views | 0 replies