All you need to do to solve this issue, is to use the formula for standardizing the data. The formula for the standardization contains column functions that have the "By" calculation. So here is an example script that does what you want. It is standardizing to a mean of 100 and and std of 10

```
Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << New Column( "standard by sex",
formula(
new mean = 100;
new STD = 10;
((:height - Col Mean( :height, :sex )) / Col Std Dev( :height, :sex )) * new STD
+new mean;
)
);
```

Jim