Hi everyone,
I'm very, very new to SQLite, and would appreciate any help I can get.
I have 3 long vectors that look like this:
{"ALB","CAN", "DZA",...}
{"ALB","CAN", "DZA",...}
{"1961","1962", "1963",...}
And I want to create a table that looks like this:
ID Var1 Var2 Var3
1 ALB CAN 1961
1 ALB CAN 1962
1 ALB CAN 1963
2 ALB DZA 1961
2 ALB DZA 1962
2 ALB DZA 1963
3 CAN ALB 1961
3 CAN ALB 1962
3 CAN ALB 1963
4 CAN DZA 1961
4 CAN DZA 1962
4 CAN DZA 1963
5 DZA ALB 1961
5 DZA ALB 1962
5 DZA ALB 1963
6 DZA CAN 1961
6 DZA CAN 1962
6 DZA CAN 1963
In short, I need to include every possible pair of Var1/Var2 values (where
Var1/Var2 != Var2/Var1. I want to keep permutations.). For each of these
pairs, I need to create separate rows for each different value of Var3. I
also need to drop rows where Var1 == Var2. Finally, I would like to generate
a unique ID number for each Var1/Var2 pair.
Of course, I do not expect a ready-made answer. However, if some of you
could tell me where I should start looking for a solution to my problem, or
if you have any conceptual programming hints that could help me produce the
needed table, I would be extremely grateful.
Thank you very much for your time. I really appreciate.
Vincent Arel
McGill University
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
