Copy a subsample of a series
Posted: Fri Nov 09, 2012 12:07 pm
Hi,
I want to copy a series without the most extreme values between two sheets (from sheet1 to sheet2) with same length and frequency. Example:
but I would rather do something without creating the "tmp"-variable, like
Unfortunately this doesn't work. I get error-message that "eur" already exist.
Thanks,
Dagfinn
I want to copy a series without the most extreme values between two sheets (from sheet1 to sheet2) with same length and frequency. Example:
Code: Select all
smpl @all if @abs(eur)<@quantile(@abs(eur),0.99)
series tmp = eur
copy tmp sheet2\eur
Code: Select all
copy(smpl="@all if @abs(eur)<@quantile(@abs(eur),0.99)") eur sheet2\
Thanks,
Dagfinn