Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- missing data in calculated formula

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jul 16, 2010 11:22 AM
(658 views)

1. How can I instruct JMP to set the value of a formula to "missing" if one of it's components is missing?

2. Is there a way in JMP to tell it, for example, to replace up to 2 missing values with the average of the remaining 23, but to count the case as missing if >2 values are absent?

Thanks.

2 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jul 16, 2010 1:59 PM
(476 views)

So I opened big class and set "height" for the 1st row to be missing and created another column calculating "height+weight". Then the first row of the new column shows "." instead of 0...

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jul 16, 2010 2:40 PM
(476 views)

"There are three ways to sum across columns in JMP, and each behaves differently. Suppose your two columns are Col1 and Col2 and for a given row, Col2 is missing.

--Sum(Col1 + Col2) returns a zero.

--Sum(Col1, Col2) returns the value of Col1. It treats Col2 as if it is a zero

--Col1 + Col2 returns a missing value. The logic is that a number plus a missing value is missing. "

I'd been using the second method, and getting zeros when both col1 and col 2 were zero.

Thanks for your help.

ES