Subscribe Bookmark RSS Feed

Invisible Tables

I've been doing some JSL programming recently which involves opening and closing a lot of data sets in rapid succession. Even if I minimize the windows or make them invisible as soon as I've opened them, I still get quite a bit of flashing on the screen which I want to eliminate. I'm currently doing quite a lot of this sort of thing:

4 REPLIES
mattf

Community Trekker

Joined:

Jun 23, 2011

I don't know about making a data table visible, the the hint below a source of tons of great tips might help:

/*-------------------------------------------------------------------*/
/* Jump into JMP(r) Scripting */
/* by Wendy Murphrey and Rosemary Lucas */
/* Copyright(c) 2009 by SAS Institute Inc., Cary, NC, USA */
/* SAS Publications order */
/* ISBN 978-1-59994-658-0 */
/*-------------------------------------------------------------------*/

mpb

Super User

Joined:

Jun 23, 2011

Regarding opening an existing dataset invisibly, here's the response I got from SAS a while back:

"You cannot specify an invisible option when opening established data tables."

I requested that feature be added in a future release and you may want to do the same, adding to the vote count.

Michael
statganda

Community Trekker

Joined:

Jun 23, 2011

The show window command works for JMP 7 but not in JMP 8, why is it like that? Is there a different command for JMP8?

thanks
pmroz

Super User

Joined:

Jun 23, 2011

I'm creating tabulations in a loop, converting them into a data table,
and then adding the results to a master results table.  I've
made the tabulation invisible, but the temporary data table does a lot
of flashing.  Any way to make the intermediate table invisible?



Here's some code from inside the loop:




style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="">  

style="font-size: 10pt; font-family: "Courier New"; color: rgb(0, 0, 221);">current
data
table

style="font-size: 10pt; font-family: "Courier New"; color: black;">(

style="font-size: 10pt; font-family: "Courier New"; color: black;">surv_dataset)

style="font-size: 10pt; font-family: "Courier New"; color: navy;">;

style="font-size: 10pt; font-family: "Courier New"; color: black;">





style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="">  
surv_dme_tab

style="font-size: 10pt; font-family: "Courier New"; color: navy;">=

style="font-size: 10pt; font-family: "Courier New"; color: black;">
Tabulate(





style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="">     
Show
Control Panel(

style="font-size: 10pt; font-family: "Courier New"; color: teal;">0

style="font-size: 10pt; font-family: "Courier New"; color: black;">
)

style="font-size: 10pt; font-family: "Courier New"; color: navy;">,

style="font-size: 10pt; font-family: "Courier New"; color: black;">





style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="">     
Add
Table(





style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="">        
Column
Table(
Grouping Columns(

style="font-size: 10pt; font-family: "Courier New"; color: navy;">:

style="font-size: 10pt; font-family: "Courier New"; color: black;">Time
Period )
)

style="font-size: 10pt; font-family: "Courier New"; color: navy;">,

style="font-size: 10pt; font-family: "Courier New"; color: black;">





style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="">        
Column
Table(
Grouping Columns(

style="font-size: 10pt; font-family: "Courier New"; color: navy;">:

style="font-size: 10pt; font-family: "Courier New"; color: black;">Time
Period

style="font-size: 10pt; font-family: "Courier New"; color: navy;">,

style="font-size: 10pt; font-family: "Courier New"; color: black;">

style="font-size: 10pt; font-family: "Courier New"; color: navy;">:

style="font-size: 10pt; font-family: "Courier New"; color: black;">Serious
)
)

style="font-size: 10pt; font-family: "Courier New"; color: navy;">,

style="font-size: 10pt; font-family: "Courier New"; color: black;">





style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="">        
Column
Table(
Grouping Columns(

style="font-size: 10pt; font-family: "Courier New"; color: navy;">:

style="font-size: 10pt; font-family: "Courier New"; color: black;">Time
Period

style="font-size: 10pt; font-family: "Courier New"; color: navy;">,

style="font-size: 10pt; font-family: "Courier New"; color: black;">

style="font-size: 10pt; font-family: "Courier New"; color: navy;">:

style="font-size: 10pt; font-family: "Courier New"; color: rgb(0, 0, 221);">Labeled

style="font-size: 10pt; font-family: "Courier New"; color: black;">
)
)

style="font-size: 10pt; font-family: "Courier New"; color: navy;">,

style="font-size: 10pt; font-family: "Courier New"; color: black;">





style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="">        
Row
Table(





style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="">              
Grouping
Columns(

style="font-size: 10pt; font-family: "Courier New"; color: navy;">:

style="font-size: 10pt; font-family: "Courier New"; color: black;">MV
Name )

style="font-size: 10pt; font-family: "Courier New"; color: green;">




style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="">        
)





style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="">     
)

style="font-size: 10pt; font-family: "Courier New"; color: navy;">,

style="font-size: 10pt; font-family: "Courier New"; color: black;">
invisible





style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="">  
)

style="font-size: 10pt; font-family: "Courier New"; color: navy;">;

style="font-size: 10pt; font-family: "Courier New"; color: black;">





style="font-size: 10pt; font-family: "Courier New"; color: black;">

 





style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="">  
surv_onept_dt

style="font-size: 10pt; font-family: "Courier New"; color: navy;">=

style="font-size: 10pt; font-family: "Courier New"; color: black;">
surv_dme_tab

style="font-size: 10pt; font-family: "Courier New"; color: navy;"><<

style="font-size: 10pt; font-family: "Courier New"; color: black;">
make into data
table

style="font-size: 10pt; font-family: "Courier New"; color: navy;">

style="font-size: 10pt; font-family: "Courier New"; color: black;">

style="font-size: 10pt; font-family: "Courier New"; color: navy;">;

style="font-size: 10pt; font-family: "Courier New"; color: black;">





style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="">  
surv_dme_tab
style=""> 

style="font-size: 10pt; font-family: "Courier New"; color: navy;"><<

style="font-size: 10pt; font-family: "Courier New"; color: black;">
close window

style="font-size: 10pt; font-family: "Courier New"; color: navy;">;

style="font-size: 10pt; font-family: "Courier New"; color: black;">





style="font-size: 10pt; line-height: 115%; font-family: "Courier New"; color: black;">
style="">  
surv_onept_dt

style="font-size: 10pt; line-height: 115%; font-family: "Courier New"; color: navy;"><<

style="font-size: 10pt; line-height: 115%; font-family: "Courier New"; color: black;">
minimize window(

style="font-size: 10pt; line-height: 115%; font-family: "Courier New"; color: teal;">1

style="font-size: 10pt; line-height: 115%; font-family: "Courier New"; color: black;">)

style="font-size: 10pt; line-height: 115%; font-family: "Courier New"; color: navy;">;




I've tried changing the creation line to this but it doesn't work:




style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="">  
surv_onept_dt

style="font-size: 10pt; font-family: "Courier New"; color: navy;">=

style="font-size: 10pt; font-family: "Courier New"; color: black;">
surv_dme_tab

style="font-size: 10pt; font-family: "Courier New"; color: navy;"><<

style="font-size: 10pt; font-family: "Courier New"; color: black;">
make into data
table

style="font-size: 10pt; font-family: "Courier New"; color: navy;"><<

style="font-size: 10pt; font-family: "Courier New"; color: black;">
invisible

style="font-size: 10pt; font-family: "Courier New"; color: navy;">;

style="font-size: 10pt; font-family: "Courier New"; color: black;">





style="font-size: 10pt; font-family: "Courier New"; color: black;">
style="">


Thanks in advance!

Peter