topic Re: Missing Value Codes Don't Export To Excel in Discussions

Missing Value Codes Don't Export To Excel

SpannerHead — Fri, 04 Apr 2025 19:20:44 GMT

I need to export some JMP files to excel and cells that were marked as missing are empty in the resulting Excel file. Anyone figure out a way to keep it present?

Re: Missing Value Codes Don't Export To Excel

SpannerHead — Fri, 04 Apr 2025 19:22:36 GMT

To clarify, missing as a result of being a missing value code.

Re: Missing Value Codes Don't Export To Excel

jthi — Fri, 04 Apr 2025 20:05:02 GMT

If you have marked them as missing, why would you wish to display them? You could create a subset, remove the column property and save after that.

Re: Missing Value Codes Don't Export To Excel

SpannerHead — Mon, 07 Apr 2025 13:22:24 GMT

Jarmo

I mark them as missing because they are error codes and should be excluded from the analyses. Numeric error codes are used to preserve the column Data Type as numeric, however, the actual number has no relevance. If I lose the cell value on import, I also lose information about the nature of the error.

Re: Missing Value Codes Don't Export To Excel

ngambles — Thu, 10 Apr 2025 04:30:56 GMT

Have you tried saving the data table out to the CSV format instead of the Excel format? Excel is good at working with both Excel files and CSV files.

When I save a data table as CSV, it retains the Missing Values (missing value codes) and when I save it as an Excel file, the missing value code values are missing, just as you described. Perhaps this difference in behaviors for the different formats has the solution to your problem.