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

- JMP User Community
- :
- Discussions
- :
- Question Regarding "contains()" formula

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

Highlighted

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

Nov 20, 2019 9:19 AM
(644 views)

I have a set of CATA data where the nominal data looks like column "Data" below. I'm attempting to create an additional column for each selection (like "Answer 1, Answer 2, etc. below) where "0" = not found in the list and "1"= found.

Here is my formula: Contains( :Name( "Data" ), "1" ) > 0

However, it is picking up the number 1 from an 11 and is returning a "1" response for Answer 1 when it should be "0".

Maybe I've gone about this all wrong and there is a better way to accomplish this task? Any suggestions?

Data | Answer 1 | Answer 2 | Answer 3 |

1,2,3,6,11 | 1 | 1 | 1 |

2,5,6,11 | 0 | 1 | 0 |

3,11,12,13 | 0 | 0 | 1 |

1 ACCEPTED SOLUTION

Accepted Solutions

Highlighted

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

This might help

select your "Data" column

Cols>Utilities>Text into columns

then use "," as the delimiter and check the, Make Indicator columns.

JMP Systems Engineer, Pharm and BioPharm Sciences

3 REPLIES 3

Highlighted

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

This might help

select your "Data" column

Cols>Utilities>Text into columns

then use "," as the delimiter and check the, Make Indicator columns.

JMP Systems Engineer, Pharm and BioPharm Sciences

Highlighted
##

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

Re: Question Regarding "contains()" formula

Beautiful! That is exactly what I needed and way easier than my round-about method.

Much appreciated!

Highlighted
##

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

Re: Question Regarding "contains()" formula

@Emily_DayI am not sure I understand your logic completely, but perhaps the following will help.

```
Names Default to Here(1);
dt = New Table( "Sample",
Add Rows( 3 ),
New Column( "Data",
Character,
"Nominal",
Set Values( {"1,2,3,6,11", "2,5,6,11", "3,11,12,13"} )
)
);
dt << Text To Columns(
delimiter( "," ),
columns( :Data )
);
dtStacked = dt << Stack(
columns( :Data 1, :Data 2, :Data 3, :Data 4, :Data 5 ),
Source Label Column( "Label" ),
Stacked Data Column( "Response" ),
Output Table Name("StackedData")
);
dtStacked:Response<<Data Type("Numeric");
dtStacked << New Column(
"Answer",
Numeric,
Nominal,
Formula(
"Insert your Logic Here"
)
);
dtWide = dtStacked << Split(
Split By( :Label ),
Split( :Answer ),
Group( :Data ),
Remaining Columns( Drop All ),
Sort by Column Property,
Ouput Table Name("WideData")
);
```

Article Labels

There are no labels assigned to this post.