How do I check that a column contains only integers?

Question

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!

Mark_Bailey · Accepted Answer

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