topic Re: why this script is not working?? in Discussions

why this script is not working??

Song — Fri, 13 Mar 2020 08:27:53 GMT

Names Default To Here( 1 );





dd = Current Data Table();

i=1;


newdt&i = dd << Subset( Output Table Name( "i" ), All Columns( 1 ), All Rows( 1 ) );
//Graph table 



newdt&1 << Select columns( :As is Config );

this script is not working at select columns....

please solve it ..

Re: why this script is not working??

txnelson — Fri, 13 Mar 2020 12:24:00 GMT

You appear to be attempting to use SAS Macro syntax in a JMP script. &i is not valid for JSL.

One way to handle what you are attempting to do in JSL is

Names Default To Here( 1 );

dd = Current Data Table();

i = 1;

Eval(
	Substitute(
			Expr(
				__xxx__ = dd << Subset( Output Table Name( "i" ), All Columns( 1 ), All Rows( 1 ) );
//Graph table 

				__xxx__ << Select columns( :As is Config );
			),
		Expr( __xxx__ ), Parse( "newdt" || Char( i ) )
	)
);

Documentation on this is in the Scripting Guide. You need to take the time to read through the documentation.

Help=>JMP Documentation Library=>Scripting Guide

Re: why this script is not working??

Song — Wed, 18 Mar 2020 03:06:30 GMT

Thanks a lot! :)