Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- JSL New Formula Column

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Mar 23, 2017 3:12 AM
(1036 views)

Hi,

How do i script these keyclicks. With a numeric column, right click to access 'New Formula Column' -> 'Distributional'->'Johnson Normalizing'

What is the basic rule to script these options in the GUI? If i can be directed to a documentations that would be great! Thanks

-Rgds, Joel

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Mar 23, 2017 5:49 AM
(1912 views)

Solution

New Formula Column is not function that has been added to JSL. That is, as far as I can see. How I would get what you are asking for, is to use the Distribution Platform to generate the new column

```
Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Cities.jmp" );
obj = Distribution( Column( :CO ) );
obj << Fit Distribution( JohnsonSu( Save Transformed ) );
obj << Close Window;
```

The pointer to the documentation for this is:

Help==>Scripting Index==>Distribution==>Fit Distribution==>Save Transformed

Jim

4 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Mar 23, 2017 5:49 AM
(1913 views)

New Formula Column is not function that has been added to JSL. That is, as far as I can see. How I would get what you are asking for, is to use the Distribution Platform to generate the new column

```
Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Cities.jmp" );
obj = Distribution( Column( :CO ) );
obj << Fit Distribution( JohnsonSu( Save Transformed ) );
obj << Close Window;
```

The pointer to the documentation for this is:

Help==>Scripting Index==>Distribution==>Fit Distribution==>Save Transformed

Jim

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Mar 27, 2017 7:02 PM
(895 views)

Thanks. I'm ok with the added overhead of a distribution plots to get what i want if there is no direct access to the 'save transformed' clicks as in the gui.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Mar 23, 2017 6:27 AM
(1013 views)

Another way to get at the scripting for this function is:

1. Perform the operation manually on the table (i.e. New Formula Column' -> 'Distributional'->'Johnson Normalizing)

2. Click the red triangle next to the table name and select Copy Table Script

3. Open up a script window and paste the script in

4. Scroll down to the bottom and you'll see something like this (using the Cities.jmp dataset as an example)

```
New Column( "Johnson Su[CO]",
Numeric,
"Continuous",
Format( "Best", 12 ),
Formula(
ArcSinH( (:CO - 3.46504509514207) / 2.33960293388985 ) *
1.77414644201164 + (-2.38210320696422)
)
),
```

So, if you want to script this separately you can say

```
dt = open("$sample_data/Cities.jmp");
dt << New Column( "Johnson Su[CO]", Numeric, "Continuous",
Format( "Best", 12 ),
Formula(
ArcSinH( (:CO - 3.46504509514207) / 2.33960293388985 ) *
1.77414644201164 + (-2.38210320696422)
)
);
```

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Mar 27, 2017 8:39 PM
(886 views)

Hi Pmroz,

I got your points. Because of data volume, it should be more productive for me to script what i can. I'm interested in the transform formula and getting it by '<<get formula' with the objective of applying it to do back transformation to my volume data.