Subscribe Bookmark RSS Feed

Scripting errors with Save( Standardized )

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".

What am I missing?
4 REPLIES
...but I can't insert the Save( Standardized ) command into that 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".

What am I missing?
mpb

Super User

Joined:

Jun 23, 2011

This seems to work:
mpb

Super User

Joined:

Jun 23, 2011

This is simpler and keeps all distribution output in a single page:

Perfect!

You are a peach.

K