topic Re: How to combine/recode two columns? in Discussions

How to combine/recode two columns?

sanqub — Thu, 30 Mar 2017 12:59:24 GMT

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

Re: How to combine/recode two columns?

MikeD_Anderson — Thu, 30 Mar 2017 13:07:17 GMT

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

Re: How to combine/recode two columns?

ron_horne — Thu, 30 Mar 2017 15:44:53 GMT

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

Re: How to combine/recode two columns?

sanqub — Mon, 03 Apr 2017 15:25:38 GMT

Thank You.

Re: How to combine/recode two columns?

sanqub — Mon, 03 Apr 2017 15:27:31 GMT

Hi Ron,

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

Santosh

Re: How to combine/recode two columns?

ezorlo — Wed, 22 Jul 2020 10:35:11 GMT

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

Re: How to combine/recode two columns?

txnelson — Wed, 22 Jul 2020 11:56:29 GMT

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.