topic Re: Monthly return in SAS Programming https://communities.sas.com/t5/SAS-Programming/Monthly-return/m-p/567773#M159704 <P>Since you don't show a variable or anything labeled as "Rt" you need to describe in terms of you data what exactly is meant by "(Rt/Rt-1) -1&nbsp;".</P> <P>&nbsp;</P> <P>You probably need to reshape your data so that you have something that looks more like:</P> <P>Name Code Date Value</P> <P>&nbsp;</P> <P>Do you have a SAS data set? That looks very improbable for the sort of calculation I think you intend as all of those values under the names are going to be character.</P> <P>&nbsp;</P> <P>Instructions here: <A href="https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712" target="_blank">https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712</A> will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.</P> <P>&nbsp;</P> Thu, 20 Jun 2019 20:49:36 GMT ballardw 2019-06-20T20:49:36Z Monthly return https://communities.sas.com/t5/SAS-Programming/Monthly-return/m-p/567769#M159702 <P>Hi all,&nbsp;</P><P>&nbsp;</P><P>I have a dataset that are similar to the following. It's the monthly stock prices of about 200 companies. Now I want to generate the monthly return of each stock, which I defined as : (Rt/Rt-1) -1 . How should write the code to do this?&nbsp;</P><P>&nbsp;</P><P>Thank you very much.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Name</TD><TD>DANANG RUBBER</TD><TD>SAIGON THUONG TIN COMMERCIAL</TD><TD>ASIA COMMERCIAL</TD><TD>CHUONG DUONG BEVERAGES</TD><TD>THANG LONG WINE</TD><TD>PETROVIETNAM FCM.</TD><TD>DONG PHU RUBBER</TD><TD>HOA BINH RUBBER</TD><TD>GENERAL MATERIAL</TD><TD>THONG NHAT RUBBER</TD></TR><TR><TD>Code</TD><TD>VT:DRC(P)</TD><TD>VT:STB(P)</TD><TD>VT:ACB(P)</TD><TD>VT:SCD(P)</TD><TD>VT:VTL(P)</TD><TD>VT:DPM(P)</TD><TD>VT:DPR(P)</TD><TD>VT:HRC(P)</TD><TD>VT:HSI(P)</TD><TD>VT:TNC(P)</TD></TR><TR><TD>1/1/08</TD><TD>13498.75</TD><TD>30110.97</TD><TD>49638.72</TD><TD>40000</TD><TD>21994.38</TD><TD>74000</TD><TD>85000</TD><TD>96000.5</TD><TD>41000</TD><TD>36500</TD></TR><TR><TD>2/1/08</TD><TD>13169.51</TD><TD>29651.26</TD><TD>41527.03</TD><TD>33600</TD><TD>22494.25</TD><TD>68500</TD><TD>82000</TD><TD>84571.88</TD><TD>34600</TD><TD>31500</TD></TR><TR><TD>3/1/08</TD><TD>8505.31</TD><TD>22525.75</TD><TD>30872.86</TD><TD>23800</TD><TD>20344.8</TD><TD>53500</TD><TD>58000</TD><TD>54000.31</TD><TD>25800</TD><TD>24200</TD></TR><TR><TD>4/1/08</TD><TD>6200.65</TD><TD>17193.13</TD><TD>28481.73</TD><TD>17900</TD><TD>12896.7</TD><TD>49000</TD><TD>49400</TD><TD>39143.07</TD><TD>21300</TD><TD>19300</TD></TR><TR><TD>5/1/08</TD><TD>5816.54</TD><TD>15400.27</TD><TD>25091.76</TD><TD>19100</TD><TD>11846.97</TD><TD>53500</TD><TD>56000</TD><TD>35714.48</TD><TD>23800</TD><TD>19000</TD></TR><TR><TD>6/1/08</TD><TD>4356.91</TD><TD>11079</TD><TD>14316.54</TD><TD>17700</TD><TD>9997.44</TD><TD>40200</TD><TD>44500</TD><TD>26742.99</TD><TD>18600</TD><TD>14000</TD></TR><TR><TD>7/1/08</TD><TD>3709.41</TD><TD>10343.46</TD><TD>14861.35</TD><TD>22100</TD><TD>12146.89</TD><TD>44000</TD><TD>54000</TD><TD>25428.71</TD><TD>18500</TD><TD>13500</TD></TR><TR><TD>8/1/08</TD><TD>4402.99</TD><TD>10527.35</TD><TD>18523.71</TD><TD>18400</TD><TD>9897.47</TD><TD>58000</TD><TD>62000</TD><TD>27714.43</TD><TD>24100</TD><TD>14700</TD></TR><TR><TD>9/1/08</TD><TD>5788.64</TD><TD>14205.02</TD><TD>28935.74</TD><TD>25300</TD><TD>10547.3</TD><TD>65000</TD><TD>69500</TD><TD>36000.2</TD><TD>24200</TD><TD>17000</TD></TR><TR><TD>10/1/08</TD><TD>4532.49</TD><TD>11033.03</TD><TD>24254.92</TD><TD>19000</TD><TD>9747.51</TD><TD>58000</TD><TD>63000</TD><TD>28571.59</TD><TD>19000</TD><TD>14900</TD></TR><TR><TD>11/1/08</TD><TD>3030.3</TD><TD>10113.61</TD><TD>20314.09</TD><TD>18000</TD><TD>6998.21</TD><TD>45200</TD><TD>35300</TD><TD>14742.94</TD><TD>13500</TD><TD>11000</TD></TR><TR><TD>12/1/08</TD><TD>2331</TD><TD>9332.1</TD><TD>19610.37</TD><TD>16200</TD><TD>6498.34</TD><TD>36200</TD><TD>30400</TD><TD>18400.11</TD><TD>13500</TD><TD>9800</TD></TR><TR><TD>1/1/09</TD><TD>2175.6</TD><TD>8458.65</TD><TD>17884.61</TD><TD>16000</TD><TD>6998.21</TD><TD>34500</TD><TD>30400</TD><TD>13942.94</TD><TD>11700</TD><TD>8200</TD></TR><TR><TD>2/1/09</TD><TD>2201.5</TD><TD>7861.03</TD><TD>17820.51</TD><TD>15700</TD><TD>7298.13</TD><TD>33000</TD><TD>31000</TD><TD>13028.64</TD><TD>12200</TD><TD>7700</TD></TR><TR><TD>3/1/09</TD><TD>2292.15</TD><TD>6987.58</TD><TD>16025.65</TD><TD>12100</TD><TD>6648.3</TD><TD>28300</TD><TD>24000</TD><TD>11085.78</TD><TD>9700</TD><TD>6700</TD></TR><TR><TD>4/1/09</TD><TD>3082.1</TD><TD>7769.09</TD><TD>19230.77</TD><TD>12400</TD><TD>6748.27</TD><TD>33100</TD><TD>31900</TD><TD>14857.23</TD><TD>11800</TD><TD>9400</TD></TR><TR><TD>5/1/09</TD><TD>3613.04</TD><TD>9653.9</TD><TD>23717.96</TD><TD>13100</TD><TD>8247.89</TD><TD>36500</TD><TD>31800</TD><TD>14628.66</TD><TD>11300</TD><TD>10500</TD></TR><TR><TD>6/1/09</TD><TD>7834.73</TD><TD>12779.93</TD><TD>28461.55</TD><TD>15700</TD><TD>11946.95</TD><TD>44200</TD><TD>46700</TD><TD>21200.12</TD><TD>13300</TD><TD>15600</TD></TR><TR><TD>7/1/09</TD><TD>10036.23</TD><TD>15262.36</TD><TD>29871.81</TD><TD>15600</TD><TD>14596.27</TD><TD>40500</TD><TD>40500</TD><TD>19028.68</TD><TD>11900</TD><TD>13300</TD></TR><TR><TD>8/1/09</TD><TD>11007.48</TD><TD>16687.45</TD><TD>29871.81</TD><TD>16000</TD><TD>14896.19</TD><TD>47400</TD><TD>45800</TD><TD>20171.55</TD><TD>12200</TD><TD>14200</TD></TR><TR><TD>9/1/09</TD><TD>13338.47</TD><TD>18020.61</TD><TD>30576.94</TD><TD>19200</TD><TD>13746.48</TD><TD>49700</TD><TD>62000</TD><TD>25142.99</TD><TD>13200</TD><TD>16300</TD></TR><TR><TD>10/1/09</TD><TD>21885.47</TD><TD>18564.48</TD><TD>29358.98</TD><TD>20600</TD><TD>13996.42</TD><TD>47100</TD><TD>60000</TD><TD>25428.71</TD><TD>13000</TD><TD>16300</TD></TR><TR><TD>11/1/09</TD><TD>19813.47</TD><TD>16955.17</TD><TD>27564.11</TD><TD>29400</TD><TD>14996.16</TD><TD>42200</TD><TD>57000</TD><TD>24685.86</TD><TD>13300</TD><TD>16800</TD></TR><TR><TD>12/1/09</TD><TD>16316.98</TD><TD>15288.41</TD><TD>25287.41</TD><TD>24800</TD><TD>14946.18</TD><TD>38100</TD><TD>61000</TD><TD>23371.55</TD><TD>11700</TD><TD>15800</TD></TR><TR><TD>1/1/10</TD><TD>15798.97</TD><TD>13851.52</TD><TD>24182.3</TD><TD>26900</TD><TD>14646.25</TD><TD>34000</TD><TD>58000</TD><TD>21371.55</TD><TD>11300</TD><TD>14300</TD></TR></TBODY></TABLE><P>&nbsp;</P> Thu, 20 Jun 2019 20:41:00 GMT https://communities.sas.com/t5/SAS-Programming/Monthly-return/m-p/567769#M159702 Cassie2 2019-06-20T20:41:00Z Re: Monthly return https://communities.sas.com/t5/SAS-Programming/Monthly-return/m-p/567773#M159704 <P>Since you don't show a variable or anything labeled as "Rt" you need to describe in terms of you data what exactly is meant by "(Rt/Rt-1) -1&nbsp;".</P> <P>&nbsp;</P> <P>You probably need to reshape your data so that you have something that looks more like:</P> <P>Name Code Date Value</P> <P>&nbsp;</P> <P>Do you have a SAS data set? That looks very improbable for the sort of calculation I think you intend as all of those values under the names are going to be character.</P> <P>&nbsp;</P> <P>Instructions here: <A href="https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712" target="_blank">https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712</A> will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.</P> <P>&nbsp;</P> Thu, 20 Jun 2019 20:49:36 GMT https://communities.sas.com/t5/SAS-Programming/Monthly-return/m-p/567773#M159704 ballardw 2019-06-20T20:49:36Z