JSL Question: How to select all continuous columns except date formatted columns?

Question

Hi,

I would like to select specific columns in a dataset by JSL and group them.

The selected columns need to have a X in the name -> Done

The selected columns need to have less than 5 category if it is a nominal variable -> Done

The selected  columns is not a date if it is a continuous column -> I didn't find a way to test the format. Does anyone have an idea how to test the format? Once I use Get Format, I'm stuck for the comparison with a Date or the "Best" Format....

it is probably a stupid question.

Thank a lot for all your suggestions!

Florence

jules · Accepted Answer

Hi @flo_kussener,

If I'm understanding your question correctly, you are looking for a method to test if a column is a date format or not. Is that right? If so, one way I found to do this is to test if the column is numeric and has something other than a numeric input type:

If(
	And(
		:DateColumn << Get Data Type == "Numeric",
		Not( Eval( Arg( :DateColumn << Get Input Format ) ) == "Numeric" )
	),
	doSomething
);

It's not that pretty, but it gets around having to test if <<Get Format matches one of the many, many date formats.