Subscribe Bookmark RSS Feed

Is the a method via vba automation to accomplish the same function as Drop Down Distributions > Stack?

mattpace0

Occasional Contributor

Joined:

Aug 23, 2016

From the Distributions drop down menu there is an item "Stack" which places the selected items in a horizontal layout, which is much more conducive for creating reports.

Is there a similar item available in vba automation please?

1 REPLY
mattflynn

Community Trekker

Joined:

Oct 16, 2012

 

// one easy option is to simple run a little JSL...
// Open sample data file - run distribution platform with "stack" option
Save Text File(
"C:\temp\DeleteMe.jsl",
"\[
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
Distribution(
Stack( 1 ),
Nominal Distribution(
Column( :age ),
Horizontal Layout( 1 ),
Vertical( 0 ),
Show Percents( 1 )
),
Continuous Distribution(
Column( :height ),
Horizontal Layout( 1 ),
Vertical( 0 ),
Show Percents( 1 )
)
);
]\"
);
// modify to point whereever your JMP executible resides
rc = Run Program(
Executable( "C:\Program Files\SAS\JMP" ),
Options({ " C:\temp\DeleteMe.jsl"}),
);
show(rc);

 

 

Best regards,

-Matt