nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

2364_fr-FR

liliconcom

Liste Moins ou Soustraction

Bonjour à tous,

Existe-t-il un moyen dans JMP de soustraire une liste d'une autre, un peu comme un SQL MOINS ? Par exemple, je veux faire ce qui suit :

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

liste restreinte = {"a", "b", "c"} ;

nouvelle liste = grande liste MOINS liste restreinte ;

La nouvelle liste serait {"d", "e", "f", "g"} ;

Merci,
Pierre

Ré: Liste moins ou soustraction

Les tableaux associatifs peuvent être très utiles, mais pas lorsque vos données ont des valeurs en double qui doivent être conservées :

Disons qu’il y a deux listes :

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

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

La soustraction de liste2 de liste1 à l'aide d'une méthode directe donne list: {"a", "b", "c", "a", "b", "c"}, alors que la soustraction de liste1 à l'aide d'une méthode de tableau associatif donne list: {"a", "b", "c"}. La méthode à utiliser dépend donc de la nature des données dans les listes.

Si vous traitez de grandes listes 1D avec des doublons, voici la version plus rapide de la routine de soustraction de liste :

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

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Fonction
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'"> (
{liste1
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">
liste2}
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1"> {Défaut
Locale}
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Alors que
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">N
Articles
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> liste2
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">>
style="FONT-SIZE: 10pt; COLOR: noir; 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: noir; FONT-FAMILY: 'Courier New'">

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

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Supprimer
Depuis
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">
liste1
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Comme
List
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: noir; 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: noir; FONT-FAMILY: 'Courier New'">
liste1
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">
liste2[
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: noir; FONT-FAMILY: 'Courier New'"> )
) )
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">

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

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Supprimer
Depuis
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">
liste2
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Comme
List
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: noir; 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: noir; FONT-FAMILY: 'Courier New'">
liste2
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: noir; 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: noir; FONT-FAMILY: 'Courier New'"> )
) )
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">

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

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

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

Pour comparer à quel point c'est plus rapide, voici la routine de test et ses résultats :

style="FONT-SIZE: 10pt; COLOR: noir; 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: noir; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Fonction
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'"> (
{liste1
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">
liste2}
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1"> {Défaut
Localee}
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">

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

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">N
Articles
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> liste2
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">>
style="FONT-SIZE: 10pt; COLOR: noir; 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: noir; FONT-FAMILY: 'Courier New'">

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

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Supprimer
Depuis
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">
liste1
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Comme
Listeeee
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: noir; 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: noir; FONT-FAMILY: 'Courier New'">
liste1
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">
liste2[
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: noir; FONT-FAMILY: 'Courier New'"> )
) )
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">

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

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Supprimer
Depuis
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">
liste2
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Comme
List
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: noir; 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: noir; FONT-FAMILY: 'Courier New'">
liste2
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">
liste2[
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: noir; FONT-FAMILY: 'Courier New'"> )
) )
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">;
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: noir; 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: noir; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: noir; 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: noir; FONT-FAMILY: 'Courier New'">

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

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

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

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

style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">
style="mso-tab-count: 1">
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Pour
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: noir; 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: noir; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">N
Articles
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> liste1
)
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">
je
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">++,
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">

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

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

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">!
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Contient
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">
liste2
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">
liste1[i] )
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">
style="mso-spacerun: oui">

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

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Insérer
Dans
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">
nouvelle liste
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">
liste1[i] )

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

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

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

style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">/////////////////////////////////////////////////////////////////
style="FONT-SIZE: 10pt; COLOR: noir; 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: noir; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Comme
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'">Aléatoire
Entier
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: noir; 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: noir; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Comme
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'">Aléatoire
Entier
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: noir; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: noir; 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: noir; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Cochez
Secondes
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: noir; FONT-FAMILY: 'Courier New'">

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

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">
Liste_moins(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: noir; 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: noir; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Cochez
Secondes
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: noir; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Afficher
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"List_Minus
temps:"
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Rond
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: noir; FONT-FAMILY: 'Courier New'">
t1
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">

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

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

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

style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">=
style="FONT-SIZE: 10pt; COLOR: noir; 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: noir; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Afficher
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">(
style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"slow_List_Minus
temps:"
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Rond
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: noir; FONT-FAMILY: 'Courier New'">
t1
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">,
style="FONT-SIZE: 10pt; COLOR: noir; FONT-FAMILY: 'Courier New'">

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

Voici la sortie du script (sur un PC relativement rapide) :

style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">"List_Minus
temps:"
style="FONT-SIZE: 10pt; COLOR: noir; 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: noir; FONT-FAMILY: 'Courier New'">

style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">"slow_List_Minus
temps:"
style="FONT-SIZE: 10pt; COLOR: noir; 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: noir; FONT-FAMILY: 'Courier New'">

L'utilisation d'un tableau associatif serait rapide, mais donnerait lieu à une liste de 89 éléments (nombres de 1 à 89).

Re: Liste Moins ou Soustraction

Ce n'est pas exactement le même problème, mais il serait également utile de consulter la discussion ci-dessous, qui décrit l'utilisation des tableaux associatifs pour réaliser une opération similaire : http://support.sas.com/forums/thread.jspa?messageID=34183薇

Comments

There are no comments yet