topic Re: how to transpose row into columns in SAS Programming https://communities.sas.com/t5/SAS-Programming/how-to-transpose-row-into-columns/m-p/721751#M223740 <P>Column WK1 is either a date or not, and either uses a date format or not.</P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 25 Feb 2021 03:15:51 GMT ChrisNZ 2021-02-25T03:15:51Z how to transpose row into columns https://communities.sas.com/t5/SAS-Programming/how-to-transpose-row-into-columns/m-p/721655#M223703 <P>Dear expert.</P><P>I am trying to transpose the date values into column headers.</P><P>here is sample data.</P><P>data have;<BR />input state $ regid date:MMDDYY10.;<BR />datalines;<BR />DC 456789 2/1/2021<BR />DC 450231 2/1/2021<BR />DC 450556 2/2/2021<BR />DC 453246 2/3/2021<BR />DC 458237 2/4/2021<BR />VA 567894 2/8/2021<BR />VA 560233 2/10/2021<BR />VA 560654 2/11/2021<BR />VA 563642 2/11/2021<BR />VA 568732 2/11/2021<BR />CA 678945 2/15/2021<BR />CA 670231 2/15/2021<BR />CA 670556 2/18/2021<BR />CA 673246 2/18/2021<BR />CA 678237 2/18/2021<BR />NM 178945 2/22/2021<BR />NM 170231 2/22/2021<BR />NM 170556 2/26/2021<BR />NM 173246 2/26/2021<BR />NM 178237 2/26/2021<BR />run;</P><P>&nbsp;sample output template:</P><TABLE><TBODY><TR><TD>&nbsp;</TD><TD>Wk1</TD><TD>WKL2</TD><TD>WK3</TD><TD>WK4</TD></TR><TR><TD>State</TD><TD>2/1/2021</TD><TD>2/2/2021</TD><TD>2/3/2021</TD><TD>2/4/2021</TD><TD>2/5/2021</TD><TD>2/8/2021</TD><TD>2/9/2021</TD><TD>2/10/2021</TD><TD>2/11/2021</TD><TD>2/12/2021</TD><TD>2/15/2021</TD><TD>2/16/2021</TD><TD>2/17/2021</TD><TD>2/18/2021</TD><TD>2/19/2021</TD><TD>2/22/2021</TD><TD>2/23/2021</TD><TD>2/24/2021</TD><TD>2/25/2021</TD><TD>2/26/2021</TD></TR><TR><TD>DC</TD><TD>456789</TD><TD>450556</TD><TD>453246</TD><TD>458237</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><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>DC</TD><TD>450231</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><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>VA</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>567894</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>560233</TD><TD>560654</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>VA</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>563642</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>CA</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>678945</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>670556</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>CA</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>670231</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>678237</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>NM</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><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>178945</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>170556</TD></TR></TBODY></TABLE><P>&nbsp;</P> Wed, 24 Feb 2021 18:23:14 GMT https://communities.sas.com/t5/SAS-Programming/how-to-transpose-row-into-columns/m-p/721655#M223703 tekish 2021-02-24T18:23:14Z Re: how to transpose row into columns https://communities.sas.com/t5/SAS-Programming/how-to-transpose-row-into-columns/m-p/721751#M223740 <P>Column WK1 is either a date or not, and either uses a date format or not.</P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 25 Feb 2021 03:15:51 GMT https://communities.sas.com/t5/SAS-Programming/how-to-transpose-row-into-columns/m-p/721751#M223740 ChrisNZ 2021-02-25T03:15:51Z Re: how to transpose row into columns https://communities.sas.com/t5/SAS-Programming/how-to-transpose-row-into-columns/m-p/721758#M223743 <P>That looks like a REPORT and not a dataset. So use PROC REPORT.</P> <PRE><CODE class=" language-sas">proc report data=have; column state regid,date; define state/ group order=data; define date / across 'week'; define regid / ' '; run;</CODE></PRE> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 999px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/55145iAF8308F22101ACE1/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span></P> Thu, 25 Feb 2021 04:36:33 GMT https://communities.sas.com/t5/SAS-Programming/how-to-transpose-row-into-columns/m-p/721758#M223743 Tom 2021-02-25T04:36:33Z Re: how to transpose row into columns https://communities.sas.com/t5/SAS-Programming/how-to-transpose-row-into-columns/m-p/721971#M223809 <P>Hi Tom,</P><P>Thanks for your quick reply. you right it is&nbsp;<SPAN>a REPORT. How Do I Change the header for the Date column values?</SPAN></P><P><SPAN>week1:02/01/2021 until 02/05/2021</SPAN></P><P><SPAN>week2:02/08/2021 until 02/12/2021</SPAN></P><P><SPAN>week3:02/15/2021 until 02/19/2021</SPAN></P><P><SPAN>week4:02/22/2021 until 02/26/2021</SPAN></P><TABLE><TBODY><TR><TD><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Week1</P></TD></TR><TR><TD><P>02/01/2021</P></TD><TD><P>02/02/2021</P></TD><TD><P>02/03/2021</P></TD><TD><P>02/04/2021</P></TD><TD><P>02/05/2021</P></TD></TR><TR><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P> Thu, 25 Feb 2021 19:13:26 GMT https://communities.sas.com/t5/SAS-Programming/how-to-transpose-row-into-columns/m-p/721971#M223809 tekish 2021-02-25T19:13:26Z