topic Re: Calculation Query/Opposite to Lag? in SAS Studio https://communities.sas.com/t5/SAS-Studio/Calculation-Query-Opposite-to-Lag/m-p/279633#M702 <PRE><CODE class=" language-sas">data have; infile cards expandtabs; input DATE : date11. MONTH F1 F2; format DATE date11.; cards; 01-Oct-15 1 10.24015 . 48.18418905 01-Oct-15 2 2.020544 20.69068 4.705416607 01-Oct-15 3 1.242758 2.511047 2.328786667 01-Oct-15 4 1.255826 1.560687 1.873886563 01-Oct-15 5 0.937424 1.177242 1.492154466 01-Oct-15 6 1.211713 1.135889 1.591760354 01-Oct-15 7 1.313645 1.59176 1.31364454 01-Oct-15 8 1 1 1 01-Nov-15 1 10.24015 10.24015 36.67977719 01-Nov-15 2 2.020544 20.69068 3.581955744 01-Nov-15 3 1.242758 2.511047 1.772767743 01-Nov-15 4 1.255826 1.560687 1.426479162 01-Nov-15 5 0.937424 1.177242 1.135889063 01-Nov-15 6 1.211713 1.135889 1.211713143 01-Nov-15 7 1 1 ; run; proc sort data=have(where=(month le 8)) out=temp; by date descending month; run; data want; set temp; by date; retain xxxx; if first.date then xxxx=1; xxxx=xxxx*F1; run; proc sort data=want;by date month;run;</CODE></PRE> Thu, 23 Jun 2016 03:31:45 GMT Ksharp 2016-06-23T03:31:45Z Calculation Query/Opposite to Lag? https://communities.sas.com/t5/SAS-Studio/Calculation-Query-Opposite-to-Lag/m-p/279279#M698 <P>Hi there</P><P>&nbsp;</P><P>I have the below dataset as my input.</P><P>&nbsp;</P><P>What I am trying to do is calcualte column ?????</P><P>The calculation needs to start at month 8 for Oct 2015 for instance.</P><P>This will always be 1.</P><P><SPAN>1.31364454 is the result of the 1 under column ????? multiplied by month 7&nbsp;1.313645</SPAN></P><P><SPAN>1.591760354 is the result of the&nbsp;1.31364454 under ????? muliplied by month 6&nbsp;1.211713</SPAN></P><P>&nbsp;</P><P><SPAN>Is there any code that will allow me to achieve this?</SPAN></P><P><SPAN>I have tried using the retain fucntion but I am going down the wrong route possibly here.</SPAN></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>DATE</TD><TD>MONTH</TD><TD>F1</TD><TD>F2</TD><TD>?????</TD></TR><TR><TD>01-Oct-15</TD><TD>1</TD><TD>10.24015</TD><TD>.</TD><TD>48.18418905</TD></TR><TR><TD>01-Oct-15</TD><TD>2</TD><TD>2.020544</TD><TD>20.69068</TD><TD>4.705416607</TD></TR><TR><TD>01-Oct-15</TD><TD>3</TD><TD>1.242758</TD><TD>2.511047</TD><TD>2.328786667</TD></TR><TR><TD>01-Oct-15</TD><TD>4</TD><TD>1.255826</TD><TD>1.560687</TD><TD>1.873886563</TD></TR><TR><TD>01-Oct-15</TD><TD>5</TD><TD>0.937424</TD><TD>1.177242</TD><TD>1.492154466</TD></TR><TR><TD>01-Oct-15</TD><TD>6</TD><TD>1.211713</TD><TD>1.135889</TD><TD>1.591760354</TD></TR><TR><TD>01-Oct-15</TD><TD>7</TD><TD>1.313645</TD><TD>1.59176</TD><TD>1.31364454</TD></TR><TR><TD>01-Oct-15</TD><TD>8</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>01-Nov-15</TD><TD>1</TD><TD>10.24015</TD><TD>10.24015</TD><TD>36.67977719</TD></TR><TR><TD>01-Nov-15</TD><TD>2</TD><TD>2.020544</TD><TD>20.69068</TD><TD>3.581955744</TD></TR><TR><TD>01-Nov-15</TD><TD>3</TD><TD>1.242758</TD><TD>2.511047</TD><TD>1.772767743</TD></TR><TR><TD>01-Nov-15</TD><TD>4</TD><TD>1.255826</TD><TD>1.560687</TD><TD>1.426479162</TD></TR><TR><TD>01-Nov-15</TD><TD>5</TD><TD>0.937424</TD><TD>1.177242</TD><TD>1.135889063</TD></TR><TR><TD>01-Nov-15</TD><TD>6</TD><TD>1.211713</TD><TD>1.135889</TD><TD>1.211713143</TD></TR><TR><TD>01-Nov-15</TD><TD>7</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR></TBODY></TABLE> Wed, 22 Jun 2016 12:34:49 GMT https://communities.sas.com/t5/SAS-Studio/Calculation-Query-Opposite-to-Lag/m-p/279279#M698 Aidan 2016-06-22T12:34:49Z Re: Calculation Query/Opposite to Lag? https://communities.sas.com/t5/SAS-Studio/Calculation-Query-Opposite-to-Lag/m-p/279633#M702 <PRE><CODE class=" language-sas">data have; infile cards expandtabs; input DATE : date11. MONTH F1 F2; format DATE date11.; cards; 01-Oct-15 1 10.24015 . 48.18418905 01-Oct-15 2 2.020544 20.69068 4.705416607 01-Oct-15 3 1.242758 2.511047 2.328786667 01-Oct-15 4 1.255826 1.560687 1.873886563 01-Oct-15 5 0.937424 1.177242 1.492154466 01-Oct-15 6 1.211713 1.135889 1.591760354 01-Oct-15 7 1.313645 1.59176 1.31364454 01-Oct-15 8 1 1 1 01-Nov-15 1 10.24015 10.24015 36.67977719 01-Nov-15 2 2.020544 20.69068 3.581955744 01-Nov-15 3 1.242758 2.511047 1.772767743 01-Nov-15 4 1.255826 1.560687 1.426479162 01-Nov-15 5 0.937424 1.177242 1.135889063 01-Nov-15 6 1.211713 1.135889 1.211713143 01-Nov-15 7 1 1 ; run; proc sort data=have(where=(month le 8)) out=temp; by date descending month; run; data want; set temp; by date; retain xxxx; if first.date then xxxx=1; xxxx=xxxx*F1; run; proc sort data=want;by date month;run;</CODE></PRE> Thu, 23 Jun 2016 03:31:45 GMT https://communities.sas.com/t5/SAS-Studio/Calculation-Query-Opposite-to-Lag/m-p/279633#M702 Ksharp 2016-06-23T03:31:45Z Re: Calculation Query/Opposite to Lag? https://communities.sas.com/t5/SAS-Studio/Calculation-Query-Opposite-to-Lag/m-p/279677#M703 <P>Thanks for your help this worked <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Thu, 23 Jun 2016 07:11:12 GMT https://communities.sas.com/t5/SAS-Studio/Calculation-Query-Opposite-to-Lag/m-p/279677#M703 Aidan 2016-06-23T07:11:12Z