Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
anne_sa
Level V

How do I check that a column contains only integers?

Hello,

 

I need to check that a column contains only integers before running the rest of my script but I don't know how to do that. Ideally I would like to be able to identify precisely the rows with decimal values.

 

Thanks in advance for your help!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: How do I check that a column contains only integers?

See the last line.

Names Default to Here( 1 );

// generate test case with a mix of 90% integers and 10% non-integers
data = J( 30, 1,
	If( Random Uniform() < 0.1,
		Random Normal(),
		Random Integer( -6, 6 )
	);
);

// check results
Show( data );

// make a data table example
dt = New Table( "Test Cases",
	New Column( "Data", Numeric, Continuous,
		Values( data )
	)
);

// now the solution
nonIntegersHere = dt << Get Rows Where( Modulo( :Data, 1 ) );
Learn it once, use it forever!

View solution in original post

2 REPLIES 2
Highlighted

Re: How do I check that a column contains only integers?

See the last line.

Names Default to Here( 1 );

// generate test case with a mix of 90% integers and 10% non-integers
data = J( 30, 1,
	If( Random Uniform() < 0.1,
		Random Normal(),
		Random Integer( -6, 6 )
	);
);

// check results
Show( data );

// make a data table example
dt = New Table( "Test Cases",
	New Column( "Data", Numeric, Continuous,
		Values( data )
	)
);

// now the solution
nonIntegersHere = dt << Get Rows Where( Modulo( :Data, 1 ) );
Learn it once, use it forever!

View solution in original post

Highlighted
anne_sa
Level V

Re: How do I check that a column contains only integers?

What a beautiful solution!! Thanks @markbailey 

Article Labels

    There are no labels assigned to this post.