so i have a series workfile and i want to create 2 workfiles from the one i have
i want to separate positive and negative oil change.
I tried using dlaprice= dlprice>0
but it only shows 1 and 0 value when I need the real value.
I read a paper that the writer using this syintax but it wont work
price= oil price
lprice= log(price)
dlprice= dlog(price)
dlaprice= max(0,dlog(price))
dlapricem= min(0dlog(price))
the dlaprice should contain the positive oil price changes and dlapricem should contain negative oil price changes. I tried but it wont work.
thank you