773056_en-US

liliconcom

getting matched entries from 3 different columns

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

Data Blending and CleanupRe: getting matched entries from 3 different columns

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

Re: getting matched entries from 3 different columns

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

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