topic Re: Change panel data format in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Change-panel-data-format/m-p/125073#M34363 <HTML><HEAD></HEAD><BODY><P>borrowed Anca's data:</P><P></P><P>data wide;</P><P>input Year&nbsp;&nbsp;&nbsp; Firm1_price&nbsp;&nbsp;&nbsp; Firm1_volume&nbsp;&nbsp;&nbsp; Year&nbsp;&nbsp;&nbsp; Firm2_price&nbsp;&nbsp;&nbsp; Firm2_volume&nbsp;&nbsp;&nbsp; Year&nbsp;&nbsp;&nbsp; Firm3_price&nbsp;&nbsp;&nbsp; Firm3_volume;</P><P>cards;</P><P>1970&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp;&nbsp; 1970&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp; 1970&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp; 84</P><P>1971&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp; 1971&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp; 1971&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 3</P><P>1972&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp; 1972&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp; 1972&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp; 43</P><P>1973&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp; 44&nbsp;&nbsp;&nbsp; 1973&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp; 1973&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 12</P><P>1974&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp; 1974&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp; 1974&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 86</P><P>1975&nbsp;&nbsp;&nbsp; 23&nbsp;&nbsp;&nbsp; 99&nbsp;&nbsp;&nbsp; 1975&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp; 1975&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp; 58</P><P>1976&nbsp;&nbsp;&nbsp; 39&nbsp;&nbsp;&nbsp; 33&nbsp;&nbsp;&nbsp; 1976&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp; 1976&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp; 63</P><P>;</P><P>data long;</P><P>&nbsp; set wide;</P><P>&nbsp; array _price(*)&nbsp; firm1_price firm2_price firm3_price;</P><P>&nbsp; array _volume(*)&nbsp; firm1_volume firm2_volume firm3_volume;</P><P>&nbsp; do _n_=1 to dim(_price);</P><P>&nbsp; price=_price(_n_);</P><P>&nbsp; volume=_volume(_n_);</P><P>&nbsp; firm=scan(vname(_price(_n_)),1,'_');</P><P>&nbsp; output;</P><P>&nbsp; end;</P><P>&nbsp; keep year firm price volume;</P><P>&nbsp; proc print;run;</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Obs&nbsp;&nbsp;&nbsp; Year&nbsp;&nbsp;&nbsp; price&nbsp;&nbsp;&nbsp; volume&nbsp;&nbsp;&nbsp; firm</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp; 1970&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm1</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp; 1970&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm2</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp; 1970&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 84&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm3</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp; 1971&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm1</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp; 1971&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm2</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp; 1971&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm3</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp; 1972&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm1</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp; 1972&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm2</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;&nbsp;&nbsp; 1972&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 43&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm3</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp; 1973&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 44&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm1</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp;&nbsp; 1973&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm2</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12&nbsp;&nbsp;&nbsp; 1973&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm3</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13&nbsp;&nbsp;&nbsp; 1974&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm1</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14&nbsp;&nbsp;&nbsp; 1974&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm2</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp; 1974&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 86&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm3</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 16&nbsp;&nbsp;&nbsp; 1975&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 99&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm1</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17&nbsp;&nbsp;&nbsp; 1975&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm2</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18&nbsp;&nbsp;&nbsp; 1975&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 58&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm3</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 19&nbsp;&nbsp;&nbsp; 1976&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 39&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 33&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm1</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp; 1976&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm2</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21&nbsp;&nbsp;&nbsp; 1976&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm3</P></BODY></HTML> Mon, 14 Jan 2013 23:22:01 GMT Linlin 2013-01-14T23:22:01Z Change panel data format https://communities.sas.com/t5/SAS-Procedures/Change-panel-data-format/m-p/125070#M34360 <HTML><HEAD></HEAD><BODY><P>Can some one help me change the data format? I have follwing table ( my actual data would be much larger). Thanks!</P><TABLE border="0" cellpadding="0" cellspacing="0" width="662"><TBODY><TR><TD class="xl63" height="20" width="64">Year</TD><TD class="xl63" style="border-left: medium none;" width="64">Firm1 price</TD><TD class="xl63" style="border-left: medium none;" width="97">Firm1 volume</TD><TD class="xl63" style="border-left: medium none;" width="64">Year</TD><TD class="xl63" style="border-left: medium none;" width="64">Firm2 price</TD><TD class="xl63" style="border-left: medium none;" width="64">Firm2 volume</TD><TD class="xl63" style="border-left: medium none;" width="64">Year</TD><TD class="xl63" style="border-left: medium none;" width="64">Firm3 price</TD><TD class="xl63" style="border-left: medium none;" width="117">Firm3 volume</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: medium none;">1970</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">2</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">11</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">1970</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">8</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">7</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">1970</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">84</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: medium none;">1971</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">3</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">2</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">1971</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">3</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">8</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">1971</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">0</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">3</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: medium none;">1972</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">4</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">3</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">1972</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">3</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">6</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">1972</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">43</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: medium none;">1973</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">2</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">44</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">1973</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">2</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">1973</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">0</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">12</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: medium none;">1974</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">4</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">1974</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">8</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">5</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">1974</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">0</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">86</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: medium none;">1975</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">23</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">99</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">1975</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">8</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">4</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">1975</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">58</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: medium none;">1976</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">39</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">33</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">1976</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">8</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">8</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">1976</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl63" style="border-left: medium none; border-top: medium none;">63</TD></TR></TBODY></TABLE><P></P><P>I would like to change them to following format:</P><TABLE border="0" cellpadding="0" cellspacing="0" width="289"><TBODY><TR><TD class="xl65" height="20" width="64">Year</TD><TD class="xl65" style="border-left: medium none;" width="64">Firm</TD><TD class="xl65" style="border-left: medium none;" width="97">Price</TD><TD class="xl65" style="border-left: medium none;" width="64">Volume</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">1970</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">2</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">11</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">1971</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">2</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">1972</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">4</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">1973</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">2</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">44</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">1974</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">4</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">1975</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">23</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">99</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">1976</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">39</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">33</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">1970</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">2</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">8</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">7</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">1971</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">2</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">8</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">1972</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">2</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">6</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">1973</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">2</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">2</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">1974</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">2</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">8</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">5</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">1975</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">2</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">8</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">4</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">1976</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">2</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">8</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">8</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">1970</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">84</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">1971</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">0</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">1972</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">43</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">1973</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">0</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">12</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">1974</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">0</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">86</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">1975</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">58</TD></TR><TR><TD align="right" class="xl65" height="20" style="border-top: medium none;">1976</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;"><P>63</P></TD></TR></TBODY></TABLE></BODY></HTML> Mon, 14 Jan 2013 19:53:15 GMT https://communities.sas.com/t5/SAS-Procedures/Change-panel-data-format/m-p/125070#M34360 Anna_Guo 2013-01-14T19:53:15Z Re: Change panel data format https://communities.sas.com/t5/SAS-Procedures/Change-panel-data-format/m-p/125071#M34361 <HTML><HEAD></HEAD><BODY><P>Hi Anna,</P><P>how about this?;</P><P></P><P>data wide;</P><P>input Year&nbsp;&nbsp;&nbsp; Firm1_price&nbsp;&nbsp;&nbsp; Firm1_volume&nbsp;&nbsp;&nbsp; Year&nbsp;&nbsp;&nbsp; Firm2_price&nbsp;&nbsp;&nbsp; Firm2_volume&nbsp;&nbsp;&nbsp; Year&nbsp;&nbsp;&nbsp; Firm3_price&nbsp;&nbsp;&nbsp; Firm3_volume;</P><P>cards;</P><P>1970&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp;&nbsp; 1970&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp; 1970&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp; 84</P><P>1971&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp; 1971&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp; 1971&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 3</P><P>1972&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp; 1972&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp; 1972&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp; 43</P><P>1973&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp; 44&nbsp;&nbsp;&nbsp; 1973&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp; 1973&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 12</P><P>1974&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp; 1974&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp; 1974&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 86</P><P>1975&nbsp;&nbsp;&nbsp; 23&nbsp;&nbsp;&nbsp; 99&nbsp;&nbsp;&nbsp; 1975&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp; 1975&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp; 58</P><P>1976&nbsp;&nbsp;&nbsp; 39&nbsp;&nbsp;&nbsp; 33&nbsp;&nbsp;&nbsp; 1976&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp; 1976&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp; 63</P><P>;</P><P>run;</P><P></P><P>DATA long ;</P><P>&nbsp; SET wide ;</P><P>&nbsp; </P><P>&nbsp; year = year;price = firm1_Price;volume = firm1_volume;firm = 1;</P><P>&nbsp; OUTPUT ;</P><P></P><P>&nbsp; year = year; price = firm2_Price;volume = firm2_volume;firm = 2;</P><P>&nbsp; OUTPUT ;</P><P></P><P>&nbsp; year = year; price = firm3_Price;volume = firm3_volume;firm = 3;</P><P>&nbsp; OUTPUT ;</P><P></P><P>&nbsp; DROP firm1_:&nbsp; firm2_: firm3:_;</P><P>RUN;</P><P></P><P>proc sort data = long;by firm;run;</P></BODY></HTML> Mon, 14 Jan 2013 20:10:53 GMT https://communities.sas.com/t5/SAS-Procedures/Change-panel-data-format/m-p/125071#M34361 AncaTilea 2013-01-14T20:10:53Z Re: Change panel data format https://communities.sas.com/t5/SAS-Procedures/Change-panel-data-format/m-p/125072#M34362 <HTML><HEAD></HEAD><BODY><P>Anca,</P><P>Than you for your help.</P><P>I only include a simple sample with 3 firms. But I&nbsp; have over firms, the code will be too long. Also, the firm name will not be firm1 firm2, they are actual firm names. Is there any easier way to do it?</P></BODY></HTML> Mon, 14 Jan 2013 21:40:09 GMT https://communities.sas.com/t5/SAS-Procedures/Change-panel-data-format/m-p/125072#M34362 Anna_Guo 2013-01-14T21:40:09Z Re: Change panel data format https://communities.sas.com/t5/SAS-Procedures/Change-panel-data-format/m-p/125073#M34363 <HTML><HEAD></HEAD><BODY><P>borrowed Anca's data:</P><P></P><P>data wide;</P><P>input Year&nbsp;&nbsp;&nbsp; Firm1_price&nbsp;&nbsp;&nbsp; Firm1_volume&nbsp;&nbsp;&nbsp; Year&nbsp;&nbsp;&nbsp; Firm2_price&nbsp;&nbsp;&nbsp; Firm2_volume&nbsp;&nbsp;&nbsp; Year&nbsp;&nbsp;&nbsp; Firm3_price&nbsp;&nbsp;&nbsp; Firm3_volume;</P><P>cards;</P><P>1970&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp;&nbsp; 1970&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp; 1970&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp; 84</P><P>1971&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp; 1971&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp; 1971&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 3</P><P>1972&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp; 1972&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp; 1972&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp; 43</P><P>1973&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp; 44&nbsp;&nbsp;&nbsp; 1973&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp; 1973&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 12</P><P>1974&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp; 1974&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp; 1974&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 86</P><P>1975&nbsp;&nbsp;&nbsp; 23&nbsp;&nbsp;&nbsp; 99&nbsp;&nbsp;&nbsp; 1975&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp; 1975&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp; 58</P><P>1976&nbsp;&nbsp;&nbsp; 39&nbsp;&nbsp;&nbsp; 33&nbsp;&nbsp;&nbsp; 1976&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp; 1976&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp; 63</P><P>;</P><P>data long;</P><P>&nbsp; set wide;</P><P>&nbsp; array _price(*)&nbsp; firm1_price firm2_price firm3_price;</P><P>&nbsp; array _volume(*)&nbsp; firm1_volume firm2_volume firm3_volume;</P><P>&nbsp; do _n_=1 to dim(_price);</P><P>&nbsp; price=_price(_n_);</P><P>&nbsp; volume=_volume(_n_);</P><P>&nbsp; firm=scan(vname(_price(_n_)),1,'_');</P><P>&nbsp; output;</P><P>&nbsp; end;</P><P>&nbsp; keep year firm price volume;</P><P>&nbsp; proc print;run;</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Obs&nbsp;&nbsp;&nbsp; Year&nbsp;&nbsp;&nbsp; price&nbsp;&nbsp;&nbsp; volume&nbsp;&nbsp;&nbsp; firm</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp; 1970&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm1</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp; 1970&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm2</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp; 1970&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 84&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm3</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp; 1971&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm1</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp; 1971&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm2</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp; 1971&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm3</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp; 1972&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm1</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp; 1972&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm2</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;&nbsp;&nbsp; 1972&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 43&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm3</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp; 1973&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 44&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm1</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp;&nbsp; 1973&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm2</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12&nbsp;&nbsp;&nbsp; 1973&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm3</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13&nbsp;&nbsp;&nbsp; 1974&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm1</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14&nbsp;&nbsp;&nbsp; 1974&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm2</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp; 1974&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 86&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm3</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 16&nbsp;&nbsp;&nbsp; 1975&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 99&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm1</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17&nbsp;&nbsp;&nbsp; 1975&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm2</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18&nbsp;&nbsp;&nbsp; 1975&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 58&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm3</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 19&nbsp;&nbsp;&nbsp; 1976&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 39&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 33&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm1</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp; 1976&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm2</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21&nbsp;&nbsp;&nbsp; 1976&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Firm3</P></BODY></HTML> Mon, 14 Jan 2013 23:22:01 GMT https://communities.sas.com/t5/SAS-Procedures/Change-panel-data-format/m-p/125073#M34363 Linlin 2013-01-14T23:22:01Z