Page 1 of 1

Transpose Series

Posted: Fri Jan 13, 2023 10:30 am
by CNR15
I am looking g to flip a number of series so the first observation (1990) is the last observation (2021) and vice versa. Any ideas on how to do this?

Thanks!

Re: Transpose Series

Posted: Fri Jan 13, 2023 12:47 pm
by EViews Gareth
Probably easier ways, but this works:

Code: Select all

close @wf wfcreate a 2010 2020 series y = @nrnd series t = @obsrange - @trend vector v = @capplyranks(@convert(y),@convert(t)) mtos(v, yrev) show y yrev

Re: Transpose Series

Posted: Mon Jan 16, 2023 2:54 am
by CNR15
Cheers Gareth -appreciate that.