We’re asking you to select a content label when starting a new topic in the Discussions area. Read more to find out why.
Choose Language Hide Translation Bar
Highlighted
volf
Staff (Retired)

Simple SQL change to JSL code

Hi JMPers,

How to change Simple SQL to JSL code.




Thanks,
0 Kudos
4 REPLIES 4
Highlighted
mattf
Level V

Re: Simple SQL change to JSL code

Hi:

Here is one way to create such a table - There are undoubtably others.

Best regards,
-Matt

<-

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

df = dt << Data Filter(
Mode( Show( 0 ) ),
Add Filter(
columns( :age ),
Where( :weight >= 30 & :weight <= 100 )
)
);

Data Table( "Big Class" ) << Subset(
Copy formula( 0 ),
Rows( [1, 3, 5, 6, 8, 11, 12, 14, 15, 16, 17, 19, 20, 21, 22, 24, 26, 28] ),
columns( :age )
);

-->
0 Kudos
Highlighted
mattf
Level V

Re: Simple SQL change to JSL code

Hi:

Here is one way to create such a table - There are undoubtably others.

Best regards,
-Matt

0 Kudos
Highlighted
mattf
Level V

Re: Simple SQL change to JSL code

Hi:

Here is one way to create such a table - There are undoubtably others.

Best regards,
-Matt

0 Kudos
Highlighted
mattf
Level V

Re: Simple SQL change to JSL code

 
0 Kudos