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

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- How can I combine 2 columns into one?

- 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
- Permalink
- Email to a Friend
- Report Inappropriate Content

Oct 23, 2012 7:21 AM
(4171 views)

I would like to combine two columns into one. My data looks like the table below where "." represents missing data. I would like to make a column which resembles Column C.

Column A | Column B |
---|---|

. | 2013 |

. | 2014 |

2016 | . |

2017 | . |

Column C |
---|

2013 |

2014 |

2016 |

2017 |

Solved! Go to Solution.

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Oct 23, 2012 8:09 AM
(7267 views)

I'm not familiar with JMP but isn't the first condition checking if the cell in A is blank versus missing?

SAS has a keyword, missing, does JMP have the same?

ie

If(is missing(:Column A) , :Column A, :Column B)

3 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Oct 23, 2012 7:34 AM
(3755 views)

So far I have tried adding a new column with the formula: If( :Column A != "", :Column A, :Column B) but this doesn't work and I'm not sure why. It fills in the values from Column A but not from Column B.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Oct 23, 2012 8:09 AM
(7268 views)

I'm not familiar with JMP but isn't the first condition checking if the cell in A is blank versus missing?

SAS has a keyword, missing, does JMP have the same?

ie

If(is missing(:Column A) , :Column A, :Column B)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Oct 23, 2012 9:10 AM
(3755 views)

Thank you, I was able to get the formula to work using Is Missing().