329606_en-US

liliconcom

Summary with Include marginal statistics title

Hi all, I am trying to create a table of summary statistics using the function SUMMARY. My data should be group by a specific column, and Include marginal statistics. Everything goes well, the only problem is that I cannot manage to give a label to the row containing the marginal statistics. For example, I'm grouping variables per country, and the first column contains the name of each country (i.e. Germany, US, France...) but the last row is empty, I would like to add a customized name such as "All" or "World". 

 

When I try modify the cell directly (either interactive or in JSL), I receive the message that the column is blocked. Do you know a way to solve it?

Data TableOtherScriptingRe: Summary with Include marginal statistics title

Hi,

 

I believe the summary table is locked because it is linked to the original data table.  Please try running "Summary" with the "Link to original data table" unchecked.

 

 

Re: Summary with Include marginal statistics titleThank you very much, that makes the trick indeed, I did not notice it as I am working mostly in the script form.Re: Summary with Include marginal statistics title

Understood.  I'm sure you saw this already, but if scripting a Summary table, simply add the statement "Link to original data table (0)" in the Summary function:

 

Data Table( "Tablet Production" ) << Summary(
 Group( :Compressor ),
 Mean( :Inlet Temp ),
 Mean( :Exhaust Temp ),
 Mean( :Spray Rate ),
 Freq( "None" ),
 Weight( "None" ),
 Link to original data table( 0 )
)