Hi Udo, Sorry for delays, went to hollidays. Thanks for this input - I was not aware of the various possible definitions of SMAPE. Something strange is that I do effectively have some TS with a value of 200 (upper bound of "my" definition). I don't find on google something on MASPE so I guess this is indeed old or erroneous info for a certain definition of SMAPE Anyway, I may go to another statistic -- come back to more classic MAPE I guess... Thanks again, Eric ... View more

Udo, Thanks also fot his answer. I did indeed have a look at FSLOAD macro + available macro-variables for SP within SAS/FS Studio. I was hopping something already packaged did exist. Nevertheless, I do have all elements to build my solution (except that in our environment, calling FSLOAD fails due to access right -- cause: use of Citrix). Eric ... View more

Thanks for all your input; I will try the different versions to test performance. In particular I was thinking (hoping)  hashkey could be more performant. With regards to the high number of records, I fear a big SQL may not be the most performant but there again I have to test. Eric ... View more

removed. Message was edited by: udo@sas ... View more