cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

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%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E5%86%85%E3%81%AE%E3%81%99%E3%81%B9%E3%81%A6%E3%81%AE%E6%95%B0%E5%80%A4%E5%88%97%E3%82%92%E9%9B%86%E8%A8%88%E3%81%99%E3%82%8B%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-268685%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E3%82%84%E3%81%82%E3%80%81%3C%2FP%3E%3CP%3E%E3%81%99%E3%81%B9%E3%81%A6%E3%81%AE%E6%95%B0%E5%80%A4%E5%88%97%E3%82%92%E5%90%AB%E3%82%80%E9%9B%86%E8%A8%88%E8%A1%A8%E3%82%92%E4%BD%9C%E6%88%90%E3%81%97%E3%82%88%E3%81%86%E3%81%A8%E3%81%97%E3%81%A6%E3%81%84%E3%81%BE%E3%81%99(%E6%AC%A1%E3%81%AB%E3%80%81%E3%82%AB%E3%83%86%E3%82%B4%E3%83%AA%E5%88%97%E3%82%92%E5%90%AB%E3%82%80%E5%88%A5%E3%81%AE%E5%88%97)%E3%80%82%3C%2FP%3E%3CP%3E%E3%81%93%E3%82%8C%E3%82%92%E5%AE%9F%E8%A1%8C%E3%81%97%E3%81%A6%E3%81%BF%E3%81%BE%E3%81%97%E3%81%9F%E3%81%8C%E3%80%81%E3%81%86%E3%81%BE%E3%81%8F%E3%81%84%E3%81%8D%E3%81%BE%E3%81%9B%E3%82%93%E3%80%82%3C%2FP%3E%3CP%3E%E3%81%AA%E3%81%AB%E3%81%8B%E6%8F%90%E6%A1%88%E3%82%92%EF%BC%9F%3C%2FP%3E%3CP%3E%E3%83%86%E3%82%A3%E3%82%A2%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%E8%A1%A8%E3%81%AE%E3%81%99%E3%81%B9%E3%81%A6%E3%81%AE%E6%95%B0%E5%80%A4%E5%88%97%E3%82%92%E9%9B%86%E8%A8%88%E3%81%99%E3%82%8B%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-269059%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EPS%E3%80%82%3C%2FP%3E%3CP%3E%E3%81%93%E3%81%AE%E3%82%B3%E3%83%BC%E3%83%89%E3%82%92%E6%9B%B8%E3%81%8D%E7%9B%B4%E3%81%97%E3%81%A6%E3%80%81%E6%95%B0%E5%80%A4%E3%81%A7%E3%81%AF%E3%81%AA%E3%81%8F%E9%80%A3%E7%B6%9A%E5%88%97%E3%81%A7%E5%8B%95%E4%BD%9C%E3%81%99%E3%82%8B%E3%82%88%E3%81%86%E3%81%AB%E3%81%97%E3%81%BE%E3%81%97%E3%81%9F%E3%80%82%20%E5%AE%9F%E9%9A%9B%E3%81%AB%E3%81%AF%E5%85%AC%E7%A7%B0%E3%81%A7%E3%81%82%E3%82%8B%E3%81%8C%E6%95%B0%E5%80%A4%E3%83%87%E3%83%BC%E3%82%BF%E3%81%A8%E5%80%A4%E3%83%A9%E3%83%99%E3%83%AB%E3%82%92%E6%8C%81%E3%81%A4%E3%81%84%E3%81%8F%E3%81%A4%E3%81%8B%E3%81%AE%E5%88%97%E3%81%8C%E3%81%82%E3%82%8B%E3%81%9F%E3%82%81%E3%80%81%E3%81%93%E3%82%8C%E3%81%AF%E7%A7%81%E3%81%AE%E3%83%8B%E3%83%BC%E3%82%BA%E3%81%AB%E3%82%88%E3%82%8A%E9%81%A9%E3%81%97%E3%81%A6%E3%81%84%E3%81%BE%E3%81%99%E3%80%82%3C%2FP%3E%3CP%3E%E3%81%93%E3%82%8C%E3%81%8C%E7%A7%81%E3%81%8C%E4%BD%BF%E7%94%A8%E3%81%97%E3%81%9F%E6%9C%80%E7%B5%82%E7%9A%84%E3%81%AA%E3%82%B3%E3%83%BC%E3%83%89%E3%81%A7%E3%81%99%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%E5%8A%A9%E3%81%91%E3%81%A6%E3%81%8F%E3%82%8C%E3%81%A6%E3%81%A9%E3%81%86%E3%82%82%E3%81%82%E3%82%8A%E3%81%8C%E3%81%A8%E3%81%86%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%E8%A1%A8%E3%81%AE%E3%81%99%E3%81%B9%E3%81%A6%E3%81%AE%E6%95%B0%E5%80%A4%E5%88%97%E3%82%92%E9%9B%86%E8%A8%88%E3%81%99%E3%82%8B%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-268796%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E3%81%93%E3%81%93%E3%81%AB%E3%81%82%E3%81%AA%E3%81%9F%E3%81%8C%E6%9C%9B%E3%82%80%E3%81%93%E3%81%A8%E3%82%92%E3%81%99%E3%82%8B%E3%81%9F%E3%82%81%E3%81%AE1%E3%81%A4%E3%81%AE%E6%96%B9%E6%B3%95%E3%81%8C%E3%81%82%E3%82%8A%E3%81%BE%E3%81%99%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%E4%BB%96%E3%81%AE%E3%82%B3%E3%83%9F%E3%83%A5%E3%83%8B%E3%83%86%E3%82%A3%20%E3%83%A1%E3%83%B3%E3%83%90%E3%83%BC%E3%81%8C%E3%82%88%E3%82%8A%E8%89%AF%E3%81%84%E6%96%B9%E6%B3%95%E3%82%92%E4%BD%BF%E7%94%A8%E3%81%97%E3%81%A6%E3%81%84%E3%82%8B%E5%8F%AF%E8%83%BD%E6%80%A7%E3%81%8C%E3%81%82%E3%82%8A%E3%81%BE%E3%81%99%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%E8%A1%A8%E3%81%AE%E3%81%99%E3%81%B9%E3%81%A6%E3%81%AE%E6%95%B0%E5%80%A4%E5%88%97%E3%82%92%E9%9B%86%E8%A8%88%E3%81%99%E3%82%8B%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-268792%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E7%A7%81%E3%81%AB%E4%BB%98%E3%81%8D%E5%90%88%E3%81%A3%E3%81%A6%E3%81%8F%E3%82%8C%E3%81%A6%E3%81%82%E3%82%8A%E3%81%8C%E3%81%A8%E3%81%86%E3%80%82%20%E3%81%82%E3%81%AA%E3%81%9F%E3%81%8C%E9%80%81%E4%BF%A1%E3%81%97%E3%81%9F%202%20%E7%95%AA%E7%9B%AE%E3%81%AE%E3%82%B3%E3%83%BC%E3%83%89%E3%81%A7%E3%81%AF%E3%80%81%E3%81%BE%E3%81%A0%E5%BF%85%E8%A6%81%E3%81%AA%E7%B5%90%E6%9E%9C%E3%81%8C%E5%BE%97%E3%82%89%E3%82%8C%E3%81%BE%E3%81%9B%E3%82%93%E3%80%82%3C%2FP%3E%3CP%3E%E7%A7%81%E3%81%8C%E5%8F%96%E5%BE%97%E3%81%97%E3%82%88%E3%81%86%E3%81%A8%E3%81%97%E3%81%A6%E3%81%84%E3%82%8B%E7%B5%90%E6%9E%9C%E3%81%AF%E3%80%81%E5%89%8D%E3%81%AE%E6%8A%95%E7%A8%BF%E3%81%A7%E6%8A%95%E7%A8%BF%E3%81%97%E3%81%9F%E3%82%B3%E3%83%BC%E3%83%89%E3%81%AE%E7%B5%90%E6%9E%9C%E3%81%A7%E3%81%82%E3%82%8A%E3%80%81%E3%81%9D%E3%81%AE%E5%BE%8C%E3%81%AB%E3%81%82%E3%81%AA%E3%81%9F%E3%81%AE%E3%82%B3%E3%83%BC%E3%83%89%E3%81%8B%E3%82%89%E5%8F%96%E5%BE%97%E3%81%97%E3%81%9F%E7%B5%90%E6%9E%9C%E3%81%8C%E7%B6%9A%E3%81%8D%E3%81%BE%E3%81%99%E3%80%82%3C%2FP%3E%3CP%3E%E3%81%93%E3%82%8C%E3%81%AF%E7%A7%81%E3%81%8C%E5%8F%96%E5%BE%97%E3%81%97%E3%81%9F%E3%81%84%E3%82%82%E3%81%AE%E3%81%A7%E3%81%99%3A%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%E3%81%93%E3%82%8C%E3%81%AF%E3%80%81%E6%8A%95%E7%A8%BF%E3%81%95%E3%82%8C%E3%81%9F%E3%82%B3%E3%83%BC%E3%83%89%E3%82%92%E4%BD%BF%E7%94%A8%E3%81%97%E3%81%A6%E5%8F%96%E5%BE%97%E3%81%97%E3%81%9F%E3%82%82%E3%81%AE%E3%81%A7%E3%81%99%E3%80%82%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%3E%E3%83%86%E3%82%A3%E3%82%A2%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%E8%A1%A8%E3%81%AE%E3%81%99%E3%81%B9%E3%81%A6%E3%81%AE%E6%95%B0%E5%80%A4%E5%88%97%E3%82%92%E9%9B%86%E8%A8%88%E3%81%99%E3%82%8B%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%E3%81%AF%20Tabulate%20%E3%82%B3%E3%83%BC%E3%83%89%E3%81%AB%E3%81%AF%E3%81%82%E3%82%8A%E3%81%BE%E3%81%9B%E3%82%93%E3%80%82%E7%A7%81%E3%81%8C%E6%8F%90%E4%BE%9B%E3%81%97%E3%81%9F%20Tabulate%20%E3%82%B3%E3%83%BC%E3%83%89%E3%81%AF%E5%95%8F%E9%A1%8C%E3%81%AA%E3%81%8F%E5%8B%95%E4%BD%9C%E3%81%97%E3%81%BE%E3%81%99%E3%80%82%E5%95%8F%E9%A1%8C%E3%81%AF%E3%80%81%E8%A1%A8%E3%81%AB%E3%81%82%E3%82%8B%E5%88%97%E3%81%AE%E8%A8%AD%E5%AE%9A%E3%81%AB%E3%81%82%E3%82%8A%E3%81%BE%E3%81%99%E3%80%82%E7%A7%81%E3%81%8C%E3%81%82%E3%81%AA%E3%81%9F%E3%81%AB%E9%80%81%E3%81%A3%E3%81%9F%E6%9C%80%E5%BE%8C%E3%81%AE%E3%82%B3%E3%83%BC%E3%83%89%E3%81%A7%E3%81%AF%E3%80%81%E3%82%B9%E3%83%86%E3%83%BC%E3%83%88%E3%83%A1%E3%83%B3%E3%83%88%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%3ECharacterCols%20%E3%83%AA%E3%82%B9%E3%83%88%E3%81%AB%E5%85%A5%E5%8A%9B%E3%81%99%E3%82%8B%E3%81%A8%E3%80%81%E3%83%87%E3%83%BC%E3%82%BF%20%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E3%81%AE%E3%81%99%E3%81%B9%E3%81%A6%E3%81%AE%E5%88%97%E3%81%AE%E3%81%86%E3%81%A1%E3%80%81%E3%83%87%E3%83%BC%E3%82%BF%20%E3%82%BF%E3%82%A4%E3%83%97%E3%81%8C%E6%96%87%E5%AD%97%E3%81%A7%E3%81%97%E3%81%9F%E3%80%82%E3%81%BE%E3%81%9F%E3%80%81Tabulate%20%E3%81%AF%20Lot_id%20%E5%88%97%E3%80%81Lot%20ID%20%E3%81%AE%20Wafer%20ID%20%E5%88%97%E3%81%A7%E6%AD%A3%E3%81%97%E3%81%8F%E5%AE%9F%E8%A1%8C%E3%81%95%E3%82%8C%E3%81%BE%E3%81%97%E3%81%9F%E3%80%82%E3%81%93%E3%82%8C%E3%82%89%E3%81%AF%E3%80%81%E3%83%87%E3%83%BC%E3%82%BF%20%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E5%86%85%E3%81%AE%E6%96%87%E5%AD%97%E3%83%87%E3%83%BC%E3%82%BF%E5%9E%8B%E3%81%AE%202%20%E3%81%A4%E3%81%AE%E5%88%97%E3%81%AE%E3%81%BF%E3%81%A7%E3%81%99%E3%80%82%E5%88%86%E9%A1%9E%E5%A4%89%E6%95%B0%E3%81%AE%E3%83%AA%E3%82%AF%E3%82%A8%E3%82%B9%E3%83%88%E3%81%8C%202%20%E7%95%AA%E7%9B%AE%E3%81%AE%E9%9B%86%E8%A8%88%E3%80%81%E6%84%8F%E5%91%B3%E3%80%81%E6%96%87%E5%AD%97%E5%88%97%E3%81%AB%E5%90%AB%E3%81%BE%E3%82%8C%E3%81%A6%E3%81%84%E3%82%8B%E3%81%A8%E3%81%84%E3%81%86%E3%81%AE%E3%81%AF%E7%A7%81%E3%81%AE%E8%AA%A4%E8%A7%A3%E3%81%A7%E3%81%97%E3%81%9F%E3%80%82%E3%81%9F%E3%81%A0%E3%81%97%E3%80%81Classification%20%E3%81%AB%E3%81%AF%E3%80%81Tabulate%20%E3%81%AB%20Wafer%20%E3%81%A8%20Site%20%E3%82%92%E5%90%AB%E3%82%81%E3%82%8B%E5%BF%85%E8%A6%81%E3%81%8C%E3%81%82%E3%82%8B%E3%81%A8%E3%81%84%E3%81%86%E4%BF%AE%E6%AD%A3%E3%81%AB%E3%82%88%E3%82%8A%E3%80%81%E5%88%97%E3%81%AE%20CharacterCols%20%E3%83%AA%E3%82%B9%E3%83%88%E3%82%92%E5%88%A5%E3%81%AE%E6%96%B9%E6%B3%95%E3%81%A7%E7%94%9F%E6%88%90%E3%81%99%E3%82%8B%E5%BF%85%E8%A6%81%E3%81%8C%E3%81%82%E3%82%8A%E3%81%BE%E3%81%99%E3%80%82%E5%BF%85%E8%A6%81%E3%81%AA%E3%81%99%E3%81%B9%E3%81%A6%E3%81%AE%E5%88%97%E3%82%92%E3%82%AB%E3%83%90%E3%83%BC%E3%81%99%E3%82%8B%E3%81%AB%E3%81%AF%E3%80%81%E3%83%A2%E3%83%87%E3%83%AB%E5%8C%96%E3%82%BF%E3%82%A4%E3%83%97%E3%81%8C%E3%80%8C%E5%85%AC%E7%A7%B0%E3%80%8D%E3%81%AE%E3%81%99%E3%81%B9%E3%81%A6%E3%81%AE%E5%88%97%E3%82%92%E5%90%AB%E3%82%80%E3%83%AA%E3%82%B9%E3%83%88%E3%82%92%E3%83%AD%E3%83%BC%E3%83%89%E3%81%97%E3%81%BE%E3%81%99%E3%80%82%E3%81%97%E3%81%9F%E3%81%8C%E3%81%A3%E3%81%A6%E3%80%81%E3%82%B9%E3%83%86%E3%83%BC%E3%83%88%E3%83%A1%E3%83%B3%E3%83%88%E3%82%92%E6%AC%A1%E3%81%AE%E3%82%88%E3%81%86%E3%81%AB%E5%8D%98%E7%B4%94%E3%81%AB%E5%A4%89%E6%9B%B4%E3%81%99%E3%82%8B%E3%81%A8%E3%80%81%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%3ECharacterCols%20%E3%83%AA%E3%82%B9%E3%83%88%E3%81%AB%E9%85%8D%E7%BD%AE%E3%81%95%E3%82%8C%E3%81%BE%E3%81%99%E3%80%82%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3E%20%7Blot_id%2C%20%E3%82%A6%E3%82%A7%E3%83%BC%E3%83%8F%2C%20%E3%83%AD%E3%83%83%E3%83%88%20ID%20%E5%86%85%E3%81%AE%E3%82%A6%E3%82%A7%E3%83%BC%E3%83%8F%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%E5%A4%89%E6%9B%B4%E3%81%95%E3%82%8C%E3%81%9FJSL%E3%81%AF%E4%BB%A5%E4%B8%8B%E3%81%AE%E3%81%A8%E3%81%8A%E3%82%8A%E3%81%A7%E3%81%99%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%E8%A1%A8%E3%81%AE%E3%81%99%E3%81%B9%E3%81%A6%E3%81%AE%E6%95%B0%E5%80%A4%E5%88%97%E3%82%92%E9%9B%86%E8%A8%88%E3%81%99%E3%82%8B%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-268741%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E8%BF%94%E4%BF%A1%E3%81%82%E3%82%8A%E3%81%8C%E3%81%A8%E3%81%86%E3%81%94%E3%81%96%E3%81%84%E3%81%BE%E3%81%99%E3%81%8C%E3%80%81%E6%8A%95%E7%A8%BF%E3%81%97%E3%81%9F%E3%82%B3%E3%83%BC%E3%83%89%E3%81%A7%E3%81%AF%E5%BF%85%E8%A6%81%E3%81%AA%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E3%81%8C%E6%8F%90%E4%BE%9B%E3%81%95%E3%82%8C%E3%81%BE%E3%81%9B%E3%82%93%E3%80%82%3C%2FP%3E%3CP%3E%E3%81%93%E3%82%8C%E3%81%8C%E3%80%81%E4%BD%BF%E7%94%A8%E3%81%97%E3%81%9F%E3%83%87%E3%83%BC%E3%82%BF%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%81%AE%E4%BE%8B%E3%81%AE%E3%82%B3%E3%83%BC%E3%83%89%E3%81%A7%E3%81%99%E3%80%82%E3%81%93%E3%82%8C%E3%81%AB%E3%82%88%E3%82%8A%E3%80%81%E5%BF%85%E8%A6%81%E3%81%AA%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E3%81%8C%E5%BE%97%E3%82%89%E3%82%8C%E3%81%BE%E3%81%99%E3%80%82%3C%2FP%3E%3CP%3E%E5%87%BA%E5%8A%9B%E3%81%8C%E7%95%B0%E3%81%AA%E3%82%8B%E3%81%93%E3%81%A8%E3%81%AB%E6%B3%A8%E6%84%8F%E3%81%97%E3%81%A6%E3%81%8F%E3%81%A0%E3%81%95%E3%81%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%E7%A7%81%E3%81%8C%E9%81%95%E3%81%84%E3%81%8C%E3%81%82%E3%82%8B%E3%81%A8%E4%BB%AE%E5%AE%9A%E3%81%97%E3%81%9F%E7%90%86%E7%94%B1%E3%81%AF%E3%80%81%E3%81%93%E3%81%93%E3%81%A7%E3%81%AF%E5%90%84%E8%A1%8C%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E3%81%8C%E5%80%8B%E5%88%A5%E3%81%AB%E8%A8%98%E8%BC%89%E3%81%95%E3%82%8C%E3%81%A6%E3%81%84%E3%82%8B%E3%81%9F%E3%82%81%E3%81%A7%E3%81%99%E3%81%8C%E3%80%81%E6%95%B0%E5%80%A4%E3%83%87%E3%83%BC%E3%82%BF%E3%81%A7%E3%81%AF%E3%81%9D%E3%82%8C%E3%82%89%E3%81%AF%E3%81%99%E3%81%B9%E3%81%A6%E5%90%8C%E3%81%98%E4%B8%8B%E3%81%AB%E3%81%82%E3%81%A3%E3%81%9F%E3%81%9F%E3%82%81%E3%81%A7%E3%81%99%3C%2FP%3E%3CP%3E%22%E8%A1%8C%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB(%E5%88%86%E6%9E%90%E5%88%97(%22%3C%2FP%3E%3CP%3E%E6%AC%A1%E3%81%AB%E3%80%81%E3%82%B3%E3%83%B3%E3%83%9E%E3%81%A7%E5%8C%BA%E5%88%87%E3%82%89%E3%82%8C%E3%81%9F%E5%88%97%E5%90%8D%E3%81%AE%E3%83%AA%E3%82%B9%E3%83%88%E3%80%82%3C%2FP%3E%3CP%3E%E3%81%93%E3%82%8C%E3%81%AB%E3%82%88%E3%82%8A%E3%80%81%E6%95%B0%E5%AD%97%E3%81%AB%E3%81%AF%E5%8D%98%E7%B4%94%E3%81%AA%E3%83%AA%E3%82%B9%E3%83%88%E3%82%92%E4%BD%BF%E7%94%A8%E3%81%A7%E3%81%8D%E3%81%BE%E3%81%99%E3%81%8C%E3%80%81%E6%96%87%E5%AD%97%E3%81%AB%E3%81%AF%E4%BD%BF%E7%94%A8%E3%81%A7%E3%81%8D%E3%81%AA%E3%81%84%E3%81%A8%E6%80%9D%E3%81%84%E3%81%BE%E3%81%97%E3%81%9F%E3%80%82%3C%2FP%3E%3CP%3E%E5%8F%82%E8%80%83%E3%81%AB%E3%81%97%E3%81%A6%E3%81%84%E3%81%9F%E3%81%A0%E3%81%8D%E3%81%82%E3%82%8A%E3%81%8C%E3%81%A8%E3%81%86%E3%81%94%E3%81%96%E3%81%84%E3%81%BE%E3%81%99%3CSPAN%3E%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%97%E3%83%88%20%E3%82%AC%E3%82%A4%E3%83%89%20%E7%B5%B6%E5%AF%BE%E3%81%AB%E6%99%82%E9%96%93%E3%82%92%E8%A6%8B%E3%81%A4%E3%81%91%E3%81%A6%E5%8B%89%E5%BC%B7%E3%81%99%E3%82%8B%E5%BF%85%E8%A6%81%E3%81%8C%E3%81%82%E3%82%8A%E3%81%BE%E3%81%99%E3%80%82%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%E8%A1%A8%E3%81%AE%E3%81%99%E3%81%B9%E3%81%A6%E3%81%AE%E6%95%B0%E5%80%A4%E5%88%97%E3%82%92%E9%9B%86%E8%A8%88%E3%81%99%E3%82%8B%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-268740%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3ETabulate%20%E3%81%AE%E6%A7%8B%E6%96%87%E3%81%AF%E6%AC%A1%E3%81%AE%E3%81%A8%E3%81%8A%E3%82%8A%E3%81%A7%E3%81%99%E3%80%82%3CSTRONG%3E%E3%81%84%E3%81%84%E3%81%88%3C%2FSTRONG%3E%E3%81%BE%E3%81%A3%E3%81%9F%E3%81%8F%E7%95%B0%E3%81%AA%E3%82%8A%E3%81%BE%E3%81%99%E3%80%82%E5%AE%9F%E9%9A%9B%E3%81%AB%E3%81%AF%E3%80%81%E3%80%8C%E5%88%86%E6%9E%90%E5%88%97%E3%80%8D%E3%81%A8%E3%81%84%E3%81%86%E8%A8%80%E8%91%89%E3%81%8C%E3%80%8C%E3%82%B0%E3%83%AB%E3%83%BC%E3%83%97%E5%8C%96%E5%88%97%E3%80%8D%E3%81%AB%E5%A4%89%E6%9B%B4%E3%81%95%E3%82%8C%E3%81%9F%E3%81%93%E3%81%A8%E3%82%92%E9%99%A4%E3%81%84%E3%81%A6%E5%90%8C%E3%81%98%E3%81%A7%E3%81%99%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%E7%9F%A5%E3%82%8A%E3%81%9F%E3%81%84%E3%81%AE%E3%81%A7%E3%81%99%E3%81%8C%E3%80%81%E6%A7%8B%E6%96%87%E3%81%8C%E5%A4%A7%E5%B9%85%E3%81%AB%E7%95%B0%E3%81%AA%E3%82%8B%E3%81%A8%E6%80%9D%E3%82%8F%E3%82%8C%E3%82%8B%E7%90%86%E7%94%B1%E3%81%AF%E4%BD%95%E3%81%A7%E3%81%99%E3%81%8B%3F%E5%88%86%E6%9E%90%E5%88%97%E3%81%AE%E3%82%B5%E3%83%B3%E3%83%97%E3%83%AB%E9%9B%86%E8%A8%88%E3%82%92%E3%82%A4%E3%83%B3%E3%82%BF%E3%83%A9%E3%82%AF%E3%83%86%E3%82%A3%E3%83%96%E3%81%AB%E5%AE%9F%E8%A1%8C%E3%81%97%E3%80%81%E5%AE%9F%E8%A1%8C%E3%81%97%E3%81%9F%E3%82%B5%E3%83%B3%E3%83%97%E3%83%AB%E3%81%AE%20JSL%20%E3%82%92%20JMP%20%E3%81%AB%E6%8F%90%E4%BE%9B%E3%81%97%E3%81%A6%E3%82%82%E3%82%89%E3%81%84%E3%80%81%E6%96%87%E5%AD%97%E5%88%97%E3%81%AB%E5%AF%BE%E3%81%97%E3%81%A6%E5%90%8C%E3%81%98%E3%81%93%E3%81%A8%E3%82%92%E7%B9%B0%E3%82%8A%E8%BF%94%E3%81%97%E3%81%A6%E3%81%84%E3%82%8B%E3%81%A8%E6%83%B3%E5%AE%9A%E3%81%97%E3%81%A6%E3%81%84%E3%81%BE%E3%81%99%E3%80%82%E3%81%9D%E3%82%8C%E3%81%AF%E3%81%82%E3%81%AA%E3%81%9F%E3%81%AB%E3%81%BB%E3%81%A8%E3%82%93%E3%81%A9%E5%90%8C%E3%81%98JSL%E3%82%92%E7%A4%BA%E3%81%97%E3%81%9F%E3%81%A7%E3%81%97%E3%82%87%E3%81%86%E3%80%82%E3%81%82%E3%81%AA%E3%81%9F%E3%81%8C%E4%B8%8B%E3%81%97%E3%81%9F%E7%B5%90%E8%AB%96%E3%81%AB%E8%87%B3%E3%81%A3%E3%81%9F%E7%90%86%E7%94%B1%E3%82%92%E7%90%86%E8%A7%A3%E3%81%99%E3%82%8B%E3%81%AE%E3%82%92%E6%89%8B%E4%BC%9D%E3%81%84%E3%81%9F%E3%81%84%E3%81%AE%E3%81%A7%E3%80%81%E3%81%A7%E3%81%8D%E3%82%8B%E3%81%A0%E3%81%91%E7%B0%A1%E5%8D%98%E3%81%AB%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%97%E3%83%88%E3%82%92%E4%BD%9C%E6%88%90%E3%81%A7%E3%81%8D%E3%82%8B%E3%82%88%E3%81%86%E3%81%AB%E3%81%8A%E6%89%8B%E4%BC%9D%E3%81%84%E3%81%97%E3%81%BE%E3%81%99%E3%80%82%3C%2FP%3E%0A%3CP%3E%E3%81%82%E3%81%82...%E3%81%9D%E3%81%97%E3%81%A6%E3%80%81%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%97%E3%83%88%20%E3%82%AC%E3%82%A4%E3%83%89%E3%82%92%E8%AA%AD%E3%82%80%E5%BF%85%E8%A6%81%E3%81%8C%E3%81%82%E3%82%8A%E3%81%BE%E3%81%99....%E3%81%9D%E3%82%8C%E3%82%92%E8%AA%AD%E3%82%80%E3%81%93%E3%81%A8%E3%81%AB%E4%BB%A3%E3%82%8F%E3%82%8B%E3%82%82%E3%81%AE%E3%81%AF%E3%81%82%E3%82%8A%E3%81%BE%E3%81%9B%E3%82%93%E3%80%82%3C%2FP%3E%0A%3CP%3E%E3%83%98%E3%83%AB%E3%83%97%3D%3D%26gt%3BJMP%20%E3%83%89%E3%82%AD%E3%83%A5%E3%83%A1%E3%83%B3%E3%83%88%20%E3%83%A9%E3%82%A4%E3%83%96%E3%83%A9%E3%83%AA...%E2%80%A6%E2%80%A6..%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%97%E3%83%88%20%E3%82%AC%E3%82%A4%E3%83%89%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%E8%A1%A8%E3%81%AE%E3%81%99%E3%81%B9%E3%81%A6%E3%81%AE%E6%95%B0%E5%80%A4%E5%88%97%E3%82%92%E9%9B%86%E8%A8%88%E3%81%99%E3%82%8B%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-268730%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E3%82%84%E3%81%82%E3%80%81%3C%2FP%3E%3CP%3E%E3%81%A9%E3%81%86%E3%82%82%E3%81%82%E3%82%8A%E3%81%8C%E3%81%A8%E3%81%86%EF%BC%81%3C%2FP%3E%3CP%3E%E3%82%AB%E3%83%86%E3%82%B4%E3%83%AA%E5%88%97%E3%81%AE%E6%A7%8B%E6%96%87%E3%81%8C%E3%81%BE%E3%81%A3%E3%81%9F%E3%81%8F%E7%95%B0%E3%81%AA%E3%82%8B%E3%81%93%E3%81%A8%E3%81%8C%E3%82%8F%E3%81%8B%E3%82%8A%E3%81%BE%E3%81%97%E3%81%9F%E3%80%82%3C%2FP%3E%3CP%3E%E6%AC%A1%E3%81%AE%E3%82%88%E3%81%86%E3%81%AA%E9%9B%86%E8%A8%88%E8%A1%A8%E3%81%8C%E5%BF%85%E8%A6%81%E3%81%AA%E5%A0%B4%E5%90%88%E3%80%81%E3%81%93%E3%82%8C%E3%82%92%E3%81%A9%E3%81%AE%E3%82%88%E3%81%86%E3%81%AB%E8%A1%8C%E3%81%84%E3%81%BE%E3%81%99%E3%81%8B%E3%80%82%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%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E5%86%85%E3%81%AE%E3%81%99%E3%81%B9%E3%81%A6%E3%81%AE%E6%95%B0%E5%80%A4%E5%88%97%E3%82%92%E9%9B%86%E8%A8%88%E3%81%99%E3%82%8B%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-268704%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E3%81%93%E3%82%8C%E3%81%AF%E3%80%81%E3%82%88%E3%82%8A%E7%B0%A1%E5%8D%98%E3%81%AA%E6%96%B9%E6%B3%95%E3%81%A7%E6%95%B0%E5%80%A4%E5%88%97%E5%90%8D%E3%82%92%E5%8F%96%E5%BE%97%E3%81%97%E3%80%81%E6%95%B0%E5%80%A4%E5%88%97%E3%81%AE%E3%83%AA%E3%82%B9%E3%83%88%E3%81%AE%E5%91%A8%E3%82%8A%E3%81%AB%20Eval()%20%E9%96%A2%E6%95%B0%E3%82%92%E8%BF%BD%E5%8A%A0%E3%81%97%E3%81%A6%E6%A9%9F%E8%83%BD%E3%81%95%E3%81%9B%E3%82%8B%E3%82%B3%E3%83%BC%E3%83%89%E3%81%AE%E6%9B%B8%E3%81%8D%E7%9B%B4%E3%81%97%E3%81%A7%E3%81%99%E3%80%82%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%3ERe%3A%20%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E5%86%85%E3%81%AE%E3%81%99%E3%81%B9%E3%81%A6%E3%81%AE%E6%95%B0%E5%80%A4%E5%88%97%E3%82%92%E9%9B%86%E8%A8%88%E3%81%99%E3%82%8B%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-752504%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E8%AA%A4%E3%81%A3%E3%81%A6%E4%B8%8A%E8%A8%98%E3%81%AE%E8%B3%AA%E5%95%8F%E3%82%92%E7%B7%A8%E9%9B%86%E3%81%97%E3%80%81%E8%B3%AA%E5%95%8F%E3%82%92%E8%87%AA%E5%88%86%E3%81%AE%E5%9B%9E%E7%AD%94%E3%81%AB%E5%A4%89%E6%9B%B4%E3%81%97%E3%81%A6%E3%81%97%E3%81%BE%E3%81%84%E3%81%BE%E3%81%97%E3%81%9F%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%E9%96%93%E9%81%95%E3%81%84%E3%82%92%E3%81%8A%E8%A9%AB%E3%81%B3%E3%81%97%E3%81%BE%E3%81%99%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