topic Re: How do I macro variables with JMP, e.g. like SAS macro variables (scripting, JSL) in Discussions

How do I macro variables with JMP, e.g. like SAS macro variables (scripting, JSL)

Newbie2Jumpie — Mon, 29 Jul 2019 09:27:40 GMT

Let's imagine we work with the JMP file "abrasion.jmp", and we would want to like to apply something like the functionality of SAS' %let macro variables.

In SAS I could execute WHERE clauses like ...

(1) "where ABRASION is (&MY_ABRASION.);"

... after having specified the macro vars before like: %let MY_ABRASION=133 ; (e.g. 1st usage)

%let MY_ABRASION=145 ; (e.g. 2nd usage)

(2) "where DATE eq (&MY_DATE.);"

...after having specified the macro vars before like: %let MY_DATE="29Feb1995"d; (e.g. 1st usage)

%let MY_DATE="2May1995"d ; (e.g. 2nd usage)

(3) or even as combination like "where DATE eq (&MY_DATE.) and ABRASION is (&MY_ABRASION.)"; ...

How could you do that in JMP?

Please provide practical examples.

Thanks a lot,

Newbie (still)

Re: How do I macro variables with JMP, e.g. like SAS macro variables (scripting, JSL)

txnelson — Mon, 29 Jul 2019 12:42:36 GMT

Below are a couple of examples where JMP variables are used with JMP data table columns to achieve similar functionality as in your SAS MACRO examples.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/big class.jmp" );

my_gender = "M";

Bivariate( Y( :height ), X( :weight ), Where( :sex == my_gender ) );

dtAirline = Open( "$SAMPLE_DATA/Aircraft Incidents.jmp" );
my_date = Informat( "01/23/2001", Date MDY( 10 ) );

dtAirline << select where( :Event Date <= my_date );

dtAirlineSubset = dtAirline << subset( selected columns( 0 ), selected rows( 1 ) );
dtAirlineSubset << run script( "Graph Builder Map" );

The best documentation for learning about the JMP Scripting Language is found in the Scripting Guide

Help==>Books==>Scripting Guide

I strongly suggest that you take the time to read through it

Re: How do I macro variables with JMP, e.g. like SAS macro variables (scripting, JSL)

numerics — Mon, 28 Oct 2019 11:59:31 GMT

To show the beauty of this feature, you can also use the actual value in a title such as we know from SAS, i.e., "&string."

For example:

Bivariate( Y( :height ), X( :weight ), Where( :sex == my_gender ), Title("Selection: " || my_gender ));

So, this allows to develop an application quite generically :)