Using teh dataset below, is there a straightforward way of calculating:   (1) the largest price increase in any consecutive 30/360/720 day period. So the algorithm would need to check the price change of from every day to every other day within 30/360/720 days and output a maximum    (2) the largest price increase in a particular month   (3) the largest price increase in a particular year   (4) the correlation of price movements between January 2015 and January 2016 i.e. are price movements in Jan 2015 correlated with price movements in Jan 2016?       data have; attrib date length=4 format=date9.; do date = '1jan2015'd to '31dec2016'd; price = int(ranuni(225465114) * 30) + 95; output; end; run;       ... View more

Hi   I have a text file (example attached) in the form:   {"market_cap_by_available_supply": [[1367174841000, 1500517590], [1367261101000, 1575032004], ............   "volume_usd": [[1367174841000, 0.0], [1367261101000, 0.0], ........   So there is market cap information given where the first number in the square brackets is the time and the second is the market supply. Then halfway through the txt file the market volume is given in a similar format (he first number in the square brackets is the time and the second is the market volume). If you look at it in excel it just takes up one row. I want to inport into SAS and organise it like    Time Market Cap Volume 1370122802000 1500517590 2450066 1370215501000 1500530000 2354556   ....                             .....                 .....   Thank you      ... View more