11-02-2015 03:21 PM
I am using X=PCTL(I,variable1, variable2, variable3....) function to calculate percentiles, but I want to calculate percnetiles among 600 variables.
is there anyway that i can simpelize the expression instead of listing every variable in the bracket?? That would be crazy!
11-02-2015 03:38 PM
11-02-2015 03:39 PM
Thank you for you response.
The variables' name look like this: load_2004,load_2005,load_2006,load_2007,load_2008,
I can probably do transpose process, but i am not familiar with that and it will easily mess up my data set. I am still wondering if this can be solved with PCTL function.
11-02-2015 03:51 PM
11-02-2015 04:09 PM
Thank you for your link. It is helpful.
After I tried several list methods, It turnes out the function can be written as x=PCTL(i, of variable and it worked.
The reason I dont prefer transpose process is because I am personally not familiar with it, and the data I am manipulating is very complicated alrealy for me, so in order to keep my logic clear for myself, I prefer this PCTL function.
Thank you for your help again!