Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
arenie
Level I

Count N

Hello All,

 

I am fairly new to JMP. I would like a question on a data I am working on. For some reason I need to convert the date column to Char/Nomina(as attached). I need to plot the X and Y and at X-axis being my date column while at the Y-axis I have 2 continuous parameters. My question is how to create a script where I can filter the date count if it is more/less than a certain number. For example, in this case the if the date count is less than 6, then I will exclude 20171108. Something like that. I understood that I can also use summary statistics N to do it with graph builder but I wanna do it with jsl.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
gzmorgan0
Super User

Re: Count N

Try this with your source data table opened.

 

Names Default to Here(1);

dt = current data table();

dt << clear select();

dtsum = dt << Summary(Group(:date), N);
//by default the sumary table is linked to the source table

dtsum << select where(:N < 6);

close(dtsum,Nosave); //no longer needed, and the rows are selected in the source

dt << exclude(1);

 

View solution in original post

2 REPLIES 2
Highlighted
gzmorgan0
Super User

Re: Count N

Try this with your source data table opened.

 

Names Default to Here(1);

dt = current data table();

dt << clear select();

dtsum = dt << Summary(Group(:date), N);
//by default the sumary table is linked to the source table

dtsum << select where(:N < 6);

close(dtsum,Nosave); //no longer needed, and the rows are selected in the source

dt << exclude(1);

 

View solution in original post

Highlighted
arenie
Level I

Re: Count N

Thanks a lot, gzmorgan0. It works!
Article Labels

    There are no labels assigned to this post.