topic Re: getting matched entries from 3 different columns in Discussions

getting matched entries from 3 different columns

axm8717 — Mon, 15 Jul 2024 15:41:28 GMT

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

Re: getting matched entries from 3 different columns

jthi — Mon, 15 Jul 2024 15:52:05 GMT

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

Re: getting matched entries from 3 different columns

axm8717 — Mon, 15 Jul 2024 16:26:23 GMT

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.

Re: getting matched entries from 3 different columns

jthi — Mon, 15 Jul 2024 16:36:05 GMT

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