cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
pmroz
Super User pmroz
Super User

List Minus or Subtraction

Sep 7, 2010 11:17 AM (3762 views)
Hello all,

Is there a way in JMP to subtract one list from another, kind of like a SQL MINUS? For example I want to do the following:

biglist = {"a", "b", "c", "d", "e", "f", "g"};

shortlist = {"a", "b", "c"};

newlist = biglist MINUS shortlist;

Newlist would be {"d", "e", "f", "g"};

Thanks,
Peter
0 Kudos
4 REPLIES 4
pmroz
Super User pmroz
Super User

Re: List Minus or Subtraction

Sep 7, 2010 12:04 PM (3714 views)  |  Posted in reply to message from pmroz 09-07-2010
Well I figured something out:





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

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: purple;">"a"
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: purple;">"b"
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: purple;">"c"
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: purple;">"d"
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: purple;">"e"
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: purple;">"f"
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: purple;">"g"
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="font-size: 10pt; font-family: "Courier New"; color: black;">shortlist

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: purple;">"a"
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: purple;">"b"
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: purple;">"c"
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="font-size: 10pt; font-family: "Courier New"; color: black;">newlist

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="font-size: 10pt; font-family: "Courier New"; color: rgb(0, 0, 221);">for
style="font-size: 10pt; font-family: "Courier New"; color: black;">
(i

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: teal;">1
style="font-size: 10pt; font-family: "Courier New"; color: navy;">,
style="font-size: 10pt; font-family: "Courier New"; color: black;">
i
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: rgb(0, 0, 221);">nitems
style="font-size: 10pt; font-family: "Courier New"; color: black;">(
style="font-size: 10pt; font-family: "Courier New"; color: black;">biglist)
style="font-size: 10pt; font-family: "Courier New"; color: navy;">,
style="font-size: 10pt; font-family: "Courier New"; color: black;">
i
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="">     

style="font-size: 10pt; font-family: "Courier New"; color: rgb(0, 0, 221);">if
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);">contains
style="font-size: 10pt; font-family: "Courier New"; color: black;">(
style="font-size: 10pt; font-family: "Courier New"; color: black;">shortlist
style="font-size: 10pt; font-family: "Courier New"; color: navy;">,
style="font-size: 10pt; font-family: "Courier New"; color: black;">
biglist[i])
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="">           

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





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

style="font-size: 10pt; font-family: "Courier New"; color: rgb(0, 0, 221);">insertinto
style="font-size: 10pt; font-family: "Courier New"; color: black;">(
style="font-size: 10pt; font-family: "Courier New"; color: black;">newlist
style="font-size: 10pt; font-family: "Courier New"; color: navy;">,
style="font-size: 10pt; font-family: "Courier New"; color: black;">
biglist[i])
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="">     
)
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: navy;">;
style="font-size: 10pt; font-family: "Courier New"; color: black;">





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

 




 







But it would be great if there were an easier way.




I'm actually trying to see the difference between two datasets. I can do a difference between two ID-value columns, but ideally I'd like to see all the rows in one dataset that are not in the other. A SQL MINUS would be perfect!




Regards,


Peter
0 Kudos
aim
aim
Level II

Re: List Minus or Subtraction

Sep 7, 2010 11:38 PM (3714 views)  |  Posted in reply to message from pmroz 09-07-2010
The SQL MINUS functionality can be simulated in JMP by data table "Update" method. It works like this:

- take two data tables, which have some common data

- add a dummy column with all values as "1" to first dt;

- add a dummy column with the same name to the second dt, but this time with all values as "0";

- "update" first dt with second dt by matching columns (excluding dummy ones!)



After the update, dummy column in first table will have "0" for rows that are matched to the second dt, and "1" for rows that are different. What is left at this point is to subset all this rows with dummy value "1" to get data table with differences.


Here is a function, which can get difference between two data tables using method described above, and a couple examples of using it.










