How to group columns into deciles?

Hy guys,

I have this table composed by strings:

DateTime 1 2 3 4 5

___________ ______ ______ ______ ______ ______

01-Jan-1990 "Var5" "Var3" "Var1" "Var2" "Var4"

02-Jan-1990 "Var3" "Var5" "Var1" "Var2" "Var4"

03-Jan-1990 "Var5" "Var3" "Var1" "Var2" "Var4"

04-Jan-1990 "Var3" "Var5" "Var1" "Var2" "Var4"

05-Jan-1990 "Var5" "Var3" "Var1" "Var2" "Var4"

My question is:

How do I unpack the columns (already sorted) and take for instance 10%, 20% or 40% of the columns??

Like this (40%):

DateTime 1 2

___________ ______ ______

01-Jan-1990 "Var5" "Var3"

02-Jan-1990 "Var3" "Var5"

03-Jan-1990 "Var5" "Var3"

04-Jan-1990 "Var3" "Var5"

05-Jan-1990 "Var5" "Var3"

Which function to use?

Thanks a lot.

Answer 1

[Cris LaPierre]

Perhaps this page on accessing data in a table will help you?