cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-268685%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%B0%87%E8%A1%A8%E6%A0%BC%E4%B8%AD%E7%9A%84%E6%89%80%E6%9C%89%E6%95%B8%E5%AD%97%E5%88%97%E8%A3%BD%E8%A1%A8%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-268685%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E4%BD%A0%E5%A5%BD%EF%BC%8C%3C%2FP%3E%3CP%3E%E6%88%91%E6%AD%A3%E5%9C%A8%E5%98%97%E8%A9%A6%E5%89%B5%E5%BB%BA%E4%B8%80%E5%80%8B%E5%8C%85%E5%90%AB%E6%89%80%E6%9C%89%E6%95%B8%E5%AD%97%E5%88%97%EF%BC%88%E7%84%B6%E5%BE%8C%E6%98%AF%E5%8F%A6%E4%B8%80%E5%80%8B%E5%8C%85%E5%90%AB%E5%88%86%E9%A1%9E%E5%88%97%EF%BC%89%E7%9A%84%E8%A3%BD%E8%A1%A8%E8%A1%A8%E3%80%82%3C%2FP%3E%3CP%3E%E6%88%91%E5%98%97%E8%A9%A6%E9%81%8B%E8%A1%8C%E5%AE%83%EF%BC%8C%E4%BD%86%E5%AE%83%E4%B8%8D%E8%B5%B7%E4%BD%9C%E7%94%A8%E3%80%82%3C%2FP%3E%3CP%3E%E6%9C%89%E4%BB%80%E9%BA%BC%E5%BB%BA%E8%AD%B0%E5%97%8E%EF%BC%9F%3C%2FP%3E%3CP%3ETIA%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Edt%20%3D%20Open(%20%22%24SAMPLE_DATA%2FBig%20Class.jmp%22%20)%3B%0A%20NumericCols%20%3D%20%7B%7D%3B%0A%20for(i%20%3D%201%2C%20i%20%26lt%3B%3D%20N%20Cols(dt)%2C%20i%2B%2B%2C%0A%20%20Col%20%3D%20Column(dt%2Ci)%3B%0A%20%20ColDataType%20%3D%20Col%20%26lt%3B%26lt%3B%20Get%20Data%20Type%3B%20%0A%20%20If(%20ColDataType%20%3D%3D%20%22Numeric%22%2C%0A%20%20%20Insert%20Into(NumericCols%2CCol%20%26lt%3B%26lt%3B%20Get%20Name)%3B%0A%20%20%20)%3B%0A%20%20)%3B%0A%0A%0ATabulate(%20%0A%20Set%20Format(%20Uniform%20Format(%2010%2C%202%20)%20)%2C%0A%20Add%20Table(%0A%20%20Column%20Table(%20Statistics(%20N%20)%20)%2C%0A%20%20Column%20Table(%20Statistics(%20Mean%20)%20)%2C%0A%20%20Column%20Table(%20Statistics(%20Std%20Dev%20)%20)%2C%0A%20%20Column%20Table(%20Statistics(%20Min%20)%20)%2C%0A%20%20Column%20Table(%20Statistics(%20Max%20)%20)%2C%0A%20%20Column%20Table(%20Statistics(%20Median%20)%20)%2C%0A%20%20Row%20Table(%0A%20%20%20Analysis%20Columns(%0A%20%20%20%20NumericCols%20%3D%20%7B%7D%0A%20%20%20)%0A%20%20)%0A%20)%0A)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-269059%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E5%B0%87%E8%A1%A8%E6%A0%BC%E4%B8%AD%E7%9A%84%E6%89%80%E6%9C%89%E6%95%B8%E5%AD%97%E5%88%97%E8%A3%BD%E6%88%90%E8%A1%A8%E6%A0%BC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-269059%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E9%99%84%E8%A8%80%E3%80%82%3C%2FP%3E%3CP%3E%E6%88%91%E9%87%8D%E5%AF%AB%E4%BA%86%E9%80%99%E6%AE%B5%E4%BB%A3%E7%A2%BC%E4%BB%A5%E8%99%95%E7%90%86%E9%80%A3%E7%BA%8C%E5%88%97%E8%80%8C%E4%B8%8D%E6%98%AF%E6%95%B8%E5%AD%97%E3%80%82%20%E9%80%99%E6%9B%B4%E9%81%A9%E5%90%88%E6%88%91%E7%9A%84%E9%9C%80%E8%A6%81%EF%BC%8C%E5%9B%A0%E7%82%BA%E6%88%91%E6%9C%89%E5%B9%BE%E5%88%97%E5%AF%A6%E9%9A%9B%E4%B8%8A%E6%98%AF%E5%90%8D%E7%BE%A9%E4%B8%8A%E7%9A%84%EF%BC%8C%E4%BD%86%E6%9C%89%E6%95%B8%E5%AD%97%E6%95%B8%E6%93%9A%E5%92%8C%E5%80%BC%E6%A8%99%E7%B1%A4%E3%80%82%3C%2FP%3E%3CP%3E%E9%80%99%E6%98%AF%E6%88%91%E4%BD%BF%E7%94%A8%E7%9A%84%E6%9C%80%E7%B5%82%E4%BB%A3%E7%A2%BC%E3%80%82%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(%201%20)%3B%0Adt%20%3D%20currentdatatable()%3B%0AcontinuousCols%20%2F*NumericCols%20*%2F%20%3D%20dt%20%26lt%3B%26lt%3B%20get%20column%20names(%20continuous%20%2F*numeric*%2F%20%20)%3B%0A%0Adt%20%26lt%3B%26lt%3B%20Tabulate(%0A%20Set%20Format(%20Uniform%20Format(%2010%2C%202%20)%20)%2C%0A%20Show%20Control%20Panel(%200%20)%2C%0A%20Add%20Table(%0A%20%20Column%20Table(%20Statistics(%20N%20)%20)%2C%0A%20%20Column%20Table(%20Statistics(%20Mean%2C%20Std%20Dev%20)%20)%2C%0A%20%20Column%20Table(%20Statistics(%20Min%2C%20Max%20)%20)%2C%0A%20%20Column%20Table(%20Statistics(%20Median%20)%20)%2C%0A%20%20Row%20Table(%20Analysis%20Columns(%20Eval(%20continuousCols%20%2F*NumericCols%20*%2F%20)%20)%20)%0A%20)%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%E9%9D%9E%E5%B8%B8%E6%84%9F%E8%AC%9D%E4%BD%A0%E7%9A%84%E5%B9%AB%E5%8A%A9%EF%BC%81%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-268796%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E5%B0%87%E8%A1%A8%E6%A0%BC%E4%B8%AD%E7%9A%84%E6%89%80%E6%9C%89%E6%95%B8%E5%AD%97%E5%88%97%E8%A3%BD%E6%88%90%E8%A1%A8%E6%A0%BC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-268796%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E9%80%99%E6%98%AF%E4%B8%80%E7%A8%AE%E5%81%9A%E4%BD%A0%E6%83%B3%E5%81%9A%E7%9A%84%E4%BA%8B%E6%83%85%E7%9A%84%E6%96%B9%E6%B3%95%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Edt%20%3D%20Open(%20%22%24SAMPLE_DATA%2Fsemiconductor%20capability.jmp%22%20)%3B%0ACharacterCols%20%3D%20dt%20%26lt%3B%26lt%3B%20get%20column%20names(%20nominal%20)%3B%0A%0A%2F%2F%20Build%20a%20string%20variable%20that%20contains%20the%20required%20JSL%0AtheExpr%20%3D%20%0A%22dt%20%26lt%3B%26lt%3B%20Tabulate(%0A%20Show%20Control%20Panel(%200%20)%2C%0A%20Add%20Table(%0A%20%20Column%20Table(%20Statistics(%20N%2C%20Name(%20%5C!%22%25%20of%20Total%5C!%22%20)%20)%20)%2C%22%3B%0A%20%20For(%20i%20%3D%201%2C%20i%20%26lt%3B%3D%20N%20Items(%20CharacterCols%20)%2C%20i%2B%2B%2C%0A%20%20theExpr%20%3D%20theExpr%20%7C%7C%0A%20%20%20%22Row%20Table(%20Grouping%20Columns(%20%22%20%7C%7C%20char(CharacterCols%5Bi%5D)%20%7C%7C%20%22)%20)%2C%22%3B%0A%20%20)%3B%0A%20theExpr%20%3D%20theExpr%20%7C%7C%20%22))%3B%22%3B%0A%2F%2F%20Execute%20the%20JSL%0Aeval(parse(theExpr))%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%E5%85%B6%E4%BB%96%E7%A4%BE%E5%8D%80%E6%88%90%E5%93%A1%E5%8F%AF%E8%83%BD%E6%9C%89%E6%9B%B4%E5%A5%BD%E7%9A%84%E6%96%B9%E6%B3%95%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-268792%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E5%B0%87%E8%A1%A8%E6%A0%BC%E4%B8%AD%E7%9A%84%E6%89%80%E6%9C%89%E6%95%B8%E5%AD%97%E5%88%97%E8%A3%BD%E6%88%90%E8%A1%A8%E6%A0%BC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-268792%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E5%86%8D%E6%AC%A1%E6%84%9F%E8%AC%9D%E6%82%A8%E7%9A%84%E9%85%8D%E5%90%88%E3%80%82%20%E6%82%A8%E7%99%BC%E9%80%81%E7%9A%84%E7%AC%AC%E4%BA%8C%E5%80%8B%E4%BB%A3%E7%A2%BC%E4%BB%8D%E7%84%B6%E6%B2%92%E6%9C%89%E7%B5%A6%E5%87%BA%E6%88%91%E9%9C%80%E8%A6%81%E7%9A%84%E7%B5%90%E6%9E%9C%E3%80%82%3C%2FP%3E%3CP%3E%E8%AB%8B%E5%9C%A8%E4%B8%8B%E9%9D%A2%E6%9F%A5%E7%9C%8B%E6%88%91%E8%A9%A6%E5%9C%96%E7%8D%B2%E5%BE%97%E7%9A%84%E7%B5%90%E6%9E%9C%EF%BC%8C%E9%80%99%E6%98%AF%E6%88%91%E5%9C%A8%E4%B8%8A%E4%B8%80%E7%AF%87%E6%96%87%E7%AB%A0%E4%B8%AD%E7%99%BC%E5%B8%83%E7%9A%84%E4%BB%A3%E7%A2%BC%E7%9A%84%E7%B5%90%E6%9E%9C%EF%BC%8C%E7%84%B6%E5%BE%8C%E6%98%AF%E6%88%91%E5%BE%9E%E6%82%A8%E7%9A%84%E4%BB%A3%E7%A2%BC%E4%B8%AD%E7%8D%B2%E5%BE%97%E7%9A%84%E7%B5%90%E6%9E%9C%E3%80%82%3C%2FP%3E%3CP%3E%E9%80%99%E5%B0%B1%E6%98%AF%E6%88%91%E6%83%B3%E8%A6%81%E5%BE%97%E5%88%B0%E7%9A%84%EF%BC%9A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22eliyahu100_0-1590404560746.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22eliyahu100_0-1590404560746.png%22%20style%3D%22width%3A%20268px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22eliyahu100_0-1590404560746.png%22%20style%3D%22width%3A%20268px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22eliyahu100_0-1590404560746.png%22%20style%3D%22width%3A%20268px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F24157i746A9F801D122E45%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22eliyahu100_0-1590404560746.png%22%20alt%3D%22eliyahu100_0-1590404560746.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E9%80%99%E6%98%AF%E6%88%91%E4%BD%BF%E7%94%A8%E7%99%BC%E5%B8%83%E7%9A%84%E4%BB%A3%E7%A2%BC%E5%BE%97%E5%88%B0%E7%9A%84%EF%BC%9A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22eliyahu100_2-1590405214360.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22eliyahu100_2-1590405214360.png%22%20style%3D%22width%3A%20393px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22eliyahu100_2-1590405214360.png%22%20style%3D%22width%3A%20393px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22eliyahu100_2-1590405214360.png%22%20style%3D%22width%3A%20393px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F24159i23C286D2D3A57A55%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22eliyahu100_2-1590405214360.png%22%20alt%3D%22eliyahu100_2-1590405214360.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETIA%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-268746%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E5%B0%87%E8%A1%A8%E6%A0%BC%E4%B8%AD%E7%9A%84%E6%89%80%E6%9C%89%E6%95%B8%E5%AD%97%E5%88%97%E8%A3%BD%E6%88%90%E8%A1%A8%E6%A0%BC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-268746%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E5%95%8F%E9%A1%8C%E4%B8%8D%E5%9C%A8%E6%96%BC%E8%A3%BD%E8%A1%A8%E4%BB%A3%E7%A2%BC%E3%80%82%E6%88%91%E7%82%BA%E6%82%A8%E6%8F%90%E4%BE%9B%E7%9A%84%20Tabulate%20%E4%BB%A3%E7%A2%BC%E5%8F%AF%E4%BB%A5%E6%AD%A3%E5%B8%B8%E5%B7%A5%E4%BD%9C%E3%80%82%E5%95%8F%E9%A1%8C%E5%9C%A8%E6%96%BC%E8%A1%A8%E6%A0%BC%E4%B8%AD%E5%88%97%E7%9A%84%E8%A8%AD%E7%BD%AE%E3%80%82%E5%9C%A8%E6%88%91%E7%99%BC%E7%B5%A6%E4%BD%A0%E7%9A%84%E6%9C%80%E5%BE%8C%E4%B8%80%E6%AE%B5%E4%BB%A3%E7%A2%BC%E4%B8%AD%EF%BC%8C%E8%81%B2%E6%98%8E%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ECharacterCols%20%3D%20dt%20%26lt%3B%26lt%3B%20get%20column%20names(%20character%20)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%E5%B0%87%E6%95%B8%E6%93%9A%E8%A1%A8%E4%B8%AD%E6%95%B8%E6%93%9A%E9%A1%9E%E5%9E%8B%E7%82%BA%E5%AD%97%E7%AC%A6%E7%9A%84%E6%89%80%E6%9C%89%E5%88%97%E6%94%BE%E5%85%A5%20CharacterCols%20%E5%88%97%E8%A1%A8%E3%80%82Tabulate%20%E5%9C%A8%20Lot_id%20%E5%88%97%E3%80%81Lot%20ID%20%E4%B8%AD%E7%9A%84%E6%99%B6%E5%9C%93%20ID%20%E5%88%97%E4%B8%AD%E6%AD%A3%E7%A2%BA%E9%81%8B%E8%A1%8C%E3%80%82%E9%80%99%E4%BA%9B%E6%98%AF%E6%95%B8%E6%93%9A%E8%A1%A8%E4%B8%AD%E5%83%85%E6%9C%89%E7%9A%84%202%20%E5%88%97%E5%AD%97%E7%AC%A6%E6%95%B8%E6%93%9A%E9%A1%9E%E5%9E%8B%E3%80%82%E6%88%91%E7%9A%84%E8%AA%A4%E8%A7%A3%E6%98%AF%E6%82%A8%E5%B0%8D%E5%88%86%E9%A1%9E%E8%AE%8A%E9%87%8F%E7%9A%84%E8%AB%8B%E6%B1%82%E8%A2%AB%E5%8C%85%E5%90%AB%E5%9C%A8%E7%AC%AC%E4%BA%8C%E5%80%8B%E8%A3%BD%E8%A1%A8%E4%B8%AD%EF%BC%8C%E6%84%8F%E6%80%9D%E6%98%AF%E5%AD%97%E7%AC%A6%E5%88%97%E3%80%82%E4%BD%86%E6%98%AF%E6%A0%B9%E6%93%9A%E6%82%A8%E7%9A%84%E6%9B%B4%E6%AD%A3%EF%BC%8C%E5%88%86%E9%A1%9E%E9%9C%80%E8%A6%81%E5%9C%A8%20Tabulate%20%E4%B8%AD%E5%8C%85%E6%8B%AC%20Wafer%20%E5%92%8C%20Site%EF%BC%8C%E9%9C%80%E8%A6%81%E4%BB%A5%E4%B8%8D%E5%90%8C%E6%96%B9%E5%BC%8F%E7%94%9F%E6%88%90%20CharacterCols%20%E5%88%97%E5%88%97%E8%A1%A8%E3%80%82%E5%B0%87%E6%B6%B5%E8%93%8B%E6%82%A8%E6%83%B3%E8%A6%81%E7%9A%84%E6%89%80%E6%9C%89%E5%88%97%E7%9A%84%E5%85%A7%E5%AE%B9%E6%98%AF%E5%8A%A0%E8%BC%89%E8%A9%B2%E5%88%97%E8%A1%A8%EF%BC%8C%E5%85%B6%E4%B8%AD%E5%8C%85%E5%90%AB%E5%BB%BA%E6%A8%A1%E9%A1%9E%E5%9E%8B%E7%82%BA%E2%80%9C%E5%90%8D%E7%BE%A9%E2%80%9D%E7%9A%84%E6%89%80%E6%9C%89%E5%88%97%E3%80%82%E5%9B%A0%E6%AD%A4%EF%BC%8C%E5%B0%87%E8%AA%9E%E5%8F%A5%E7%B0%A1%E5%96%AE%E6%9B%B4%E6%94%B9%E7%82%BA%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ECharacterCols%20%3D%20dt%20%26lt%3B%26lt%3B%20get%20column%20names(%20nominal%20)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%E5%B0%87%E6%94%BE%E5%85%A5%20CharacterCols%20%E5%88%97%E8%A1%A8%E4%B8%AD%EF%BC%8C%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3E%20%7Blot_id%2C%20wafer%2C%20Wafer%20ID%20in%20lot%20ID%2C%20SITE%7D%3B%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3E%E4%BF%AE%E6%94%B9%E5%BE%8C%E7%9A%84%20JSL%20%E5%A6%82%E4%B8%8B%3C%2FFONT%3E%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(%201%20)%3B%0Adt%20%3D%20Open(%20%22%24SAMPLE_DATA%2Fsemiconductor%20capability.jmp%22%20)%3B%0ACharacterCols%20%3D%20dt%20%26lt%3B%26lt%3B%20get%20column%20names(%20nominal%20)%3B%0A%0A%0Adt%20%26lt%3B%26lt%3B%20Tabulate(%0A%20Set%20Format(%20Name(%20%22%25%20of%20Total%22%20)(9%2C%200)%20)%2C%0A%20Show%20Control%20Panel(%200%20)%2C%0A%20Add%20Table(%0A%20%20Column%20Table(%20Statistics(%20N%2C%20Name(%20%22%25%20of%20Total%22%20)%20)%20)%2C%0A%20%20Row%20Table(%20Grouping%20Columns(%20eval(%20CharacterCols%20)%20)%20)%0A%20)%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-268741%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E5%B0%87%E8%A1%A8%E6%A0%BC%E4%B8%AD%E7%9A%84%E6%89%80%E6%9C%89%E6%95%B8%E5%AD%97%E5%88%97%E8%A3%BD%E6%88%90%E8%A1%A8%E6%A0%BC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-268741%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E6%84%9F%E8%AC%9D%E6%82%A8%E7%9A%84%E5%9B%9E%E5%A4%8D%EF%BC%8C%E4%BD%86%E6%98%AF%E6%82%A8%E7%99%BC%E5%B8%83%E7%9A%84%E4%BB%A3%E7%A2%BC%E6%B2%92%E6%9C%89%E6%8F%90%E4%BE%9B%E6%88%91%E9%9C%80%E8%A6%81%E7%9A%84%E8%A1%A8%E6%A0%BC%E3%80%82%3C%2FP%3E%3CP%3E%E9%80%99%E6%98%AF%E6%82%A8%E4%BD%BF%E7%94%A8%E7%9A%84%E6%95%B8%E6%93%9A%E6%96%87%E4%BB%B6%20examole%20%E7%9A%84%E4%BB%A3%E7%A2%BC%EF%BC%8C%E5%AE%83%E5%B0%87%E7%82%BA%E6%88%91%E6%8F%90%E4%BE%9B%E6%89%80%E9%9C%80%E7%9A%84%E8%A1%A8%E6%A0%BC%E3%80%82%3C%2FP%3E%3CP%3E%E6%82%A8%E6%9C%83%E6%B3%A8%E6%84%8F%E5%88%B0%E8%BC%B8%E5%87%BA%E6%98%AF%E4%B8%8D%E5%90%8C%E7%9A%84%E3%80%82%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ETabulate(%0A%20Add%20Table(%0A%20%20Column%20Table(%20Statistics(%20N%2C%20Name(%20%22%25%20of%20Total%22%20)%20)%20)%2C%0A%20%20Row%20Table(%20Grouping%20Columns(%20%3Alot_id%20)%20)%2C%0A%20%20Row%20Table(%20Grouping%20Columns(%20%3Awafer%20)%20)%2C%0A%20%20Row%20Table(%20Grouping%20Columns(%20%3AWafer%20ID%20in%20lot%20ID%20)%20)%2C%0A%20%20Row%20Table(%20Grouping%20Columns(%20%3ASITE%20)%20)%0A%20)%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%E6%88%91%E5%81%87%E8%A8%AD%E5%AD%98%E5%9C%A8%E5%B7%AE%E7%95%B0%E7%9A%84%E5%8E%9F%E5%9B%A0%E6%98%AF%E5%9B%A0%E7%82%BA%E9%80%99%E8%A3%A1%E6%AF%8F%E5%80%8B%E8%A1%8C%E8%A1%A8%E9%83%BD%E6%98%AF%E5%96%AE%E7%8D%A8%E8%AA%AA%E6%98%8E%E7%9A%84%EF%BC%8C%E4%BD%86%E6%98%AF%E5%B0%8D%E6%96%BC%E6%95%B8%E5%AD%97%E6%95%B8%E6%93%9A%EF%BC%8C%E5%AE%83%E5%80%91%E9%83%BD%E5%9C%A8%E5%90%8C%E4%B8%80%E5%80%8B%E7%9B%AE%E9%8C%84%E4%B8%8B%3C%2FP%3E%3CP%3E%22%E8%A1%8C%E8%A1%A8(%E5%88%86%E6%9E%90%E5%88%97(%22%3C%2FP%3E%3CP%3E%E7%84%B6%E5%BE%8C%E6%98%AF%E7%94%A8%E9%80%97%E8%99%9F%E5%88%86%E9%9A%94%E7%9A%84%E5%88%97%E5%90%8D%E5%88%97%E8%A1%A8%E3%80%82%3C%2FP%3E%3CP%3E%E9%80%99%E8%AE%93%E6%88%91%E6%83%B3%E5%88%B0%E5%B0%8D%E6%96%BC%E6%95%B8%E5%AD%97%E6%88%91%E5%8F%AF%E4%BB%A5%E4%BD%BF%E7%94%A8%E4%B8%80%E5%80%8B%E7%B0%A1%E5%96%AE%E7%9A%84%E5%88%97%E8%A1%A8%E8%80%8C%E4%B8%8D%E6%98%AF%E5%AD%97%E7%AC%A6%E3%80%82%3C%2FP%3E%3CP%3E%E6%84%9F%E8%AC%9D%E6%82%A8%E7%9A%84%E5%8F%83%E8%80%83%3CSPAN%3EScripting%20Guide%20%E6%88%91%E7%B5%95%E5%B0%8D%E6%87%89%E8%A9%B2%E6%8A%BD%E6%99%82%E9%96%93%E7%A0%94%E7%A9%B6%E4%B8%80%E4%B8%8B%EF%BC%81%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-268740%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E5%B0%87%E8%A1%A8%E6%A0%BC%E4%B8%AD%E7%9A%84%E6%89%80%E6%9C%89%E6%95%B8%E5%AD%97%E5%88%97%E8%A3%BD%E6%88%90%E8%A1%A8%E6%A0%BC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-268740%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E8%A3%BD%E8%A1%A8%E8%AA%9E%E6%B3%95%E6%98%AF%3CSTRONG%3E%E4%B8%8D%E6%98%AF%3C%2FSTRONG%3E%E5%AE%8C%E5%85%A8%E4%B8%8D%E5%90%8C%EF%BC%8C%E5%AF%A6%E9%9A%9B%E4%B8%8A%E9%99%A4%E4%BA%86%E2%80%9C%E5%88%86%E6%9E%90%E5%88%97%E2%80%9D%E6%94%B9%E7%82%BA%E2%80%9C%E5%88%86%E7%B5%84%E5%88%97%E2%80%9D%E5%A4%96%EF%BC%8C%E5%AE%83%E6%98%AF%E7%9B%B8%E5%90%8C%E7%9A%84%E3%80%82%20%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(%201%20)%3B%0Adt%20%3D%20Open(%20%22%24SAMPLE_DATA%2Fsemiconductor%20capability.jmp%22%20)%3B%0ACharacterCols%20%3D%20dt%20%26lt%3B%26lt%3B%20get%20column%20names(%20Character%20)%3B%0A%0Adt%20%26lt%3B%26lt%3B%20Tabulate(%0A%20Set%20Format(%20Name(%20%22%25%20of%20Total%22%20)(9%2C%200)%20)%2C%0A%20Show%20Control%20Panel(%200%20)%2C%0A%20Add%20Table(%0A%20%20Column%20Table(%20Statistics(%20N%2C%20Name(%20%22%25%20of%20Total%22%20)%20)%20)%2C%0A%20%20Row%20Table(%20Grouping%20Columns(%20eval(%20CharacterCols%20)%20)%20)%0A%20)%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%E6%88%91%E6%83%B3%E7%9F%A5%E9%81%93%EF%BC%8C%E6%98%AF%E4%BB%80%E9%BA%BC%E8%AE%93%E6%82%A8%E8%AA%8D%E7%82%BA%E8%AA%9E%E6%B3%95%E6%88%AA%E7%84%B6%E4%B8%8D%E5%90%8C%EF%BC%9F%E6%88%91%E5%81%87%E8%A8%AD%E6%82%A8%E6%AD%A3%E5%9C%A8%E4%BB%A5%E4%BA%A4%E4%BA%92%E6%96%B9%E5%BC%8F%E9%81%8B%E8%A1%8C%E5%88%86%E6%9E%90%E5%88%97%E7%9A%84%E7%A4%BA%E4%BE%8B%E8%A3%BD%E8%A1%A8%EF%BC%8C%E7%84%B6%E5%BE%8C%E8%AE%93%20JMP%20%E7%82%BA%E6%82%A8%E6%8F%90%E4%BE%9B%E9%81%8B%E8%A1%8C%E7%A4%BA%E4%BE%8B%E7%9A%84%20JSL%EF%BC%8C%E7%84%B6%E5%BE%8C%E5%B0%8D%E5%AD%97%E7%AC%A6%E5%88%97%E9%87%8D%E8%A4%87%E7%9B%B8%E5%90%8C%E7%9A%84%E6%93%8D%E4%BD%9C%E3%80%82%E9%82%A3%E6%9C%83%E5%90%91%E6%82%A8%E5%B1%95%E7%A4%BA%E5%B9%BE%E4%B9%8E%E7%9B%B8%E5%90%8C%E7%9A%84%20JSL%E3%80%82%E6%88%91%E6%83%B3%E5%B9%AB%E5%8A%A9%E6%82%A8%E5%BC%84%E6%B8%85%E6%A5%9A%E6%98%AF%E4%BB%80%E9%BA%BC%E8%AE%93%E6%82%A8%E5%BE%97%E5%87%BA%E7%B5%90%E8%AB%96%EF%BC%8C%E9%80%99%E6%A8%A3%E6%88%91%E5%B0%B1%E5%8F%AF%E4%BB%A5%E5%B9%AB%E5%8A%A9%E6%82%A8%E7%9B%A1%E5%8F%AF%E8%83%BD%E8%BC%95%E9%AC%86%E5%9C%B0%E5%89%B5%E5%BB%BA%E8%85%B3%E6%9C%AC%E3%80%82%3C%2FP%3E%0A%3CP%3E%E5%93%A6....%E4%BD%A0%E9%9C%80%E8%A6%81%E9%96%B1%E8%AE%80%E8%85%B3%E6%9C%AC%E6%8C%87%E5%8D%97.....%E9%96%B1%E8%AE%80%E5%AE%83%E6%98%AF%E7%84%A1%E5%8F%AF%E6%9B%BF%E4%BB%A3%E7%9A%84%E3%80%82%3C%2FP%3E%0A%3CP%3E%E5%B9%AB%E5%8A%A9%3D%3D%26gt%3BJMP%20%E6%96%87%E6%AA%94%E5%BA%AB%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6..%E8%85%B3%E6%9C%AC%E6%8C%87%E5%8D%97%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-268730%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E5%B0%87%E8%A1%A8%E6%A0%BC%E4%B8%AD%E7%9A%84%E6%89%80%E6%9C%89%E6%95%B8%E5%AD%97%E5%88%97%E8%A3%BD%E6%88%90%E8%A1%A8%E6%A0%BC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-268730%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E4%BD%A0%E5%A5%BD%EF%BC%8C%3C%2FP%3E%3CP%3E%E5%A4%9A%E8%AC%9D%EF%BC%81%3C%2FP%3E%3CP%3E%E6%88%91%E7%8F%BE%E5%9C%A8%E7%9C%8B%E5%88%B0%E5%88%86%E9%A1%9E%E5%88%97%E7%9A%84%E8%AA%9E%E6%B3%95%E5%AE%8C%E5%85%A8%E4%B8%8D%E5%90%8C%E3%80%82%3C%2FP%3E%3CP%3E%E5%A6%82%E6%9E%9C%E4%BD%A0%E6%83%B3%E8%A6%81%E4%B8%80%E5%80%8B%E5%8C%85%E5%90%AB%E4%BB%A5%E4%B8%8B%E5%85%A7%E5%AE%B9%E7%9A%84%E8%A1%A8%E6%A0%BC%EF%BC%8C%E4%BD%A0%E6%9C%83%E6%80%8E%E9%BA%BC%E5%81%9A%EF%BC%9A%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ESet%20Format(%20Name(%20%22%25%20of%20Total%22%20)(9%2C%200)%20)%2C%0A%20Add%20Table(%0A%20%20Column%20Table(%20Statistics(%20N%2C%20Name(%20%22%25%20of%20Total%22%20)%20)%20)%2C%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-268704%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E5%B0%87%E8%A1%A8%E6%A0%BC%E4%B8%AD%E7%9A%84%E6%89%80%E6%9C%89%E6%95%B8%E5%AD%97%E5%88%97%E8%A3%BD%E6%88%90%E8%A1%A8%E6%A0%BC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-268704%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E9%80%99%E6%98%AF%E5%B0%8D%E6%82%A8%E7%9A%84%E4%BB%A3%E7%A2%BC%E7%9A%84%E9%87%8D%E5%AF%AB%EF%BC%8C%E5%AE%83%E4%BD%BF%E7%94%A8%E6%9B%B4%E7%B0%A1%E5%96%AE%E7%9A%84%E6%96%B9%E6%B3%95%E4%BE%86%E7%8D%B2%E5%8F%96%E6%95%B8%E5%AD%97%E5%88%97%E5%90%8D%E7%A8%B1%EF%BC%8C%E7%84%B6%E5%BE%8C%E5%9C%A8%E6%95%B8%E5%AD%97%E5%88%97%E5%88%97%E8%A1%A8%E5%91%A8%E5%9C%8D%E6%B7%BB%E5%8A%A0%20Eval()%20%E5%87%BD%E6%95%B8%EF%BC%8C%E4%BB%A5%E4%BD%BF%E5%85%B6%E5%B7%A5%E4%BD%9C%3C%2FP%3E%0A%3CP%3E.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22tab.PNG%22%20style%3D%22width%3A%20443px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22tab.PNG%22%20style%3D%22width%3A%20443px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22tab.PNG%22%20style%3D%22width%3A%20443px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22tab.PNG%22%20style%3D%22width%3A%20443px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F24153i00A7355CCA614D3C%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22tab.PNG%22%20alt%3D%22tab.PNG%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(%201%20)%3B%0Adt%20%3D%20Open(%20%22%24SAMPLE_DATA%2Fsemiconductor%20capability.jmp%22%20)%3B%0ANumericCols%20%3D%20dt%20%26lt%3B%26lt%3B%20get%20column%20names(%20numeric%20)%3B%0A%0Adt%20%26lt%3B%26lt%3B%20Tabulate(%0A%20Set%20Format(%20Uniform%20Format(%2010%2C%202%20)%20)%2C%0A%20Show%20Control%20Panel(%200%20)%2C%0A%20Add%20Table(%0A%20%20Column%20Table(%20Statistics(%20N%20)%20)%2C%0A%20%20Column%20Table(%20Statistics(%20Mean%2C%20Std%20Dev%20)%20)%2C%0A%20%20Column%20Table(%20Statistics(%20Min%2C%20Max%20)%20)%2C%0A%20%20Column%20Table(%20Statistics(%20Median%20)%20)%2C%0A%20%20Row%20Table(%20Analysis%20Columns(%20Eval(%20Numericcols%20)%20)%20)%0A%20)%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-752504%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%E5%B0%87%E8%A1%A8%E4%B8%AD%E7%9A%84%E6%89%80%E6%9C%89%E6%95%B8%E5%AD%97%E6%AC%84%E4%BD%8D%E8%A3%BD%E6%88%90%E8%A1%A8%E6%A0%BC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-752504%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E6%88%91%E9%8C%AF%E8%AA%A4%E5%9C%B0%E7%B7%A8%E8%BC%AF%E4%BA%86%E4%B8%8A%E8%BF%B0%E5%95%8F%E9%A1%8C%E4%B8%A6%E5%B0%87%E5%95%8F%E9%A1%8C%E6%9B%B4%E6%94%B9%E7%82%BA%E6%88%91%E7%9A%84%E7%AD%94%E6%A1%88%E3%80%82%20%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7188%22%20target%3D%22_blank%22%3E%40eliyahu100%3C%2FA%3E%E6%88%91%E7%82%BA%E6%88%91%E7%9A%84%E9%8C%AF%E8%AA%A4%E9%81%93%E6%AD%89%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
eliyahu100
Level III

Tabulate all numeric columns in a table

Hi,

I'm trying to creat a tabulate table that cill contain all numeric columns (and then another one with the categorical ones).

I tryed running this but it doesn't work.

Any suggestion?

TIA

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
	NumericCols = {};
	for(i = 1, i <= N Cols(dt), i++,
		Col = Column(dt,i);
		ColDataType = Col << Get Data Type; 
		If( ColDataType == "Numeric",
			Insert Into(NumericCols,Col << Get Name);
			);
		);


Tabulate(	
	Set Format( Uniform Format( 10, 2 ) ),
	Add Table(
		Column Table( Statistics( N ) ),
		Column Table( Statistics( Mean ) ),
		Column Table( Statistics( Std Dev ) ),
		Column Table( Statistics( Min ) ),
		Column Table( Statistics( Max ) ),
		Column Table( Statistics( Median ) ),
		Row Table(
			Analysis Columns(
				NumericCols = {}
			)
		)
	)
)
10 REPLIES 10
txnelson
Super User

Re: Tabulate all numeric columns in a table

By mistake, I edited the above question and changed the question to my response.  @eliyahu100  I apologize for my mistake.

Jim

Recommended Articles