topic SAS BASE in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/SAS-BASE/m-p/169429#M43810 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>How do I Calculate&nbsp;&nbsp; Product on each level? </P><P></P><P></P><P>Data like this</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; t&nbsp;&nbsp; d&nbsp;&nbsp; y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Prod (1-d/y)&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp; 3&nbsp;&nbsp; 21&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (1-3/21)</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp; 1&nbsp;&nbsp; 17&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333330154419px;">(1-3/21)(1-1/17)&nbsp;&nbsp;&nbsp; and so on...</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; 10 1&nbsp;&nbsp; 15</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 13 1&nbsp;&nbsp; 12</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 16 1&nbsp;&nbsp; 11</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 22 1&nbsp;&nbsp;&nbsp; 7</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 23 1&nbsp;&nbsp;&nbsp; 6</P><P><SPAN style="font-size: 18pt;">&nbsp;&nbsp;&nbsp;&nbsp; ....</SPAN></P></BODY></HTML> Sun, 15 Feb 2015 07:36:10 GMT rimal6_netscape_net 2015-02-15T07:36:10Z SAS BASE https://communities.sas.com/t5/SAS-Procedures/SAS-BASE/m-p/169429#M43810 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>How do I Calculate&nbsp;&nbsp; Product on each level? </P><P></P><P></P><P>Data like this</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; t&nbsp;&nbsp; d&nbsp;&nbsp; y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Prod (1-d/y)&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp; 3&nbsp;&nbsp; 21&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (1-3/21)</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp; 1&nbsp;&nbsp; 17&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333330154419px;">(1-3/21)(1-1/17)&nbsp;&nbsp;&nbsp; and so on...</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; 10 1&nbsp;&nbsp; 15</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 13 1&nbsp;&nbsp; 12</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 16 1&nbsp;&nbsp; 11</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 22 1&nbsp;&nbsp;&nbsp; 7</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 23 1&nbsp;&nbsp;&nbsp; 6</P><P><SPAN style="font-size: 18pt;">&nbsp;&nbsp;&nbsp;&nbsp; ....</SPAN></P></BODY></HTML> Sun, 15 Feb 2015 07:36:10 GMT https://communities.sas.com/t5/SAS-Procedures/SAS-BASE/m-p/169429#M43810 rimal6_netscape_net 2015-02-15T07:36:10Z Re: SAS BASE https://communities.sas.com/t5/SAS-Procedures/SAS-BASE/m-p/169430#M43811 <HTML><HEAD></HEAD><BODY><P>Is this what you want?</P><P></P><P style="margin-bottom: .0001pt;"><SPAN style="color: navy; background: white; font-size: 10.0pt; font-family: 'Courier New';"><STRONG>data</STRONG></SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black; background: white;"> want ;</SPAN></P><P style="margin-bottom: .0001pt;">&nbsp; <SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: blue; background: white;">input</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black; background: white;"> t d y ;</SPAN></P><P style="margin-bottom: .0001pt;">&nbsp; <SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: blue; background: white;">retain</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black; background: white;"> prod </SPAN><SPAN style="color: teal; background: white; font-size: 10.0pt; font-family: 'Courier New';"><STRONG>1</STRONG></SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black; background: white;"> ;</SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black; background: white;">&nbsp; prod = prod*(</SPAN><SPAN style="color: teal; background: white; font-size: 10.0pt; font-family: 'Courier New';"><STRONG>1</STRONG></SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black; background: white;">-d/y);</SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: blue; background: white;">cards</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black; background: white;">;</SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black; background: #FFFFC0;">&nbsp;&nbsp;&nbsp;&nbsp; 6 3&nbsp;&nbsp; 21&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (1-3/21)</SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black; background: #FFFFC0;">&nbsp;&nbsp;&nbsp;&nbsp; 7 1&nbsp;&nbsp; 17&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (1-3/21)(1-1/17)&nbsp;&nbsp;&nbsp; and so on...</SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black; background: #FFFFC0;">&nbsp;&nbsp;&nbsp;&nbsp; 10 1 15</SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black; background: #FFFFC0;">&nbsp;&nbsp;&nbsp;&nbsp; 13 1 12</SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black; background: #FFFFC0;">&nbsp;&nbsp;&nbsp;&nbsp; 16 1 11</SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black; background: #FFFFC0;">&nbsp;&nbsp;&nbsp;&nbsp; 22 1 7</SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black; background: #FFFFC0;">&nbsp;&nbsp;&nbsp;&nbsp; 23 1 6</SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black; background: white;">;;;;</SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="color: navy; background: white; font-size: 10.0pt; font-family: 'Courier New';"><STRONG>data</STRONG></SPAN> <SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: blue; background: white;">_null_</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black; background: white;">;</SPAN></P><P style="margin-bottom: .0001pt;">&nbsp; <SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: blue; background: white;">set</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black; background: white;"> ;</SPAN></P><P style="margin-bottom: .0001pt;">&nbsp; <SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: blue; background: white;">put</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black; background: white;"> (</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: blue; background: white;">_all_</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black; background: white;">) (:);</SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="color: navy; background: white; font-size: 10.0pt; font-family: 'Courier New';"><STRONG>run</STRONG></SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black; background: white;">;</SPAN></P><P></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Courier New';"> 6 3 21 0.8571428571</SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Courier New';"> 7 1 17 0.8067226891</SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Courier New';">10 1 15 0.7529411765</SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Courier New';">13 1 12 0.6901960784</SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Courier New';">16 1 11 0.6274509804</SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Courier New';">22 1&nbsp; 7 0.5378151261</SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Courier New';">23 1&nbsp; 6 0.4481792717</SPAN></P></BODY></HTML> Sun, 15 Feb 2015 15:38:47 GMT https://communities.sas.com/t5/SAS-Procedures/SAS-BASE/m-p/169430#M43811 Tom 2015-02-15T15:38:47Z Re: SAS BASE https://communities.sas.com/t5/SAS-Procedures/SAS-BASE/m-p/169431#M43812 <HTML><HEAD></HEAD><BODY><P>Thank you,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Exactly what I wanted.</P><P></P><P></P><P>Regards</P><P>Mahesh</P></BODY></HTML> Sun, 15 Feb 2015 23:44:33 GMT https://communities.sas.com/t5/SAS-Procedures/SAS-BASE/m-p/169431#M43812 rimal6_netscape_net 2015-02-15T23:44:33Z