n rows doesn't mean n

[#1]

Hi All,

I got some descriptive's from JMP, included in the output was: N Rows, l thought that is handy l would need that later on, unfortunately this is a count of the actually rows and not n, as l have some missing data, is there a simple line of code in JMP that l can get the actual n and not count the missing data, similar to na.rm = TRUE, by groups, the code i used is as follows:

dt3 << Summary(
	Group( :Scale Area, :Process Step, :Subtype, Quality Attribute ),
	Mean( :Data ),
	Std Dev( :Data ),
	Std Err(:Data),
	Freq( "None" ),
	Weight( "None" ),
	Output Table( "Descriptives" ),
	Link to original data table(0)
);


dt4 = Data Table( "Descriptives" ) << Split(
			Split By( :Scale Area ),
			Split( :"Mean(Data)"n, :"Std Dev(Data)"n, :N Rows, :"Std Err(Data)"n  ),
			Group( :Process Step, :Subtype, :Quality Attribute ),
			Remaining Columns( Drop All ),
			Output Table( "Mean Ratio"),
			Sort by Column Property
		); 

Any suggestion would be appreciated.

Thanks,

Mick.        

[#2 · Accepted solution]

Have you tried checking out the different options Summary platforms offers you? Using JMP > Summarize Your Data > Explanation of Summary Statistics 

[#3 · Accepted solution]

Sorry jthi,

it was late and l was tired and frustrated, l was actually looking for "N(data)"n, that does the job nicely, thanks very much for your reply.

Regards,

Mick