BookmarkSubscribeRSS Feed
jasdeepSingh
Calcite | Level 5

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.

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.

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.

1 REPLY 1
SASKiwi
PROC Star

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.

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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 705 views
  • 0 likes
  • 2 in conversation