topic SAS EG Proc Transpose long to wide issue in SAS Programming https://communities.sas.com/t5/SAS-Programming/SAS-EG-Proc-Transpose-long-to-wide-issue/m-p/377742#M90727 <P>Greetings,</P><P>I am trying to create a Proc Transpose on a dataset (portion below) that will list the months (aka "OPMonth") horizontally.</P><P>&nbsp;</P><P>Here is the code that I am currently using to try to get my final output. (does not work)</P><P>&nbsp;</P><P><FONT color="#000080" face="Courier New" size="3"><STRONG>proc</STRONG></FONT> <STRONG><FONT color="#000080" face="Courier New" size="3">sort</FONT></STRONG> <FONT color="#0000ff" face="Courier New" size="3">data</FONT><FONT face="Courier New" size="3">=work.trans1; </FONT><FONT color="#0000ff" face="Courier New" size="3">by</FONT><FONT face="Courier New" size="3"> operatingdate profilecode juriscode tdspcode; </FONT><STRONG><FONT color="#000080" face="Courier New" size="3">run</FONT></STRONG><FONT face="Courier New" size="3">;</FONT></P><P><FONT color="#000080" face="Courier New" size="3"><STRONG>proc</STRONG></FONT> <STRONG><FONT color="#000080" face="Courier New" size="3">transpose</FONT></STRONG> <FONT color="#0000ff" face="Courier New" size="3">data</FONT><FONT face="Courier New" size="3">=work.trans1 </FONT><FONT color="#0000ff" face="Courier New" size="3">out</FONT><FONT face="Courier New" size="3">=work.trans2 ;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">by</FONT><FONT face="Courier New" size="3"> operatingdate profilecode juriscode tdspcode;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">ID</FONT><FONT face="Courier New" size="3"> _name_;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">var</FONT><FONT face="Courier New" size="3"> col1;</FONT></P><P><FONT color="#000080" face="Courier New" size="3"><STRONG>run</STRONG></FONT><FONT face="Courier New" size="3">;</FONT></P><P>&nbsp;</P><TABLE><TBODY><TR><TD>OPERATINGDATE</TD><TD>PROFILECODE</TD><TD>JURISCODE</TD><TD>TDSPCODE</TD><TD>OPmonth</TD><TD>OPday</TD><TD>_NAME_</TD><TD>COL1</TD></TR><TR><TD>14Aug2016</TD><TD>DEDRS</TD><TD>DE</TD><TD>DPL</TD><TD>8</TD><TD>14</TD><TD>H18</TD><TD>658500.36</TD></TR><TR><TD>14Aug2016</TD><TD>DEDRS</TD><TD>DE</TD><TD>DPL</TD><TD>8</TD><TD>14</TD><TD>H17</TD><TD>651602.91</TD></TR><TR><TD>14Aug2016</TD><TD>DEDRS</TD><TD>DE</TD><TD>DPL</TD><TD>8</TD><TD>14</TD><TD>H19</TD><TD>651183.21</TD></TR><TR><TD>13Aug2016</TD><TD>DEDRS</TD><TD>DE</TD><TD>DPL</TD><TD>8</TD><TD>13</TD><TD>H18</TD><TD>646262.29</TD></TR><TR><TD>13Aug2016</TD><TD>DEDRS</TD><TD>DE</TD><TD>DPL</TD><TD>8</TD><TD>13</TD><TD>H17</TD><TD>644484.43</TD></TR><TR><TD>14Aug2016</TD><TD>DEDRS</TD><TD>DE</TD><TD>DPL</TD><TD>8</TD><TD>14</TD><TD>H16</TD><TD>640773.69</TD></TR><TR><TD>25Jul2016</TD><TD>DEDRS</TD><TD>DE</TD><TD>DPL</TD><TD>7</TD><TD>25</TD><TD>H18</TD><TD>635569.99</TD></TR><TR><TD>13Aug2016</TD><TD>DEDRS</TD><TD>DE</TD><TD>DPL</TD><TD>8</TD><TD>13</TD><TD>H16</TD><TD>635450.41</TD></TR><TR><TD>13Aug2016</TD><TD>DEDRS</TD><TD>DE</TD><TD>DPL</TD><TD>8</TD><TD>13</TD><TD>H19</TD><TD>634265.67</TD></TR><TR><TD>25Jul2016</TD><TD>DEDRS</TD><TD>DE</TD><TD>DPL</TD><TD>7</TD><TD>25</TD><TD>H19</TD><TD>630375.34</TD></TR><TR><TD>14Aug2016</TD><TD>DEDRS</TD><TD>DE</TD><TD>DPL</TD><TD>8</TD><TD>14</TD><TD>H20</TD><TD>627307.65</TD></TR><TR><TD>13Aug2016</TD><TD>DEDRS</TD><TD>DE</TD><TD>DPL</TD><TD>8</TD><TD>13</TD><TD>H15</TD><TD>623460.38</TD></TR><TR><TD>14Aug2016</TD><TD>DEDRS</TD><TD>DE</TD><TD>DPL</TD><TD>8</TD><TD>14</TD><TD>H15</TD><TD>623414.82</TD></TR><TR><TD>12Aug2016</TD><TD>DEDRS</TD><TD>DE</TD><TD>DPL</TD><TD>8</TD><TD>12</TD><TD>H18</TD><TD>621818.58</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>The output that I am trying to reach looks like this (below).&nbsp; This excel version is just something I created with formulas/formatting.</P><P>**the months are just formatted versions of the OPMonth .</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Jan-16</TD><TD>Feb-16</TD><TD>Mar-16</TD><TD>Apr-16</TD><TD>May-16</TD><TD>Jun-16</TD><TD>Jul-16</TD><TD>Aug-16</TD><TD>Sep-16</TD><TD>Oct-16</TD><TD>Nov-16</TD><TD>Dec-16</TD></TR><TR><TD>OPERATINGDATE</TD><TD>PROFILECODE</TD><TD>JURISCODE</TD><TD>TDSPCODE</TD><TD>OPmonth</TD><TD>OPday</TD><TD>_NAME_</TD><TD>COL1</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>01Jan2016</TD><TD>DEDRH</TD><TD>DE</TD><TD>DPL</TD><TD>1</TD><TD>1</TD><TD>H1</TD><TD>115888.49</TD><TD>&nbsp;</TD><TD>115888.5</TD><TD>97965.9</TD><TD>98477.07</TD><TD>52615.01</TD><TD>69446.02</TD><TD>75099.41</TD><TD>93049.62</TD><TD>123381.6</TD><TD>94573.11</TD><TD>58783.57</TD><TD>74060.48</TD><TD>56364.86</TD></TR><TR><TD>01Jan2016</TD><TD>DEDRH</TD><TD>DE</TD><TD>DPL</TD><TD>1</TD><TD>1</TD><TD>H2</TD><TD>113513.59</TD><TD>&nbsp;</TD><TD>113513.6</TD><TD>94406.12</TD><TD>99210.04</TD><TD>46978.06</TD><TD>65055.61</TD><TD>65332.29</TD><TD>79793.82</TD><TD>108713.4</TD><TD>84938.23</TD><TD>52625.18</TD><TD>72244.19</TD><TD>51303.32</TD></TR><TR><TD>01Jan2016</TD><TD>DEDRH</TD><TD>DE</TD><TD>DPL</TD><TD>1</TD><TD>1</TD><TD>H3</TD><TD>110715.97</TD><TD>&nbsp;</TD><TD>110716</TD><TD>92162.22</TD><TD>102921.2</TD><TD>44162.5</TD><TD>63690.59</TD><TD>59450.12</TD><TD>72144.71</TD><TD>99996.8</TD><TD>78424.25</TD><TD>49261.83</TD><TD>73411.74</TD><TD>48976.91</TD></TR><TR><TD>01Jan2016</TD><TD>DEDRH</TD><TD>DE</TD><TD>DPL</TD><TD>1</TD><TD>1</TD><TD>H4</TD><TD>110364.59</TD><TD>&nbsp;</TD><TD>110364.6</TD><TD>92311.26</TD><TD>109088.3</TD><TD>43087.21</TD><TD>63346.36</TD><TD>56118.72</TD><TD>67899.97</TD><TD>93867.62</TD><TD>74546.56</TD><TD>47450.97</TD><TD>76741.44</TD><TD>48877.5</TD></TR><TR><TD>01Jan2016</TD><TD>DEDRH</TD><TD>DE</TD><TD>DPL</TD><TD>1</TD><TD>1</TD><TD>H5</TD><TD>113030.91</TD><TD>&nbsp;</TD><TD>113030.9</TD><TD>96685.66</TD><TD>119436.8</TD><TD>44305.71</TD><TD>64715.83</TD><TD>56226.19</TD><TD>66710.41</TD><TD>91618.8</TD><TD>73816.55</TD><TD>47036.92</TD><TD>84036.46</TD><TD>52309.95</TD></TR><TR><TD>01Jan2016</TD><TD>DEDRH</TD><TD>DE</TD><TD>DPL</TD><TD>1</TD><TD>1</TD><TD>H6</TD><TD>118782.56</TD><TD>&nbsp;</TD><TD>118782.6</TD><TD>110182.5</TD><TD>138744.6</TD><TD>50575.07</TD><TD>68672.44</TD><TD>63339.16</TD><TD>70701.52</TD><TD>94502.34</TD><TD>79341.84</TD><TD>48697.86</TD><TD>100410.1</TD><TD>64251.48</TD></TR><TR><TD>01Jan2016</TD><TD>DEDRH</TD><TD>DE</TD><TD>DPL</TD><TD>1</TD><TD>1</TD><TD>H7</TD><TD>124209.36</TD><TD>&nbsp;</TD><TD>124209.4</TD><TD>131578.4</TD><TD>165754</TD><TD>62025.77</TD><TD>77449</TD><TD>79469.88</TD><TD>81755.14</TD><TD>103522</TD><TD>92023.21</TD><TD>53338.61</TD><TD>123365.3</TD><TD>85052.81</TD></TR><TR><TD>01Jan2016</TD><TD>DEDRH</TD><TD>DE</TD><TD>DPL</TD><TD>1</TD><TD>1</TD><TD>H8</TD><TD>131788.46</TD><TD>&nbsp;</TD><TD>131788.5</TD><TD>133593.8</TD><TD>159430.5</TD><TD>69708.99</TD><TD>89308.4</TD><TD>84406.41</TD><TD>93339.95</TD><TD>113636.1</TD><TD>94881.68</TD><TD>62850.05</TD><TD>126672.3</TD><TD>89474.3</TD></TR><TR><TD>01Jan2016</TD><TD>DEDRH</TD><TD>DE</TD><TD>DPL</TD><TD>1</TD><TD>1</TD><TD>H9</TD><TD>140949.59</TD><TD>&nbsp;</TD><TD>140949.6</TD><TD>116586.1</TD><TD>125307.8</TD><TD>70185.55</TD><TD>101822.3</TD><TD>82746.25</TD><TD>102666.9</TD><TD>119785.1</TD><TD>92737.56</TD><TD>74555.45</TD><TD>113178.6</TD><TD>79086.95</TD></TR><TR><TD>01Jan2016</TD><TD>DEDRH</TD><TD>DE</TD><TD>DPL</TD><TD>1</TD><TD>1</TD><TD>H10</TD><TD>146813.37</TD><TD>&nbsp;</TD><TD>146813.4</TD><TD>101361.4</TD><TD>100013.1</TD><TD>69908.73</TD><TD>110494</TD><TD>86251.19</TD><TD>110731.5</TD><TD>129422.5</TD><TD>95312</TD><TD>82033.96</TD><TD>97792.05</TD><TD>71083.73</TD></TR><TR><TD>01Jan2016</TD><TD>DEDRH</TD><TD>DE</TD><TD>DPL</TD><TD>1</TD><TD>1</TD><TD>H11</TD><TD>150880.55</TD><TD>&nbsp;</TD><TD>150880.6</TD><TD>96098</TD><TD>85503.1</TD><TD>70747.7</TD><TD>112967.2</TD><TD>92585.26</TD><TD>121205.6</TD><TD>138169.2</TD><TD>96734</TD><TD>85603.71</TD><TD>85135.53</TD><TD>66771.7</TD></TR></TBODY></TABLE> Thu, 20 Jul 2017 13:04:33 GMT tobyfarms 2017-07-20T13:04:33Z SAS EG Proc Transpose long to wide issue https://communities.sas.com/t5/SAS-Programming/SAS-EG-Proc-Transpose-long-to-wide-issue/m-p/377742#M90727 <P>Greetings,</P><P>I am trying to create a Proc Transpose on a dataset (portion below) that will list the months (aka "OPMonth") horizontally.</P><P>&nbsp;</P><P>Here is the code that I am currently using to try to get my final output. (does not work)</P><P>&nbsp;</P><P><FONT color="#000080" face="Courier New" size="3"><STRONG>proc</STRONG></FONT> <STRONG><FONT color="#000080" face="Courier New" size="3">sort</FONT></STRONG> <FONT color="#0000ff" face="Courier New" size="3">data</FONT><FONT face="Courier New" size="3">=work.trans1; </FONT><FONT color="#0000ff" face="Courier New" size="3">by</FONT><FONT face="Courier New" size="3"> operatingdate profilecode juriscode tdspcode; </FONT><STRONG><FONT color="#000080" face="Courier New" size="3">run</FONT></STRONG><FONT face="Courier New" size="3">;</FONT></P><P><FONT color="#000080" face="Courier New" size="3"><STRONG>proc</STRONG></FONT> <STRONG><FONT color="#000080" face="Courier New" size="3">transpose</FONT></STRONG> <FONT color="#0000ff" face="Courier New" size="3">data</FONT><FONT face="Courier New" size="3">=work.trans1 </FONT><FONT color="#0000ff" face="Courier New" size="3">out</FONT><FONT face="Courier New" size="3">=work.trans2 ;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">by</FONT><FONT face="Courier New" size="3"> operatingdate profilecode juriscode tdspcode;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">ID</FONT><FONT face="Courier New" size="3"> _name_;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="3">var</FONT><FONT face="Courier New" size="3"> col1;</FONT></P><P><FONT color="#000080" face="Courier New" size="3"><STRONG>run</STRONG></FONT><FONT face="Courier New" size="3">;</FONT></P><P>&nbsp;</P><TABLE><TBODY><TR><TD>OPERATINGDATE</TD><TD>PROFILECODE</TD><TD>JURISCODE</TD><TD>TDSPCODE</TD><TD>OPmonth</TD><TD>OPday</TD><TD>_NAME_</TD><TD>COL1</TD></TR><TR><TD>14Aug2016</TD><TD>DEDRS</TD><TD>DE</TD><TD>DPL</TD><TD>8</TD><TD>14</TD><TD>H18</TD><TD>658500.36</TD></TR><TR><TD>14Aug2016</TD><TD>DEDRS</TD><TD>DE</TD><TD>DPL</TD><TD>8</TD><TD>14</TD><TD>H17</TD><TD>651602.91</TD></TR><TR><TD>14Aug2016</TD><TD>DEDRS</TD><TD>DE</TD><TD>DPL</TD><TD>8</TD><TD>14</TD><TD>H19</TD><TD>651183.21</TD></TR><TR><TD>13Aug2016</TD><TD>DEDRS</TD><TD>DE</TD><TD>DPL</TD><TD>8</TD><TD>13</TD><TD>H18</TD><TD>646262.29</TD></TR><TR><TD>13Aug2016</TD><TD>DEDRS</TD><TD>DE</TD><TD>DPL</TD><TD>8</TD><TD>13</TD><TD>H17</TD><TD>644484.43</TD></TR><TR><TD>14Aug2016</TD><TD>DEDRS</TD><TD>DE</TD><TD>DPL</TD><TD>8</TD><TD>14</TD><TD>H16</TD><TD>640773.69</TD></TR><TR><TD>25Jul2016</TD><TD>DEDRS</TD><TD>DE</TD><TD>DPL</TD><TD>7</TD><TD>25</TD><TD>H18</TD><TD>635569.99</TD></TR><TR><TD>13Aug2016</TD><TD>DEDRS</TD><TD>DE</TD><TD>DPL</TD><TD>8</TD><TD>13</TD><TD>H16</TD><TD>635450.41</TD></TR><TR><TD>13Aug2016</TD><TD>DEDRS</TD><TD>DE</TD><TD>DPL</TD><TD>8</TD><TD>13</TD><TD>H19</TD><TD>634265.67</TD></TR><TR><TD>25Jul2016</TD><TD>DEDRS</TD><TD>DE</TD><TD>DPL</TD><TD>7</TD><TD>25</TD><TD>H19</TD><TD>630375.34</TD></TR><TR><TD>14Aug2016</TD><TD>DEDRS</TD><TD>DE</TD><TD>DPL</TD><TD>8</TD><TD>14</TD><TD>H20</TD><TD>627307.65</TD></TR><TR><TD>13Aug2016</TD><TD>DEDRS</TD><TD>DE</TD><TD>DPL</TD><TD>8</TD><TD>13</TD><TD>H15</TD><TD>623460.38</TD></TR><TR><TD>14Aug2016</TD><TD>DEDRS</TD><TD>DE</TD><TD>DPL</TD><TD>8</TD><TD>14</TD><TD>H15</TD><TD>623414.82</TD></TR><TR><TD>12Aug2016</TD><TD>DEDRS</TD><TD>DE</TD><TD>DPL</TD><TD>8</TD><TD>12</TD><TD>H18</TD><TD>621818.58</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>The output that I am trying to reach looks like this (below).&nbsp; This excel version is just something I created with formulas/formatting.</P><P>**the months are just formatted versions of the OPMonth .</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Jan-16</TD><TD>Feb-16</TD><TD>Mar-16</TD><TD>Apr-16</TD><TD>May-16</TD><TD>Jun-16</TD><TD>Jul-16</TD><TD>Aug-16</TD><TD>Sep-16</TD><TD>Oct-16</TD><TD>Nov-16</TD><TD>Dec-16</TD></TR><TR><TD>OPERATINGDATE</TD><TD>PROFILECODE</TD><TD>JURISCODE</TD><TD>TDSPCODE</TD><TD>OPmonth</TD><TD>OPday</TD><TD>_NAME_</TD><TD>COL1</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>01Jan2016</TD><TD>DEDRH</TD><TD>DE</TD><TD>DPL</TD><TD>1</TD><TD>1</TD><TD>H1</TD><TD>115888.49</TD><TD>&nbsp;</TD><TD>115888.5</TD><TD>97965.9</TD><TD>98477.07</TD><TD>52615.01</TD><TD>69446.02</TD><TD>75099.41</TD><TD>93049.62</TD><TD>123381.6</TD><TD>94573.11</TD><TD>58783.57</TD><TD>74060.48</TD><TD>56364.86</TD></TR><TR><TD>01Jan2016</TD><TD>DEDRH</TD><TD>DE</TD><TD>DPL</TD><TD>1</TD><TD>1</TD><TD>H2</TD><TD>113513.59</TD><TD>&nbsp;</TD><TD>113513.6</TD><TD>94406.12</TD><TD>99210.04</TD><TD>46978.06</TD><TD>65055.61</TD><TD>65332.29</TD><TD>79793.82</TD><TD>108713.4</TD><TD>84938.23</TD><TD>52625.18</TD><TD>72244.19</TD><TD>51303.32</TD></TR><TR><TD>01Jan2016</TD><TD>DEDRH</TD><TD>DE</TD><TD>DPL</TD><TD>1</TD><TD>1</TD><TD>H3</TD><TD>110715.97</TD><TD>&nbsp;</TD><TD>110716</TD><TD>92162.22</TD><TD>102921.2</TD><TD>44162.5</TD><TD>63690.59</TD><TD>59450.12</TD><TD>72144.71</TD><TD>99996.8</TD><TD>78424.25</TD><TD>49261.83</TD><TD>73411.74</TD><TD>48976.91</TD></TR><TR><TD>01Jan2016</TD><TD>DEDRH</TD><TD>DE</TD><TD>DPL</TD><TD>1</TD><TD>1</TD><TD>H4</TD><TD>110364.59</TD><TD>&nbsp;</TD><TD>110364.6</TD><TD>92311.26</TD><TD>109088.3</TD><TD>43087.21</TD><TD>63346.36</TD><TD>56118.72</TD><TD>67899.97</TD><TD>93867.62</TD><TD>74546.56</TD><TD>47450.97</TD><TD>76741.44</TD><TD>48877.5</TD></TR><TR><TD>01Jan2016</TD><TD>DEDRH</TD><TD>DE</TD><TD>DPL</TD><TD>1</TD><TD>1</TD><TD>H5</TD><TD>113030.91</TD><TD>&nbsp;</TD><TD>113030.9</TD><TD>96685.66</TD><TD>119436.8</TD><TD>44305.71</TD><TD>64715.83</TD><TD>56226.19</TD><TD>66710.41</TD><TD>91618.8</TD><TD>73816.55</TD><TD>47036.92</TD><TD>84036.46</TD><TD>52309.95</TD></TR><TR><TD>01Jan2016</TD><TD>DEDRH</TD><TD>DE</TD><TD>DPL</TD><TD>1</TD><TD>1</TD><TD>H6</TD><TD>118782.56</TD><TD>&nbsp;</TD><TD>118782.6</TD><TD>110182.5</TD><TD>138744.6</TD><TD>50575.07</TD><TD>68672.44</TD><TD>63339.16</TD><TD>70701.52</TD><TD>94502.34</TD><TD>79341.84</TD><TD>48697.86</TD><TD>100410.1</TD><TD>64251.48</TD></TR><TR><TD>01Jan2016</TD><TD>DEDRH</TD><TD>DE</TD><TD>DPL</TD><TD>1</TD><TD>1</TD><TD>H7</TD><TD>124209.36</TD><TD>&nbsp;</TD><TD>124209.4</TD><TD>131578.4</TD><TD>165754</TD><TD>62025.77</TD><TD>77449</TD><TD>79469.88</TD><TD>81755.14</TD><TD>103522</TD><TD>92023.21</TD><TD>53338.61</TD><TD>123365.3</TD><TD>85052.81</TD></TR><TR><TD>01Jan2016</TD><TD>DEDRH</TD><TD>DE</TD><TD>DPL</TD><TD>1</TD><TD>1</TD><TD>H8</TD><TD>131788.46</TD><TD>&nbsp;</TD><TD>131788.5</TD><TD>133593.8</TD><TD>159430.5</TD><TD>69708.99</TD><TD>89308.4</TD><TD>84406.41</TD><TD>93339.95</TD><TD>113636.1</TD><TD>94881.68</TD><TD>62850.05</TD><TD>126672.3</TD><TD>89474.3</TD></TR><TR><TD>01Jan2016</TD><TD>DEDRH</TD><TD>DE</TD><TD>DPL</TD><TD>1</TD><TD>1</TD><TD>H9</TD><TD>140949.59</TD><TD>&nbsp;</TD><TD>140949.6</TD><TD>116586.1</TD><TD>125307.8</TD><TD>70185.55</TD><TD>101822.3</TD><TD>82746.25</TD><TD>102666.9</TD><TD>119785.1</TD><TD>92737.56</TD><TD>74555.45</TD><TD>113178.6</TD><TD>79086.95</TD></TR><TR><TD>01Jan2016</TD><TD>DEDRH</TD><TD>DE</TD><TD>DPL</TD><TD>1</TD><TD>1</TD><TD>H10</TD><TD>146813.37</TD><TD>&nbsp;</TD><TD>146813.4</TD><TD>101361.4</TD><TD>100013.1</TD><TD>69908.73</TD><TD>110494</TD><TD>86251.19</TD><TD>110731.5</TD><TD>129422.5</TD><TD>95312</TD><TD>82033.96</TD><TD>97792.05</TD><TD>71083.73</TD></TR><TR><TD>01Jan2016</TD><TD>DEDRH</TD><TD>DE</TD><TD>DPL</TD><TD>1</TD><TD>1</TD><TD>H11</TD><TD>150880.55</TD><TD>&nbsp;</TD><TD>150880.6</TD><TD>96098</TD><TD>85503.1</TD><TD>70747.7</TD><TD>112967.2</TD><TD>92585.26</TD><TD>121205.6</TD><TD>138169.2</TD><TD>96734</TD><TD>85603.71</TD><TD>85135.53</TD><TD>66771.7</TD></TR></TBODY></TABLE> Thu, 20 Jul 2017 13:04:33 GMT https://communities.sas.com/t5/SAS-Programming/SAS-EG-Proc-Transpose-long-to-wide-issue/m-p/377742#M90727 tobyfarms 2017-07-20T13:04:33Z Re: SAS EG Proc Transpose long to wide issue https://communities.sas.com/t5/SAS-Programming/SAS-EG-Proc-Transpose-long-to-wide-issue/m-p/377745#M90728 <P>And what "does not work"? &nbsp;You haven't provide any sample data (in the form of a datastep) for us to run to get answers, nor provided any information on what doesnt work such as logs etc. &nbsp;After transpose this variables:&nbsp;</P> <TABLE> <TBODY> <TR> <TD>OPmonth</TD> <TD>OPday</TD> <TD>_NAME_</TD> <TD> <P>COL1</P> </TD> </TR> </TBODY> </TABLE> <P>Would not be present as they are not on the by group and name variable does not look like the month/year you have in the output, so no idea why you expect it would be.</P> <P>&nbsp;</P> Thu, 20 Jul 2017 13:14:51 GMT https://communities.sas.com/t5/SAS-Programming/SAS-EG-Proc-Transpose-long-to-wide-issue/m-p/377745#M90728 RW9 2017-07-20T13:14:51Z