Subscribe Bookmark RSS Feed

Simple SQL change to JSL code

volf

Staff

Joined:

Jun 23, 2011

Hi JMPers,

How to change Simple SQL to JSL code.




Thanks,
4 REPLIES
mattf

Community Trekker

Joined:

Jun 23, 2011

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 )
);

-->
mattf

Community Trekker

Joined:

Jun 23, 2011

Hi:

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

Best regards,
-Matt

mattf

Community Trekker

Joined:

Jun 23, 2011

Hi:

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

Best regards,
-Matt

mattf

Community Trekker

Joined:

Jun 23, 2011