style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">/////////////////////////////////////////////////////////////////////////////////
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//Function
jmp_SQL_MINUS
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//performs
substraction on data sets, similar to "SQL MINUS"
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//
style="mso-spacerun: yes">  result_dt = dt1 - dt2
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//MUST have
at least one column with similar name in BOTH data tables
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//Arguments:
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//
style="mso-spacerun: yes">  dt1 - first table
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//
style="mso-spacerun: yes">  dt2 - second table
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//
style="mso-spacerun: yes">  new_table_name - name of the resulting
table
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">/////////////////////////////////////////////////////////////////////////////////
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

 




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">jmp_SQL_MINUS

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Function
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
{dt1
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
dt2
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
new_table_name}
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">      {Default
Local}
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">     
style="mso-spacerun: yes">    




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//Get list
of columns with matching names between 2 tables
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">      cl1

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> dt1

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'"><<
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> get column
names( string )
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">      cl2

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> dt2

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'"><<
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> get column
names( string )
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">      dt2_nc

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">N
Cols
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> dt2
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">      col_str

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"Match
Columns("
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">     
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">For
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> ii

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">1
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> ii

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'"><=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
dt2_nc
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
ii
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">++,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 2">           

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">If
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Contains
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
cl1
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
cl2[ii] )
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 3">                 
col_str
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> col_str

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">||
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">":Name(\!""
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">||
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
cl2[ii]
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">||
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"\!")==:Name(\!""
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">||
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
cl2[ii]
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">||
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"\!")"
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">||
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">If(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">ii
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">==
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">dt2_nc
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">""
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">","
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">)
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 2">           
)




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">     
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">      col_str

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> col_str

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">||
style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">")"
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">     




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//Build
"update" expression using template
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">      column_expr

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Parse
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> col_str
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">      template_expr

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Name
Expr
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> dt1

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'"><<
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
Update( With( _dt2_ )
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> _col_list_
) )
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">      update_expr

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Substitute
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Name
Expr
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
template_expr )
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 2">           

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Expr
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> _dt2_
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Name
Expr
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Data
Table
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> dt2

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'"><<
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> get name
) )
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 2">           

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Expr
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> _col_list_
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Name
Expr
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> column_expr
)




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">     
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

 




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//Create
helper column with unique name
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">      dt1

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'"><<
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">New
Column
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"_f_l_a_g_"
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
numeric
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
continuous
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> Set Each
Value(
style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">1
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> )
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">      dt2

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'"><<
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">New
Column
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"_f_l_a_g_"
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
numeric
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
continuous
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> Set Each
Value(
style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">0
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> )
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">     




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//Run
"update" expression. After this step helper column shows "0" for values that
are matched between two tables,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//and "1"
for values that are different
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">     
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Eval
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> update_expr
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">     




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//Extracting
list of values that are not matched
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">      dt1

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'"><<
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> Clear
Select
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">      dt1

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'"><<
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> Clear
Column Selection
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">      dt1

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'"><<
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> Select
Where(
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">:
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">Name(

style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"_f_l_a_g_"
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> )

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">==
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">1
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">      dt3

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> dt1

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'"><<
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
Subset( Output Table( new_table_name )
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> Copy
formula(
style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">0
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> Ignore
Missing (
style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">0
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">)
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">     




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//Cleanup
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">      dt1

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'"><<
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> Delete
Column(
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">:
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">Name(

style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"_f_l_a_g_"
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> )
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">      dt2

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'"><<
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> Delete
Column(
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">:
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">Name(

style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"_f_l_a_g_"
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> )
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">      dt3

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'"><<
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> Delete
Column(
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">:
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">Name(

style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"_f_l_a_g_"
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> )
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

 




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//Outputting
result
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">      dt3
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

 




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">/////////////////////////////////////////////////////////////////////////////////
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">/////////////////////////////////////////////////////////////////////////////////
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//Example of
usage
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

 




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//open "big
table"
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">dt

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Open
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"$SAMPLE_DATA/Big
Class.jmp"
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

 




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//subset of
"big table", only 10 rows and a couple of columns
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">sub_dt

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Data
Table
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"Big
Class"
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> )

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'"><<
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
Subset(




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">      Copy
formula(
style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">0
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">      Sample
Size(
style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">10
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">      columns(

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">:
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">name
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">:
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">age
)




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

 




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//result
data table is a difference between "big" table and its subset
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">result_dt

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
jmp_SQL_MINUS( dt
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
sub_dt
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"Difference
between dt and sub_dt"
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

 




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

 




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">/////////////////////////////////////////////////////////////////////////////////
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//Second
example
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

 




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//Open big
data table
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">dt

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Open
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"$SAMPLE_DATA/Equity.jmp"
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

 




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//Create
data table with items that needs to be excluded
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">sub_dt

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">New
Table
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"Exclude
Items"
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">      Add
Rows(
style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">2
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">     
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">New
Column
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"REASON"
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
Character
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
Nominal
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> Set
Values( {
style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"HomeImp"
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"DebtCon"
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">}
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> )
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">     
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">New
Column
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"JOB"
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
Character
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
Nominal
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> Set
Values( {
style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"Other"
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"Mgr"
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">}
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> )
)




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

 




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//result
data table has only filtered items
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">result_dt

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
jmp_SQL_MINUS( dt
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
sub_dt
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"Filtered"
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="MARGIN-BOTTOM: 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none">
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

 




style="MARGIN-BOTTOM: 0pt">

 

0 Kudos

Re: List Minus or Subtraction

Sep 8, 2010 04:02 PM (3714 views)  |  Posted in reply to message from pmroz 09-07-2010
This isn't exactly the same problem, but it also would be worth taking a look at the thread below, which describes the usage of associative arrays to do something similar: http://support.sas.com/forums/thread.jspa?messageID=34183薇
0 Kudos
aim
aim
Level II

Re: List Minus or Subtraction

Sep 9, 2010 07:08 PM (3714 views)  |  Posted in reply to message from 09-08-2010
The associative arrays can be quite useful, but not when your data have duplicate values that need to be preserved:


Say, there are two lists:


list1 = {"a", "b", "c", "d", "e", "f", "g", "a", "b", "c"};

list2 = {"d", "e", "f", "g", "ss"};



Subtracting list2 from list1 using a direct method results in list: {"a", "b", "c", "a", "b", "c"}, while doing this using associative array method results in list: {"a", "b", "c"}. So, which method to use depends on the nature of data in lists.


If you deal with large 1D lists with duplicates, here is the faster version of the list subtraction routine:





style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">List_Minus

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Function
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> (
{list1
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
list2}
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">      {Default
Local}
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">     
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">While
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">N
Items
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> list2
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">>
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">0
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 2">           

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Remove
From
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
list1
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">As
List
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Loc
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
list1
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
list2[
style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">1
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">]
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> )
) )
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 2">           

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Remove
From
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
list2
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">As
List
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Loc
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
list2
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
list2[
style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">1
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">]
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> )
) )
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">     
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">      list1
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">







To compare how much faster, here is the test routine, and its results:






style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

 




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">List_Minus

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Function
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> (
{list1
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
list2}
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">      {Default
Local}
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">     
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">While
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">N
Items
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> list2
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">>
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">0
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 2">           

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Remove
From
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
list1
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">As
List
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Loc
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
list1
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
list2[
style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">1
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">]
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> )
) )
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 2">           

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Remove
From
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
list2
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">As
List
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Loc
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
list2
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
list2[
style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">1
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">]
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> )
) )
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">     
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">     
list1
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

 




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

 




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">slow_List_Minus

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Function
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
{list1
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
list2}
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">      {Default
Local}
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">      newlist

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
{}
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">     
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">For
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> i

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">1
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> i

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'"><=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">N
Items
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> list1
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
i
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">++,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 2">           

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">If
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">!
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Contains
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
list2
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
list1[i] )
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-spacerun: yes"> 




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 3">                 

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Insert
Into
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
newlist
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
list1[i] )




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 2">           
)




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">     
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">      newlist




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

 




style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">/////////////////////////////////////////////////////////////////
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">/////////////////////////////////////////////////////////////////
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">vv

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">As
List
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">J
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">100000
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">1
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Random
Integer
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">100
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">)))
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">vsm

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">As
List
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">J
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">1000
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">1
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Random
Integer
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">90
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">100
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">)))
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

 




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">t1

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Tick
Seconds
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">()
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">      newlist

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
List_Minus(vv
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">vsm)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">t2

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Tick
Seconds
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">()
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Show
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"List_Minus
time:"
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Round
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> t2

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">-
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
t1
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">3
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
))
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">     




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">t1

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Tick
Seconds
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">()
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">      newlist

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
slow_List_Minus(vv
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">vsm)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">t2

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Tick
Seconds
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">()
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Show
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"slow_List_Minus
time:"
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Round
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> t2

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">-
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
t1
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">3
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
))
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">






Here is the script output (on modestly fast PC):



style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">"List_Minus
time:"
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">Round(::t2 -
::t1, 3):0.217
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">"slow_List_Minus
time:"
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">




style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">Round(::t2 -
::t1, 3):229.75
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">






Using associative array would be fast, but would result in a list 89 items long (numbers from 1 to 89).
0 Kudos