topic How do I check that a column contains only integers? in Discussions

How do I check that a column contains only integers?

anne_sa — Fri, 10 Apr 2020 13:08:20 GMT

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!

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

Mark_Bailey — Fri, 10 Apr 2020 13:42:41 GMT

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

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

anne_sa — Fri, 10 Apr 2020 14:05:04 GMT

What a beautiful solution!! Thanks @Mark_Bailey