topic how to transpose the data? in SAS Programming https://communities.sas.com/t5/SAS-Programming/how-to-transpose-the-data/m-p/585748#M167119 <P>dear all</P><P>&nbsp;</P><P>i have the quarterly data from march, 2007 to March, 2018 in the following format.&nbsp;</P><TABLE><TBODY><TR><TD>&nbsp;</TD><TD>Mar-07</TD><TD>Jun-07</TD><TD>Sep-07</TD><TD>Dec-07</TD><TD>Mar-08</TD><TD>Jun-08</TD><TD>Sep-08</TD><TD>Dec-08</TD><TD>…………….</TD><TD>Mar-17</TD><TD>Jun-17</TD><TD>Sep-17</TD><TD>Dec-17</TD><TD>Mar-18</TD></TR><TR><TD>Company&nbsp;</TD><TD>Investment</TD><TD>Investment</TD><TD>Investment</TD><TD>Investment</TD><TD>Investment</TD><TD>Investment</TD><TD>Investment</TD><TD>Investment</TD><TD>&nbsp;</TD><TD>Investment</TD><TD>Investment</TD><TD>Investment</TD><TD>Investment</TD><TD>Investment</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>24.03</TD><TD>27.29</TD><TD>30.34</TD><TD>31.73</TD><TD>33.39</TD><TD>33.2</TD><TD>32.46</TD><TD>28.48</TD><TD>&nbsp;</TD><TD>52.31</TD><TD>48.96</TD><TD>47.89</TD><TD>47.73</TD><TD>38.96</TD></TR><TR><TD>3M India Ltd.</TD><TD>1.94</TD><TD>8.61</TD><TD>8.78</TD><TD>10.19</TD><TD>10.58</TD><TD>10.96</TD><TD>11.36</TD><TD>11.46</TD><TD>&nbsp;</TD><TD>11.72</TD><TD>11.57</TD><TD>11.45</TD><TD>11.4</TD><TD>11.22</TD></TR><TR><TD>3P Land Holdings Ltd.</TD><TD>0.33</TD><TD>0.33</TD><TD>0.33</TD><TD>0.11</TD><TD>0.11</TD><TD>0.11</TD><TD>0.11</TD><TD>0.11</TD><TD>&nbsp;</TD><TD>0.11</TD><TD>11.97</TD><TD>14.77</TD><TD>11.45</TD><TD>11.29</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>33.03</TD><TD>33.39</TD><TD>34.42</TD><TD>32.61</TD><TD>33.8</TD><TD>34.65</TD><TD>34.38</TD><TD>34.03</TD><TD>&nbsp;</TD><TD>11.56</TD><TD>11.18</TD><TD>4.51</TD><TD>5.33</TD><TD>5.48</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>i want to transpose the data as follows&nbsp;</P><TABLE><TBODY><TR><TD>company&nbsp;</TD><TD>Period</TD><TD>Investment</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>200703</TD><TD>24.03</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>200706</TD><TD>27.29</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>200709</TD><TD>30.34</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>200712</TD><TD>31.73</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>200803</TD><TD>33.39</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>200806</TD><TD>33.2</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>200809</TD><TD>32.46</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>200812</TD><TD>28.48</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>………………</TD><TD>……………..</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>……………..</TD><TD>……………</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>…………..</TD><TD>………………</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>201703</TD><TD>52.31</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>201706</TD><TD>48.96</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>201709</TD><TD>47.89</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>201712</TD><TD>47.73</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>201803</TD><TD>38.96</TD></TR><TR><TD>3M India Ltd.</TD><TD>200703</TD><TD>1.94</TD></TR><TR><TD>3M India Ltd.</TD><TD>200706</TD><TD>8.61</TD></TR><TR><TD>3M India Ltd.</TD><TD>200709</TD><TD>8.78</TD></TR><TR><TD>3M India Ltd.</TD><TD>200712</TD><TD>10.19</TD></TR><TR><TD>3M India Ltd.</TD><TD>200803</TD><TD>10.58</TD></TR><TR><TD>3M India Ltd.</TD><TD>200806</TD><TD>10.96</TD></TR><TR><TD>3M India Ltd.</TD><TD>200809</TD><TD>11.36</TD></TR><TR><TD>3M India Ltd.</TD><TD>200812</TD><TD>11.46</TD></TR><TR><TD>3M India Ltd.</TD><TD>………………</TD></TR><TR><TD>3M India Ltd.</TD><TD>……………..</TD><TD>&nbsp;</TD></TR><TR><TD>3M India Ltd.</TD><TD>…………..</TD><TD>&nbsp;</TD></TR><TR><TD>3M India Ltd.</TD><TD>201703</TD><TD>11.72</TD></TR><TR><TD>3M India Ltd.</TD><TD>201706</TD><TD>11.57</TD></TR><TR><TD>3M India Ltd.</TD><TD>201709</TD><TD>11.45</TD></TR><TR><TD>3M India Ltd.</TD><TD>201712</TD><TD>11.4</TD></TR><TR><TD>3M India Ltd.</TD><TD>201803</TD><TD>11.22</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>please suggest a SAS code to transpose the data in the above format</P><P>&nbsp;</P><P>thanks in advance&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 03 Sep 2019 10:43:14 GMT srikanthyadav44 2019-09-03T10:43:14Z how to transpose the data? https://communities.sas.com/t5/SAS-Programming/how-to-transpose-the-data/m-p/585748#M167119 <P>dear all</P><P>&nbsp;</P><P>i have the quarterly data from march, 2007 to March, 2018 in the following format.&nbsp;</P><TABLE><TBODY><TR><TD>&nbsp;</TD><TD>Mar-07</TD><TD>Jun-07</TD><TD>Sep-07</TD><TD>Dec-07</TD><TD>Mar-08</TD><TD>Jun-08</TD><TD>Sep-08</TD><TD>Dec-08</TD><TD>…………….</TD><TD>Mar-17</TD><TD>Jun-17</TD><TD>Sep-17</TD><TD>Dec-17</TD><TD>Mar-18</TD></TR><TR><TD>Company&nbsp;</TD><TD>Investment</TD><TD>Investment</TD><TD>Investment</TD><TD>Investment</TD><TD>Investment</TD><TD>Investment</TD><TD>Investment</TD><TD>Investment</TD><TD>&nbsp;</TD><TD>Investment</TD><TD>Investment</TD><TD>Investment</TD><TD>Investment</TD><TD>Investment</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>24.03</TD><TD>27.29</TD><TD>30.34</TD><TD>31.73</TD><TD>33.39</TD><TD>33.2</TD><TD>32.46</TD><TD>28.48</TD><TD>&nbsp;</TD><TD>52.31</TD><TD>48.96</TD><TD>47.89</TD><TD>47.73</TD><TD>38.96</TD></TR><TR><TD>3M India Ltd.</TD><TD>1.94</TD><TD>8.61</TD><TD>8.78</TD><TD>10.19</TD><TD>10.58</TD><TD>10.96</TD><TD>11.36</TD><TD>11.46</TD><TD>&nbsp;</TD><TD>11.72</TD><TD>11.57</TD><TD>11.45</TD><TD>11.4</TD><TD>11.22</TD></TR><TR><TD>3P Land Holdings Ltd.</TD><TD>0.33</TD><TD>0.33</TD><TD>0.33</TD><TD>0.11</TD><TD>0.11</TD><TD>0.11</TD><TD>0.11</TD><TD>0.11</TD><TD>&nbsp;</TD><TD>0.11</TD><TD>11.97</TD><TD>14.77</TD><TD>11.45</TD><TD>11.29</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>33.03</TD><TD>33.39</TD><TD>34.42</TD><TD>32.61</TD><TD>33.8</TD><TD>34.65</TD><TD>34.38</TD><TD>34.03</TD><TD>&nbsp;</TD><TD>11.56</TD><TD>11.18</TD><TD>4.51</TD><TD>5.33</TD><TD>5.48</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>i want to transpose the data as follows&nbsp;</P><TABLE><TBODY><TR><TD>company&nbsp;</TD><TD>Period</TD><TD>Investment</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>200703</TD><TD>24.03</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>200706</TD><TD>27.29</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>200709</TD><TD>30.34</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>200712</TD><TD>31.73</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>200803</TD><TD>33.39</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>200806</TD><TD>33.2</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>200809</TD><TD>32.46</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>200812</TD><TD>28.48</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>………………</TD><TD>……………..</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>……………..</TD><TD>……………</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>…………..</TD><TD>………………</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>201703</TD><TD>52.31</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>201706</TD><TD>48.96</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>201709</TD><TD>47.89</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>201712</TD><TD>47.73</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>201803</TD><TD>38.96</TD></TR><TR><TD>3M India Ltd.</TD><TD>200703</TD><TD>1.94</TD></TR><TR><TD>3M India Ltd.</TD><TD>200706</TD><TD>8.61</TD></TR><TR><TD>3M India Ltd.</TD><TD>200709</TD><TD>8.78</TD></TR><TR><TD>3M India Ltd.</TD><TD>200712</TD><TD>10.19</TD></TR><TR><TD>3M India Ltd.</TD><TD>200803</TD><TD>10.58</TD></TR><TR><TD>3M India Ltd.</TD><TD>200806</TD><TD>10.96</TD></TR><TR><TD>3M India Ltd.</TD><TD>200809</TD><TD>11.36</TD></TR><TR><TD>3M India Ltd.</TD><TD>200812</TD><TD>11.46</TD></TR><TR><TD>3M India Ltd.</TD><TD>………………</TD></TR><TR><TD>3M India Ltd.</TD><TD>……………..</TD><TD>&nbsp;</TD></TR><TR><TD>3M India Ltd.</TD><TD>…………..</TD><TD>&nbsp;</TD></TR><TR><TD>3M India Ltd.</TD><TD>201703</TD><TD>11.72</TD></TR><TR><TD>3M India Ltd.</TD><TD>201706</TD><TD>11.57</TD></TR><TR><TD>3M India Ltd.</TD><TD>201709</TD><TD>11.45</TD></TR><TR><TD>3M India Ltd.</TD><TD>201712</TD><TD>11.4</TD></TR><TR><TD>3M India Ltd.</TD><TD>201803</TD><TD>11.22</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>please suggest a SAS code to transpose the data in the above format</P><P>&nbsp;</P><P>thanks in advance&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 03 Sep 2019 10:43:14 GMT https://communities.sas.com/t5/SAS-Programming/how-to-transpose-the-data/m-p/585748#M167119 srikanthyadav44 2019-09-03T10:43:14Z Re: how to transpose the data? https://communities.sas.com/t5/SAS-Programming/how-to-transpose-the-data/m-p/585753#M167123 <P>please post the data you have in usable form, that is a data step using datalines-statement. You should take care that all variables have valid sas-names, value like "Mar-07" are not valid names!</P> Tue, 03 Sep 2019 10:56:23 GMT https://communities.sas.com/t5/SAS-Programming/how-to-transpose-the-data/m-p/585753#M167123 andreas_lds 2019-09-03T10:56:23Z Re: how to transpose the data? https://communities.sas.com/t5/SAS-Programming/how-to-transpose-the-data/m-p/585813#M167154 <P>Have you tried a basic PROC TRANSPOSE? From your data, it appears fairly straightforward.&nbsp;</P> <P>&nbsp;</P> <P>Transposing data tutorials:<BR /><BR /><BR />Wide to Long:<BR /><A href="https://stats.idre.ucla.edu/sas/modules/how-to-reshape-data-wide-to-long-using-proc-transpose/" target="_blank">https://stats.idre.ucla.edu/sas/modules/how-to-reshape-data-wide-to-long-using-proc-transpose/</A><BR /><BR /><A href="https://stats.idre.ucla.edu/sas/modules/reshaping-data-wide-to-long-using-a-data-step/" target="_blank">https://stats.idre.ucla.edu/sas/modules/reshaping-data-wide-to-long-using-a-data-step/</A><BR /><BR /></P> <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/280123">@srikanthyadav44</a>&nbsp;wrote:<BR /> <P>dear all</P> <P>&nbsp;</P> <P>i have the quarterly data from march, 2007 to March, 2018 in the following format.&nbsp;</P> <TABLE> <TBODY> <TR> <TD>&nbsp;</TD> <TD>Mar-07</TD> <TD>Jun-07</TD> <TD>Sep-07</TD> <TD>Dec-07</TD> <TD>Mar-08</TD> <TD>Jun-08</TD> <TD>Sep-08</TD> <TD>Dec-08</TD> <TD>…………….</TD> <TD>Mar-17</TD> <TD>Jun-17</TD> <TD>Sep-17</TD> <TD>Dec-17</TD> <TD>Mar-18</TD> </TR> <TR> <TD>Company&nbsp;</TD> <TD>Investment</TD> <TD>Investment</TD> <TD>Investment</TD> <TD>Investment</TD> <TD>Investment</TD> <TD>Investment</TD> <TD>Investment</TD> <TD>Investment</TD> <TD>&nbsp;</TD> <TD>Investment</TD> <TD>Investment</TD> <TD>Investment</TD> <TD>Investment</TD> <TD>Investment</TD> </TR> <TR> <TD>3I Infotech Ltd.</TD> <TD>24.03</TD> <TD>27.29</TD> <TD>30.34</TD> <TD>31.73</TD> <TD>33.39</TD> <TD>33.2</TD> <TD>32.46</TD> <TD>28.48</TD> <TD>&nbsp;</TD> <TD>52.31</TD> <TD>48.96</TD> <TD>47.89</TD> <TD>47.73</TD> <TD>38.96</TD> </TR> <TR> <TD>3M India Ltd.</TD> <TD>1.94</TD> <TD>8.61</TD> <TD>8.78</TD> <TD>10.19</TD> <TD>10.58</TD> <TD>10.96</TD> <TD>11.36</TD> <TD>11.46</TD> <TD>&nbsp;</TD> <TD>11.72</TD> <TD>11.57</TD> <TD>11.45</TD> <TD>11.4</TD> <TD>11.22</TD> </TR> <TR> <TD>3P Land Holdings Ltd.</TD> <TD>0.33</TD> <TD>0.33</TD> <TD>0.33</TD> <TD>0.11</TD> <TD>0.11</TD> <TD>0.11</TD> <TD>0.11</TD> <TD>0.11</TD> <TD>&nbsp;</TD> <TD>0.11</TD> <TD>11.97</TD> <TD>14.77</TD> <TD>11.45</TD> <TD>11.29</TD> </TR> <TR> <TD>63 Moons Technologies Ltd.</TD> <TD>33.03</TD> <TD>33.39</TD> <TD>34.42</TD> <TD>32.61</TD> <TD>33.8</TD> <TD>34.65</TD> <TD>34.38</TD> <TD>34.03</TD> <TD>&nbsp;</TD> <TD>11.56</TD> <TD>11.18</TD> <TD>4.51</TD> <TD>5.33</TD> <TD>5.48</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>i want to transpose the data as follows&nbsp;</P> <TABLE> <TBODY> <TR> <TD>company&nbsp;</TD> <TD>Period</TD> <TD>Investment</TD> </TR> <TR> <TD>3I Infotech Ltd.</TD> <TD>200703</TD> <TD>24.03</TD> </TR> <TR> <TD>3I Infotech Ltd.</TD> <TD>200706</TD> <TD>27.29</TD> </TR> <TR> <TD>3I Infotech Ltd.</TD> <TD>200709</TD> <TD>30.34</TD> </TR> <TR> <TD>3I Infotech Ltd.</TD> <TD>200712</TD> <TD>31.73</TD> </TR> <TR> <TD>3I Infotech Ltd.</TD> <TD>200803</TD> <TD>33.39</TD> </TR> <TR> <TD>3I Infotech Ltd.</TD> <TD>200806</TD> <TD>33.2</TD> </TR> <TR> <TD>3I Infotech Ltd.</TD> <TD>200809</TD> <TD>32.46</TD> </TR> <TR> <TD>3I Infotech Ltd.</TD> <TD>200812</TD> <TD>28.48</TD> </TR> <TR> <TD>3I Infotech Ltd.</TD> <TD>………………</TD> <TD>……………..</TD> </TR> <TR> <TD>3I Infotech Ltd.</TD> <TD>……………..</TD> <TD>……………</TD> </TR> <TR> <TD>3I Infotech Ltd.</TD> <TD>…………..</TD> <TD>………………</TD> </TR> <TR> <TD>3I Infotech Ltd.</TD> <TD>201703</TD> <TD>52.31</TD> </TR> <TR> <TD>3I Infotech Ltd.</TD> <TD>201706</TD> <TD>48.96</TD> </TR> <TR> <TD>3I Infotech Ltd.</TD> <TD>201709</TD> <TD>47.89</TD> </TR> <TR> <TD>3I Infotech Ltd.</TD> <TD>201712</TD> <TD>47.73</TD> </TR> <TR> <TD>3I Infotech Ltd.</TD> <TD>201803</TD> <TD>38.96</TD> </TR> <TR> <TD>3M India Ltd.</TD> <TD>200703</TD> <TD>1.94</TD> </TR> <TR> <TD>3M India Ltd.</TD> <TD>200706</TD> <TD>8.61</TD> </TR> <TR> <TD>3M India Ltd.</TD> <TD>200709</TD> <TD>8.78</TD> </TR> <TR> <TD>3M India Ltd.</TD> <TD>200712</TD> <TD>10.19</TD> </TR> <TR> <TD>3M India Ltd.</TD> <TD>200803</TD> <TD>10.58</TD> </TR> <TR> <TD>3M India Ltd.</TD> <TD>200806</TD> <TD>10.96</TD> </TR> <TR> <TD>3M India Ltd.</TD> <TD>200809</TD> <TD>11.36</TD> </TR> <TR> <TD>3M India Ltd.</TD> <TD>200812</TD> <TD>11.46</TD> </TR> <TR> <TD>3M India Ltd.</TD> <TD>………………</TD> </TR> <TR> <TD>3M India Ltd.</TD> <TD>……………..</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>3M India Ltd.</TD> <TD>…………..</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>3M India Ltd.</TD> <TD>201703</TD> <TD>11.72</TD> </TR> <TR> <TD>3M India Ltd.</TD> <TD>201706</TD> <TD>11.57</TD> </TR> <TR> <TD>3M India Ltd.</TD> <TD>201709</TD> <TD>11.45</TD> </TR> <TR> <TD>3M India Ltd.</TD> <TD>201712</TD> <TD>11.4</TD> </TR> <TR> <TD>3M India Ltd.</TD> <TD>201803</TD> <TD>11.22</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>please suggest a SAS code to transpose the data in the above format</P> <P>&nbsp;</P> <P>thanks in advance&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <HR /></BLOCKQUOTE> <P>&nbsp;</P> Tue, 03 Sep 2019 13:15:10 GMT https://communities.sas.com/t5/SAS-Programming/how-to-transpose-the-data/m-p/585813#M167154 Reeza 2019-09-03T13:15:10Z