topic Re: How to joining two columns with JSL in Discussions

How to joining two columns with JSL

pomemelom — Wed, 01 Feb 2017 00:51:10 GMT

Hi I am new to JSL, and I got stuck in a seemlily easy task.

Say I have two columns A and B, and have some missing values.

I'd like to create a new column to be the join of column A and B.

As shown in example below.

Thanks!

Re: How to joining two columns with JSL

txnelson — Wed, 01 Feb 2017 01:17:04 GMT

Here is a couple of simple examples

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/big class.jmp" );

dt << New Column( "New Column", character, formula( name || sex ) );

// or 
dt << New Column( "Second New Column", character );
For( i = 1, i <= N Rows( dt ), i++,
	dt:Second New Column[i] = dt:name[i] || dt:sex[i]
)are

Re: How to joining two columns with JSL

meperry — Wed, 23 Aug 2017 19:36:07 GMT

I am having the same issue, but the code provided here does not work. I am dealing with continuous data, perhaps that is the problem? Or is it that my variable names are longer than SAS allows, so using them in JSL creates an error?

My data subset looks like such:

StdURM1BLFI	StdURM1BLMI
.	.
-0.0316815	.
.	-0.33056098

and I would like the third column to contain the data from the other two (or keep a missing data value as necessary), e.g.:

StdURM1BLFI	StdURM1BLMI	Zscore
.	.	.
-0.0316815	.	-0.0316815
.	-0.33056098	-0.33056098

Thank you!

Re: How to joining two columns with JSL

ian_jmp — Thu, 24 Aug 2017 08:01:25 GMT

So long as only one of the two columns has a non missing value, you could try 'Sum()'. Look at the formula in the table below:

New Table( "Both",
	Add Rows( 4 ),
	New Column( "a",
		Numeric,
		"Continuous",
		Format( "Best", 12 ),
		Set Values( [., 1, ., 3] )
	),
	New Column( "b",
		Numeric,
		"Continuous",
		Format( "Best", 12 ),
		Set Values( [., ., 2, 4] )
	),
	New Column( "c",
		Numeric,
		"Continuous",
		Format( "Best", 12 ),
		Formula( Sum( :a, :b ) )
	)
) e

Re: How to joining two columns with JSL

meperry — Thu, 24 Aug 2017 15:46:41 GMT

The sum function works! Thank you!

Re: How to joining two columns with JSL

hogi — Wed, 28 Jun 2023 16:47:07 GMT

It's amazing how easy such things are in JMP - even by hand (no problem if the patterns are irregular and the table has 5 mio entries).

Just watch this video by @brady_brady :
(~ 2min)

Alternative approach:

use the by @john_madden