https://communities.sas.com/t5/SAS-Programming/SAS-programming-question/m-p/26346#M4687 Check this post/reply:<BR /> <BR /> <A href="http://support.sas.com/forums/thread.jspa?threadID=9901" target="_blank">http://support.sas.com/forums/thread.jspa?threadID=9901</A><BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Sun, 23 May 2010 22:08:29 GMT sbb 2010-05-23T22:08:29Z https://communities.sas.com/t5/SAS-Programming/SAS-programming-question/m-p/26345#M4686 I've a dataset similar to:<BR /> A B C D<BR /> a1 b1 c1 .<BR /> a1 b1 c2 .<BR /> a1 b1 c3 .<BR /> a1 b1 c4 123<BR /> a1 b2 c1 .<BR /> a1 b2 c2 .<BR /> a1 b2 c3 .<BR /> a1 b2 c4 456<BR /> <BR /> <BR /> I am looking for output similar to :<BR /> <BR /> A B C D<BR /> a1 b1 c1 123<BR /> a1 b1 c2 123<BR /> a1 b1 c3 123<BR /> a1 b1 c4 123<BR /> a1 b2 c1 456<BR /> a1 b2 c2 456<BR /> a1 b2 c3 456<BR /> a1 b2 c4 456<BR /> <BR /> Thanks in advance for helping me in coding this. Sun, 23 May 2010 20:15:46 GMT https://communities.sas.com/t5/SAS-Programming/SAS-programming-question/m-p/26345#M4686 deleted_user 2010-05-23T20:15:46Z https://communities.sas.com/t5/SAS-Programming/SAS-programming-question/m-p/26346#M4687 Check this post/reply:<BR /> <BR /> <A href="http://support.sas.com/forums/thread.jspa?threadID=9901" target="_blank">http://support.sas.com/forums/thread.jspa?threadID=9901</A><BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Sun, 23 May 2010 22:08:29 GMT https://communities.sas.com/t5/SAS-Programming/SAS-programming-question/m-p/26346#M4687 sbb 2010-05-23T22:08:29Z