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-752819%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E4%BD%BF%E7%94%A8%E2%80%9CSummary%E2%80%9D%E6%8C%87%E4%BB%A4%E6%B1%82%E5%B9%B3%E5%9D%87%E5%80%BC%E3%80%82%E5%A6%82%E4%BD%95%E4%BD%BF%E7%94%A8%E7%94%A2%E7%94%9F%E8%A1%A8%E6%A0%BC%E7%9A%84%E5%B9%B3%E5%9D%87%E5%80%BC%E6%AC%84%E4%BD%8D%E4%BE%86%E4%BF%9D%E7%95%99%E6%9C%89%E6%95%88%E6%95%B8%E5%AD%97%EF%BC%9F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-752819%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E6%88%91%E5%B7%B2%E7%B6%93%E7%9C%8B%E5%88%B0%E5%85%B7%E6%9C%89%E7%9B%B8%E5%90%8C%20JSL%20%E7%9A%84%20Big%20Class.jmp%20%E8%A1%A8%E7%8D%B2%E5%BE%97%E4%BA%86%E4%B8%80%E5%80%8B%E5%B7%B2%E4%BF%9D%E7%95%99%E5%A4%A7%E9%87%8F%E6%95%B8%E5%AD%97%E7%9A%84%E5%B9%B3%E5%9D%87%E5%88%97%EF%BC%8C%E4%BD%86%E6%88%91%E8%87%AA%E5%B7%B1%E7%9A%84%E8%A1%A8%E5%8D%BB%E6%B2%92%E6%9C%89%E3%80%82%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%0Adt%20%3D%20Current%20Data%20Table()%3B%0Ad2%20%3D%20dt%20%26lt%3B%26lt%3B%20Summary(%0A%09Group(%202%20)%2C%0A%09Mean(%204%20)%2C%0A%09Freq(%200%20)%2C%0A%09Weight(%200%20)%2C%0A%09Link%20to%20original%20data%20table(%200%20)%2C%0A%09statistics%20column%20name%20format(%20%22column%22%20)%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%E8%AC%9D%E8%AC%9D%EF%BC%81%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222024-05-08_15-59-13.png%22%20style%3D%22width%3A%20626px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222024-05-08_15-59-13.png%22%20style%3D%22width%3A%20626px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222024-05-08_15-59-13.png%22%20style%3D%22width%3A%20626px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222024-05-08_15-59-13.png%22%20style%3D%22width%3A%20626px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222024-05-08_15-59-13.png%22%20style%3D%22width%3A%20626px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222024-05-08_15-59-13.png%22%20style%3D%22width%3A%20626px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222024-05-08_15-59-13.png%22%20style%3D%22width%3A%20626px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222024-05-08_15-59-13.png%22%20style%3D%22width%3A%20626px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222024-05-08_15-59-13.png%22%20style%3D%22width%3A%20626px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222024-05-08_15-59-13.png%22%20style%3D%22width%3A%20626px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F64004iC8E3AFA9C61F3243%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222024-05-08_15-59-13.png%22%20alt%3D%222024-05-08_15-59-13.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-752819%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CLINGO-LABEL%3E%E5%9F%BA%E7%A4%8E%E8%B3%87%E6%96%99%E5%88%86%E6%9E%90%E8%88%87%E5%BB%BA%E6%A8%A1%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E%E8%A6%96%E7%AA%97%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-752830%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%20%E7%94%A8Summary%E6%8C%87%E4%BB%A4%E6%B1%82%E5%B9%B3%E5%9D%87%E5%80%BC%E3%80%82%E5%A6%82%E4%BD%95%E4%BD%BF%E7%94%A8%E7%94%A2%E7%94%9F%E8%A1%A8%E6%A0%BC%E7%9A%84%E5%B9%B3%E5%9D%87%E5%80%BC%E6%AC%84%E4%BD%8D%E4%BE%86%E4%BF%9D%E7%95%99%E6%9C%89%E6%95%88%E6%95%B8%E5%AD%97%EF%BC%9F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-752830%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CUL%3E%3CLI%3E%3CP%20class%3D%22%22%3E%E6%88%91%E7%9C%8B%E5%88%B0%20Big%20Class.jmp%20%E7%94%A2%E7%94%9F%E7%9A%84%E7%B8%BD%E8%A1%A8%E5%B7%B2%E8%87%AA%E5%8B%95%E6%A0%BC%E5%BC%8F%E5%8C%96%E3%80%82%3C%2FP%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222024-05-08_16-06-21.png%22%20style%3D%22width%3A%20660px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222024-05-08_16-06-21.png%22%20style%3D%22width%3A%20660px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222024-05-08_16-06-21.png%22%20style%3D%22width%3A%20660px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222024-05-08_16-06-21.png%22%20style%3D%22width%3A%20660px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222024-05-08_16-06-21.png%22%20style%3D%22width%3A%20660px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222024-05-08_16-06-21.png%22%20style%3D%22width%3A%20660px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222024-05-08_16-06-21.png%22%20style%3D%22width%3A%20660px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222024-05-08_16-06-21.png%22%20style%3D%22width%3A%20660px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222024-05-08_16-06-21.png%22%20style%3D%22width%3A%20660px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F64005i1E593C57E0993245%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222024-05-08_16-06-21.png%22%20alt%3D%222024-05-08_16-06-21.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-752844%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%20%E7%94%A8Summary%E6%8C%87%E4%BB%A4%E6%B1%82%E5%B9%B3%E5%9D%87%E5%80%BC%E3%80%82%E5%A6%82%E4%BD%95%E4%BD%BF%E7%94%A8%E7%94%A2%E7%94%9F%E8%A1%A8%E6%A0%BC%E7%9A%84%E5%B9%B3%E5%9D%87%E5%80%BC%E6%AC%84%E4%BD%8D%E4%BE%86%E4%BF%9D%E7%95%99%E6%9C%89%E6%95%88%E6%95%B8%E5%AD%97%EF%BC%9F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-752844%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E6%82%A8%E6%98%AF%E5%B8%8C%E6%9C%9B%E8%B3%87%E6%96%99%E8%A1%A8%E4%B8%AD%E7%9A%84%E5%AF%A6%E9%9A%9B%E5%80%BC%E5%83%85%E5%85%B7%E6%9C%89%E6%8C%87%E5%AE%9A%E6%95%B8%E9%87%8F%E7%9A%84%E6%9C%89%E6%95%88%E6%95%B8%E5%AD%97%EF%BC%8C%E9%82%84%E6%98%AF%E5%8F%AA%E8%A6%81%E6%B1%82%E7%B5%90%E6%9E%9C%E5%88%97%E7%9A%84%E6%A0%BC%E5%BC%8F%E5%85%B7%E6%9C%89%E6%8C%87%E5%AE%9A%E6%95%B8%E9%87%8F%E7%9A%84%E6%95%B8%E5%AD%97%EF%BC%9F%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%E9%A0%90%E8%A8%AD%E6%83%85%E6%B3%81%E4%B8%8B%EF%BC%8C%E7%95%B6%E7%82%BA%E6%A0%BC%E5%BC%8F%E4%B8%AD%E6%8C%87%E5%AE%9A%E5%B0%8F%E6%95%B8%E4%BD%8D%E6%95%B8%E7%9A%84%E8%B3%87%E6%96%99%E5%88%97%E7%94%A2%E7%94%9F%E7%B8%BD%E8%A8%88%E8%A1%A8%E6%99%82%EF%BC%8CJMP%20%E6%9C%83%E5%9C%A8%E8%BC%B8%E5%87%BA%E8%A1%A8%E7%B8%BD%E5%88%97%E4%B8%AD%E6%96%B0%E5%A2%9E%E9%A1%8D%E5%A4%96%E7%9A%84%E5%B0%8F%E6%95%B8%E4%BD%8D%E3%80%82%E8%A6%81%E5%B0%87%E6%A0%BC%E5%BC%8F%E7%9A%84%E6%9C%89%E6%95%88%E5%B0%8F%E6%95%B8%E4%BD%8D%E6%95%B8%E8%A8%AD%E7%82%BA%E9%99%A4%E6%AD%A4%E4%B9%8B%E5%A4%96%E7%9A%84%E4%BB%BB%E4%BD%95%E5%80%BC%EF%BC%8C%E5%B0%87%E9%9C%80%E8%A6%81%E6%96%B0%E5%A2%9E%20JSL%20%E4%BE%86%E8%A8%AD%E5%AE%9A%E6%A0%BC%E5%BC%8F%E3%80%82%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-752855%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%20%E7%94%A8Summary%E6%8C%87%E4%BB%A4%E6%B1%82%E5%B9%B3%E5%9D%87%E5%80%BC%E3%80%82%E5%A6%82%E4%BD%95%E4%BD%BF%E7%94%A8%E7%94%A2%E7%94%9F%E8%A1%A8%E6%A0%BC%E7%9A%84%E5%B9%B3%E5%9D%87%E5%80%BC%E6%AC%84%E4%BD%8D%E4%BE%86%E4%BF%9D%E7%95%99%E6%9C%89%E6%95%88%E6%95%B8%E5%AD%97%EF%BC%9F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-752855%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E6%88%91%E5%B8%8C%E6%9C%9B%3CSPAN%3E%E6%95%B8%E6%93%9A%E8%A1%A8%E4%B8%AD%E7%9A%84%E5%AF%A6%E9%9A%9B%E5%80%BC%E5%83%85%E5%85%B7%E6%9C%89%E6%8C%87%E5%AE%9A%E6%95%B8%E9%87%8F%E7%9A%84%E6%9C%89%E6%95%88%E6%95%B8%E5%AD%97%E3%80%82%3C%2FSPAN%3E%3C%2FP%3E%3CUL%3E%3CLI%3E%3CP%20class%3D%22%22%3E%E6%89%80%E4%BB%A5%E6%9C%80%E7%B5%82%E7%9A%84%E6%AA%94%E6%A1%88%E5%A4%A7%E5%B0%8F%E5%BE%88%E5%B0%8F%E3%80%82%3C%2FP%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%E8%AC%9D%E8%AC%9D%E5%90%89%E5%A7%86%EF%BC%81%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CUL%3E%3CLI%3E%3CP%20class%3D%22%22%3E%E8%A9%B2%E8%85%B3%E6%9C%AC%E7%9A%84%E9%AB%94%E7%A9%8D%E6%9B%B4%E5%A4%A7%E3%80%82%3C%2FP%3E%3C%2FLI%3E%3C%2FUL%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3EColumn(%20d2%2C%203%20)%20%26lt%3B%26lt%3B%20Format(%20%22Fixed%20Dec%22%2C%2020%2C%202%20)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3CUL%3E%3CLI%3E%3CP%20class%3D%22%22%3E%E4%B8%80%E5%AE%9A%E8%A6%81%E7%94%A8%E9%80%99%E5%80%8B%E8%85%B3%E6%9C%AC%E5%97%8E%EF%BC%9F%3C%2FP%3E%3C%2FLI%3E%3C%2FUL%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Er%20%3D%20N%20Row(%20d2%20)%3B%0Aar%20%3D%20d2%20%26lt%3B%26lt%3B%20GetAsMatrix(%203%20)%3B%0AFor(%20i%20%3D%201%2C%20i%20%26lt%3B%3D%20r%2C%20i%2B%2B%2C%0A%09ar%5Bi%2C%201%5D%20%3D%20Round(%20ar%5Bi%2C%201%5D%2C%202%20)%0A)%3B%0Ad2%5B0%2C%203%5D%20%3D%20ar%3B%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%20%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-752859%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%20%E7%94%A8Summary%E6%8C%87%E4%BB%A4%E6%B1%82%E5%B9%B3%E5%9D%87%E5%80%BC%E3%80%82%E5%A6%82%E4%BD%95%E4%BD%BF%E7%94%A8%E7%94%A2%E7%94%9F%E8%A1%A8%E6%A0%BC%E7%9A%84%E5%B9%B3%E5%9D%87%E5%80%BC%E6%AC%84%E4%BD%8D%E4%BE%86%E4%BF%9D%E7%95%99%E6%9C%89%E6%95%88%E6%95%B8%E5%AD%97%EF%BC%9F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-752859%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E6%9C%89%E5%A4%9A%E7%A8%AE%E6%96%B9%E6%B3%95%E5%8F%AF%E4%BB%A5%E5%A3%93%E7%B8%AE%E8%B3%87%E6%96%99%E3%80%82%E5%A6%82%E6%9E%9C%E4%BD%A0%E6%83%B3%E8%A6%81%E5%A3%93%E7%B8%AE%E7%89%B9%E5%AE%9A%E7%9A%84%E5%88%97%EF%BC%8C%E4%BD%A0%E5%8F%AF%E4%BB%A5%E9%81%B8%E6%93%87%E5%AE%83%E5%80%91%EF%BC%8C%E7%84%B6%E5%BE%8C%E8%BD%89%E5%88%B0%3C%2FP%3E%0A%3CP%3E%E5%88%97%3D%26gt%3B%E5%AF%A6%E7%94%A8%E7%A8%8B%E5%BC%8F%3D%26gt%3B%E5%A3%93%E7%B8%AE%E9%81%B8%E5%AE%9A%E7%9A%84%E5%88%97%3C%2FP%3E%0A%3CP%3E%E5%8F%AF%E4%BB%A5%E8%A8%AD%E5%AE%9A%E9%A6%96%E9%81%B8%E9%A0%85%E4%BB%A5%E5%A3%93%E7%B8%AE%E6%A0%BC%E5%BC%8F%E5%84%B2%E5%AD%98%E8%A1%A8%E6%A0%BC%E3%80%82%E9%82%84%E6%9C%89%E4%B8%80%E5%80%8B%E9%A6%96%E9%81%B8%E9%A0%85%E5%85%81%E8%A8%B1%E5%82%B3%E6%92%AD%E5%A3%93%E7%B8%AE%E5%88%97%E3%80%82%3C%2FP%3E%0A%3CP%3E%E6%9F%A5%E7%9C%8B%E5%B8%B8%E8%A6%8F%E9%A6%96%E9%81%B8%E9%A0%85%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-752875%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%20%E7%94%A8Summary%E6%8C%87%E4%BB%A4%E6%B1%82%E5%B9%B3%E5%9D%87%E5%80%BC%E3%80%82%E5%A6%82%E4%BD%95%E4%BD%BF%E7%94%A8%E7%94%A2%E7%94%9F%E8%A1%A8%E6%A0%BC%E7%9A%84%E5%B9%B3%E5%9D%87%E5%80%BC%E6%AC%84%E4%BD%8D%E4%BE%86%E4%BF%9D%E7%95%99%E6%9C%89%E6%95%88%E6%95%B8%E5%AD%97%EF%BC%9F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-752875%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CUL%3E%3CLI%3E%3CP%20class%3D%22%22%3E%E6%88%91%E7%9A%84%E6%95%B8%E6%93%9A%E8%A1%A8%E9%83%BD%E6%98%AF%E5%A3%93%E7%B8%AE%E7%9A%84%E3%80%82%3C%2FP%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222024-05-08_20-48-05.png%22%20style%3D%22width%3A%20577px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222024-05-08_20-48-05.png%22%20style%3D%22width%3A%20577px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222024-05-08_20-48-05.png%22%20style%3D%22width%3A%20577px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222024-05-08_20-48-05.png%22%20style%3D%22width%3A%20577px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222024-05-08_20-48-05.png%22%20style%3D%22width%3A%20577px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F64007i022DC1C2F5E19DB0%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222024-05-08_20-48-05.png%22%20alt%3D%222024-05-08_20-48-05.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-752878%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%20%E7%94%A8Summary%E6%8C%87%E4%BB%A4%E6%B1%82%E5%B9%B3%E5%9D%87%E5%80%BC%E3%80%82%E5%A6%82%E4%BD%95%E4%BD%BF%E7%94%A8%E7%94%A2%E7%94%9F%E8%A1%A8%E6%A0%BC%E7%9A%84%E5%B9%B3%E5%9D%87%E5%80%BC%E6%AC%84%E4%BD%8D%E4%BE%86%E4%BF%9D%E7%95%99%E6%9C%89%E6%95%88%E6%95%B8%E5%AD%97%EF%BC%9F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-752878%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E6%82%A8%E7%9A%84%E5%95%8F%E9%A1%8C%E6%98%AF%20RAM%20%E8%A8%98%E6%86%B6%E9%AB%94%E4%B8%AD%E8%B3%87%E6%96%99%E8%A1%A8%E7%9A%84%E5%A4%A7%E5%B0%8F%E9%82%84%E6%98%AF%E5%B0%87%E8%B3%87%E6%96%99%E5%84%B2%E5%AD%98%E5%88%B0%E7%A3%81%E7%A2%9F%EF%BC%9F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-752899%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%20%E7%94%A8Summary%E6%8C%87%E4%BB%A4%E6%B1%82%E5%B9%B3%E5%9D%87%E5%80%BC%E3%80%82%E5%A6%82%E4%BD%95%E4%BD%BF%E7%94%A8%E7%94%A2%E7%94%9F%E8%A1%A8%E6%A0%BC%E7%9A%84%E5%B9%B3%E5%9D%87%E5%80%BC%E6%AC%84%E4%BD%8D%E4%BE%86%E4%BF%9D%E7%95%99%E6%9C%89%E6%95%88%E6%95%B8%E5%AD%97%EF%BC%9F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-752899%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E9%99%A4%E4%BA%86%E6%82%A8%E8%A8%AD%E5%AE%9A%E7%9A%84%E9%A6%96%E9%81%B8%E9%A0%85%E4%B9%8B%E5%A4%96%EF%BC%8C%E6%88%91%E4%B8%8D%E7%9F%A5%E9%81%93%E6%82%A8%E9%82%84%E5%8F%AF%E4%BB%A5%E4%BD%BF%E7%94%A8%E4%BB%BB%E4%BD%95%E5%85%B6%E4%BB%96%E9%81%B8%E9%A0%85%E3%80%82%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%A4%9A%E8%B3%87%E8%A8%8A%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-752944%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%20%E7%94%A8Summary%E6%8C%87%E4%BB%A4%E6%B1%82%E5%B9%B3%E5%9D%87%E5%80%BC%E3%80%82%E5%A6%82%E4%BD%95%E4%BD%BF%E7%94%A8%E7%94%A2%E7%94%9F%E8%A1%A8%E6%A0%BC%E7%9A%84%E5%B9%B3%E5%9D%87%E5%80%BC%E6%AC%84%E4%BD%8D%E4%BE%86%E4%BF%9D%E7%95%99%E6%9C%89%E6%95%88%E6%95%B8%E5%AD%97%EF%BC%9F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-752944%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E5%A6%82%E6%9E%9C%E6%82%A8%E5%B7%B2%E7%B6%93%E5%95%9F%E7%94%A8%E4%BA%86%E5%A3%93%E7%B8%AE%E4%B8%A6%E4%B8%94%E5%8F%AF%E4%BB%A5%E6%8E%A5%E5%8F%97%E5%80%BC%E6%9B%B4%E6%94%B9%EF%BC%8C%E5%89%87%E5%8F%AF%E4%BB%A5%E5%83%8F%E6%82%A8%E5%BB%BA%E8%AD%B0%E7%9A%84%E9%82%A3%E6%A8%A3%E4%BD%BF%E7%94%A8%E5%BE%AA%E7%92%B0%E3%80%82%E4%B8%8B%E9%9D%A2%E7%9A%84%E5%BE%AA%E7%92%B0%E5%8F%AF%E8%83%BD%E6%AF%94%E6%82%A8%E7%9A%84%E5%BB%BA%E8%AD%B0%E7%B0%A1%E5%96%AE%E4%B8%80%E4%BA%9B%3C%2FP%3E%0A%3CPRE%3ENames%20Default%20To%20Here(1)%3B%0A%0Adt%20%3D%20Open(%22%24SAMPLE_DATA%2FBig%20Class.jmp%22)%3B%0A%0Adt_summary%20%3D%20dt%20%26lt%3B%26lt%3B%20Summary(%0A%09Group(%3Aage)%2C%0A%09Mean(%3Aheight)%2C%0A%09Freq(0)%2C%0A%09Weight(0)%2C%0A%09Link%20to%20original%20data%20table(0)%2C%0A%09statistics%20column%20name%20format(%22column%22)%0A)%3B%0A%0Acont_cols%20%3D%20dt_summary%20%26lt%3B%26lt%3B%20Get%20Column%20Names(Continuous%2C%20%22String%22)%3B%0AColumn(dt_summary%2C%20%22height%22)%20%26lt%3B%26lt%3B%20Format(%22Fixed%20Dec%22%2C%2020%2C%202)%3B%0A%0AFor%20Each(%7Bcolname%7D%2C%20cont_cols%2C%0A%09Column(dt_summary%2C%20colname)%20%26lt%3B%26lt%3B%20Set%20Values(%0A%09%09Round(dt_summary%5B0%2C%20colname%5D%2C%201)%3B%09%0A%09)%0A)%3B%0A%3C%2FPRE%3E%0A%3CP%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%0A%3C%2FCODE%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%E5%8F%A6%E5%A4%96%EF%BC%8C%E6%A0%B9%E6%93%9A%E6%82%A8%E7%9A%84%E6%95%B8%E6%93%9A%EF%BC%8C%E6%82%A8%E5%8F%AF%E8%83%BD%E6%83%B3%E8%A6%81%E4%BD%BF%E7%94%A8%E6%95%B4%E6%95%B8%EF%BC%8C%E5%9B%A0%E7%82%BA%E5%AE%83%E5%80%91%E4%BD%94%E7%94%A8%E7%9A%84%E7%A9%BA%E9%96%93%E8%BC%83%E5%B0%91%EF%BC%8C%E7%84%B6%E5%BE%8C%E6%82%A8%E5%8F%AF%E4%BB%A5%E5%B0%87%E5%AE%83%E5%80%91%E9%80%B2%E4%B8%80%E6%AD%A5%E5%A3%93%E7%B8%AE%E7%82%BA%E7%9F%AD%E6%95%B4%E6%95%B8%3CA%20href%3D%22https%3A%2F%2Fwww.jmp.com%2Fsupport%2Fhelp%2Fen%2F18.0%2F%23page%2Fjmp%2Fthe-shortinteger-format.shtml%23%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.jmp.com%2Fsupport%2Fhelp%2Fen%2F18.0%2F%20%23page%2F%20jmp%2Fthe-shortinteger-format.shtml%23%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
lala
Level IX

Averaging with the Summary command. How can I use the mean column of the generated table to keep a significant number?

I have seen Big Class.jmp's table with the same JSL get a mean column that already retains a significant number, but my own table does not.

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

dt = Current Data Table();
d2 = dt << Summary(
	Group( 2 ),
	Mean( 4 ),
	Freq( 0 ),
	Weight( 0 ),
	Link to original data table( 0 ),
	statistics column name format( "column" )
);

Thanks!

2024-05-08_15-59-13.png

10 REPLIES 10
jthi
Super User

回复: Averaging with the Summary command. How can I use the mean column of the generated table to keep a significant number?

If you have already enabled compressions and ok with the value changes, you can use a loop like you suggested. Loop below might be a bit simpler than your suggestion

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Big Class.jmp");

dt_summary = dt << Summary(
	Group(:age),
	Mean(:height),
	Freq(0),
	Weight(0),
	Link to original data table(0),
	statistics column name format("column")
);

cont_cols = dt_summary << Get Column Names(Continuous, "String");
Column(dt_summary, "height") << Format("Fixed Dec", 20, 2);

For Each({colname}, cont_cols,
	Column(dt_summary, colname) << Set Values(
		Round(dt_summary[0, colname], 1);	
	)
);

 

Also depending on your data, you might want to go for integers as they take less space and then you could further compress those to short-integers https://www.jmp.com/support/help/en/18.0/#page/jmp/the-shortinteger-format.shtml#

 

 

-Jarmo

Recommended Articles