JMP 9: Save As Statement causing JMP to crash

Question

Hello,

I've been working on getting some JSL scripts across from SAS 9.1/JMP8 to SAS 9.3/JMP9, and came across a strange issue during testing.

The JMP script we're using has a Button Box, which then calls a save as on a .sas7bdat datatset e.g.

table << Save As ( data_path_and_name );

For some reason this statement works fine in JMP 8, but in the new version this causes JMP to completely close down and exit the program (both our code, and the JMP program itself) without any error messages or warning.

I haven't been able to find any documentation so far about whether there is an option to specify within the Save As that the format needs to be .sas7bdat (this exact same statement works fine when the data file being saved to is .jmp).

If anyone has come across this before, or has any suggestions it would be much appreciated.

jessica · Accepted Answer

This problem appears to be caused by an installation issue with the OLEDB component. The following steps were provided by SAS Technical Support which resolved the issue.

JMP does not require SAS to be installed or running when exporting a data table out as a .sas7bdat file. Rather, JMP uses the SAS OLEDB component (which is part of the standard JMP install) to accomplish the export. So first thing to try is to reinstall this OLEDB component.

1. Exit out of JMP

2. Find your original JMP installer folder (on network drive, on CD/DVD or other media) and navigate to the following folder from your top level installation folder:

<install depot folder>\JMP\Bundles\sasoledb\

3. Run the setup.exe file to install the OLEDB component

4. Start up JMP and try to export out to SAS again