topic Re: i have a dataset like below and need to make it like the second one in SAS Programming https://communities.sas.com/t5/SAS-Programming/i-have-a-dataset-like-below-and-need-to-make-it-like-the-second/m-p/179967#M34399 <HTML><HEAD></HEAD><BODY><P>data want(drop=btext2 btext3);</P><P>set have;</P><P>if btext2 ne ' ' and btext3=' ' then btext1=btext2;</P><P>if btext3 ne ' ' then btext1=btext3;</P><P>run;</P></BODY></HTML> Fri, 29 Aug 2014 13:46:08 GMT stat_sas 2014-08-29T13:46:08Z i have a dataset like below and need to make it like the second one https://communities.sas.com/t5/SAS-Programming/i-have-a-dataset-like-below-and-need-to-make-it-like-the-second/m-p/179964#M34396 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" width="384"><TBODY><TR><TD class="xl63" height="20" width="64">btext1</TD><TD class="xl63" width="64">btext2</TD><TD class="xl63" width="64">btext3</TD><TD class="xl63" width="64">trt1</TD><TD class="xl63" width="64">trt2</TD><TD class="xl63" width="64">trt3</TD></TR><TR><TD height="20">sample1</TD><TD></TD><TD></TD><TD>XXX</TD><TD>XXX</TD><TD>XXX</TD></TR><TR><TD height="20">sample1</TD><TD>ana1</TD><TD></TD><TD>XXX</TD><TD>XXX</TD><TD>XXX</TD></TR><TR><TD height="20">sample1</TD><TD>ana1</TD><TD>ban1</TD><TD>XXX</TD><TD>XXX</TD><TD>XXX</TD></TR><TR><TD height="20">sample1</TD><TD>ana1</TD><TD>ban2</TD><TD>XXX</TD><TD>XXX</TD><TD>XXX</TD></TR><TR><TD height="20">sample1</TD><TD>ana1</TD><TD>ban3</TD><TD>XXX</TD><TD>XXX</TD><TD>XXX</TD></TR><TR><TD height="20">sample1</TD><TD>ana1</TD><TD>ban4</TD><TD>XXX</TD><TD>XXX</TD><TD>XXX</TD></TR></TBODY></TABLE><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="256"><TBODY><TR><TD height="20" width="64">text</TD><TD class="xl65" width="64">trt1</TD><TD class="xl65" width="64">trt2</TD><TD class="xl65" width="64">trt3</TD></TR><TR><TD height="20">sample1</TD><TD>XXX</TD><TD>XXX</TD><TD>XXX</TD></TR><TR><TD height="20"> ana1</TD><TD>XXX</TD><TD>XXX</TD><TD>XXX</TD></TR><TR><TD height="20">ban1</TD><TD>XXX</TD><TD>XXX</TD><TD>XXX</TD></TR><TR><TD height="20">ban2</TD><TD>XXX</TD><TD>XXX</TD><TD>XXX</TD></TR><TR><TD height="20">ban3</TD><TD>XXX</TD><TD>XXX</TD><TD>XXX</TD></TR><TR><TD height="20">ban4</TD><TD>XXX</TD><TD>XXX</TD><TD>XXX</TD></TR></TBODY></TABLE><P>can any one help me in this?</P></BODY></HTML> Fri, 29 Aug 2014 13:09:17 GMT https://communities.sas.com/t5/SAS-Programming/i-have-a-dataset-like-below-and-need-to-make-it-like-the-second/m-p/179964#M34396 VRD 2014-08-29T13:09:17Z Re: i have a dataset like below and need to make it like the second one https://communities.sas.com/t5/SAS-Programming/i-have-a-dataset-like-below-and-need-to-make-it-like-the-second/m-p/179965#M34397 <HTML><HEAD></HEAD><BODY><P>Look up Coalescec() function and Keep/Drop statement.</P><P></P><P>Haikuo</P></BODY></HTML> Fri, 29 Aug 2014 13:15:06 GMT https://communities.sas.com/t5/SAS-Programming/i-have-a-dataset-like-below-and-need-to-make-it-like-the-second/m-p/179965#M34397 Haikuo 2014-08-29T13:15:06Z Re: i have a dataset like below and need to make it like the second one https://communities.sas.com/t5/SAS-Programming/i-have-a-dataset-like-below-and-need-to-make-it-like-the-second/m-p/179966#M34398 <HTML><HEAD></HEAD><BODY><P>Per Hai.kuo, this is covered in this post: <A _jive_internal="true" href="https://communities.sas.com/message/226275#226275">https://communities.sas.com/message/226275#226275</A></P></BODY></HTML> Fri, 29 Aug 2014 13:19:42 GMT https://communities.sas.com/t5/SAS-Programming/i-have-a-dataset-like-below-and-need-to-make-it-like-the-second/m-p/179966#M34398 RW9 2014-08-29T13:19:42Z Re: i have a dataset like below and need to make it like the second one https://communities.sas.com/t5/SAS-Programming/i-have-a-dataset-like-below-and-need-to-make-it-like-the-second/m-p/179967#M34399 <HTML><HEAD></HEAD><BODY><P>data want(drop=btext2 btext3);</P><P>set have;</P><P>if btext2 ne ' ' and btext3=' ' then btext1=btext2;</P><P>if btext3 ne ' ' then btext1=btext3;</P><P>run;</P></BODY></HTML> Fri, 29 Aug 2014 13:46:08 GMT https://communities.sas.com/t5/SAS-Programming/i-have-a-dataset-like-below-and-need-to-make-it-like-the-second/m-p/179967#M34399 stat_sas 2014-08-29T13:46:08Z