Looking for some help! I'm going to have tables with varying column counts and names. Want a script that will run the Distribution platform on my continuous numeric columns and save the standardized columns to the table.
This script will run the Distribution platform: dt = Current Data Table(); cc = dt << Get Column Names( Continuous ); ncols = N Items( cc ); For( i = 1, i <= ncols, i++, cc << Set Selected( 0 ) ); For( i = 1, i <= ncols, i++, cc << Set Selected( 1 ); Distribution( Y( cc ) ); cc << Set Selected( 0 ); );
...but I can't insert the Save( Standardized ) command into this script.
This script will do Save( Standardized ) on a single column: Distribution( Continuous Distribution( Column( :var_2307 ), Horizontal Layout( 1 ), Vertical( 0 ), Save( Standardized ) ) )
... but I can't find a way to iterate this one through a column list. My attempts so far error out with "No data to analyze".