So, I have a dataset that contains customer's birthday, birth month and their age. I'm trying to find the birthday of each customer, which includes their birth year. Any suggestions?  ... View more

Thanks for the suggestion. But my SAS Enterprise Guide that I use for my class does not have the LAG function (I believe because it's an older version), and hence I cannot execute what you suggested. Though it seems solid, do you have any other way to tackle this problem? Thanks! ... View more

Ok, below is a copy/paste of my imported dataset and I'm trying to calculate the difference between the numbers in bold – as you can see, they're located in different rows. How would I tackle this?:    01JAN2015 94.910004 90.959999 . 01FEB2015 91.300003 104.080002 0.1442391792 01MAR2015 104.349998 104.889999 0.0077825283 01APR2015 105.43 108.720001 0.0365143577 01MAY2015 109.949997 110.370003 0.0151766496 01JUN2015 111.480003 114.139999 0.0341578766 01JUL2015 114.949997 120 0.0513404055 01AUG2015 120.879997 101.879997 -0.1460622 01SEP2015 99.309998 102.199997 0.0031409724 01OCT2015 102.970001 113.739998 0.1129158983 01NOV2015 114.489998 113.470001 -0.002373749 01DEC2015 114.150002 105.080002 -0.073940405 ... View more