topic Re: Rolling over difference from different futures contracts in SAS Programming https://communities.sas.com/t5/SAS-Programming/Rolling-over-difference-from-different-futures-contracts/m-p/187679#M35515 <HTML><HEAD></HEAD><BODY><P>The best way to get the help you want would be to post a sample of your input data, then what you would like your output data to look like, plus what you have coded so far.</P><P></P><P>It sounds like you have an issue with even getting all of your input data together in the first place. If this is the case then this needs to be solved first.</P></BODY></HTML> Tue, 03 Mar 2015 07:43:57 GMT SASKiwi 2015-03-03T07:43:57Z Rolling over difference from different futures contracts https://communities.sas.com/t5/SAS-Programming/Rolling-over-difference-from-different-futures-contracts/m-p/187678#M35514 <HTML><HEAD></HEAD><BODY><P>Hi, I want to calculate the roll over difference of different futures contracts. I have daily data of five contracts and i want to calculate the daily change of each contract with roll over date of 5th of the contract's delivery month.</P><P>That is suppose i have may and july futures data. i will calculate change till 5th of may using may futures but next change will be from 5th may of may futures and 6th may of july futures.</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">i am trying to make a macro for this but am not able to do that. the data is in excel format of different maturity months that is may maturity from 1970 t0 may maturity till 2014 and july maturity from 1970 to july maturity till 2014 and same for september, december and march and all aare in different excel files. </SPAN></P></BODY></HTML> Mon, 02 Mar 2015 02:58:31 GMT https://communities.sas.com/t5/SAS-Programming/Rolling-over-difference-from-different-futures-contracts/m-p/187678#M35514 jasdeepSingh 2015-03-02T02:58:31Z Re: Rolling over difference from different futures contracts https://communities.sas.com/t5/SAS-Programming/Rolling-over-difference-from-different-futures-contracts/m-p/187679#M35515 <HTML><HEAD></HEAD><BODY><P>The best way to get the help you want would be to post a sample of your input data, then what you would like your output data to look like, plus what you have coded so far.</P><P></P><P>It sounds like you have an issue with even getting all of your input data together in the first place. If this is the case then this needs to be solved first.</P></BODY></HTML> Tue, 03 Mar 2015 07:43:57 GMT https://communities.sas.com/t5/SAS-Programming/Rolling-over-difference-from-different-futures-contracts/m-p/187679#M35515 SASKiwi 2015-03-03T07:43:57Z