nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

getting matched entries from 3 different columns

axm8717

Hi,

I have 3 columns with dates of different types imaging tests done in a timeframe.

I'd like to see if an individual had done AT LEAST 1 of the 3 different methods in this timeframe.

For example: I have entries for US, CT and MRI at baseline. An individual could have done US and MRI = yes at least 1 method. If the person did not have done any imaging test, it would be = no for at least 1 method.

But I'm not finding an easy way to understand how to compile this information in 1 single column.

Thanks in advance

Accepted answers

jthi

I think you could use just

:mri1dt_0 | :ct1dt_0 | :us1dt_0

but to be a bit more sure I would add Is Missing there. With that you can then do many different types of comparisons, below is one using ! (not) and & (and)

!(Is Missing(:mri1dt_0) & Is Missing(:ct1dt_0) & Is Missing(:us1dt_0))

If you want to have Yes / No, you could use If statement OR value labels column property

All comments

jthi

Can you provide a small example of how your data is formatted?

axm8717

Here you go.

I want to create a column that represents the rows that has at least 1 entry in columns of mri, ct and us.

Subset.jmp

jthi

I think you could use just

:mri1dt_0 | :ct1dt_0 | :us1dt_0

but to be a bit more sure I would add Is Missing there. With that you can then do many different types of comparisons, below is one using ! (not) and & (and)

!(Is Missing(:mri1dt_0) & Is Missing(:ct1dt_0) & Is Missing(:us1dt_0))

If you want to have Yes / No, you could use If statement OR value labels column property