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; } } }

How to combine/recode two columns?

sanqub

I want to combine 2 columns. Suppose in sample library, big class example.

I want a new column which is combination of two columns "sex" and "age". The resulting column should have rows in form F12, M12 etc.

I tried with to combine columns using utility>combine but it gives error.

Thanks for your help

Accepted answers

MikeD_Anderson

Have you tried selecting both columns, right-clicking on the column name and selecting New Formula Column>Character > Concatenate?

ron_horne

try this.

Names Default To Here( 1 );

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

dt << New Column( "Column", Character, Nominal, Formula( :sex || Char( :age ) ) );

i think the concatenate function only takes characters.

best,

ron

All comments

MikeD_Anderson

Have you tried selecting both columns, right-clicking on the column name and selecting New Formula Column>Character > Concatenate?

ron_horne

try this.

Names Default To Here( 1 );

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

dt << New Column( "Column", Character, Nominal, Formula( :sex || Char( :age ) ) );

i think the concatenate function only takes characters.

best,

ron

sanqub

Thank You.

sanqub

Hi Ron,

Thanks for the script. Even I think concatenate function just takes characters.

Santosh

ezorlo

hi i get an error on the snippet of code "<<"

txnelson

Are you running the exact copy of the code below?

Names Default To Here( 1 );

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

dt << New Column( "Column", Character, Nominal, Formula( :sex || Char( :age ) ) );

If not, can you include the exact JSL you are using.