Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
In this video, we use the Cleaning data to fit a regression model for Removal and ID using Fit Y by X, and then conduct a residual analysis to evaluate model assumptions.