topic Re: Save "Predicteds" with a specific column name in Discussions

Save "Predicteds" with a specific column name

gutloja — Thu, 24 Mar 2016 00:37:06 GMT

Hello, All.

Quick question.

Is there a way to save predicteds with a specific column name?

When I use something like this to save predicteds:

Bivariate << (curve[1] << save predicteds);

It saves as "Predicted Name of predicted variable".

Thank you for your time & help,

-JoseL

Re: Save "Predicteds" with a specific column name

txnelson — Thu, 24 Mar 2016 01:11:33 GMT

Because JMP will save the predicted as a new column at the far right of your data table, you can use the following code to change the name to whatever name you want to give it:

Assuming you have referenced your data table using a variable called "dt" (i.e. dt=current data table();)

column(N Cols(dt)) << set name("Your new name");

Re: Save "Predicteds" with a specific column name

gutloja — Thu, 24 Mar 2016 03:19:34 GMT

Thanks a lot Jim, this worked like a charm.

-JL

Re: Save "Predicteds" with a specific column name

mredford — Fri, 03 Mar 2017 13:58:56 GMT

Hi, I'm trying to do this as well. Did you save the predicteds column manually, or was this scripted? I'm hoping to automate the process and script the saving of the column, so if you scripted this, could you share the syntax you used? Thanks!

Re: Save "Predicteds" with a specific column name

txnelson — Fri, 03 Mar 2017 15:06:30 GMT

Here is a sample script that you should be able to use

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA\semiconductor capability.jmp" );
biv = Bivariate( Y( :NPN1 ), X( :PNP1 ), Fit Line( {Line Color( {213, 72, 87} )}, save predicteds ) );
biv << (curve[1] << save predicteds);
Column( N Cols( dt ) ) << set name( "Your new name" );

Re: Save "Predicteds" with a specific column name

mredford — Fri, 03 Mar 2017 15:43:14 GMT

Perfect! Thank you so much, I have been struggling all morning to automate this for the spline fit. Thank you for your quick response as well!!