topic Re: how to make two rows of data with same ID to have same value when one of them has blank in SAS Programming https://communities.sas.com/t5/SAS-Programming/how-to-make-two-rows-of-data-with-same-ID-to-have-same-value/m-p/768179#M243628 <PRE><CODE class=" language-sas"> data have; input ID a b c d e f; cards; 1 1 2 3 4 5 6 1 2 . 4 . 6 . ; data want; update have(obs=0) have; by id; output; run; </CODE></PRE> <P>&nbsp;</P> <DIV class="branch"> <DIV> <DIV align="center"> <TABLE class="table" summary="Procedure Print: Data Set WORK.WANT" frame="box" rules="all" cellspacing="0" cellpadding="5"> <THEAD> <TR> <TH class="r header" scope="col">ID</TH> <TH class="r header" scope="col">a</TH> <TH class="r header" scope="col">b</TH> <TH class="r header" scope="col">c</TH> <TH class="r header" scope="col">d</TH> <TH class="r header" scope="col">e</TH> <TH class="r header" scope="col">f</TH> </TR> </THEAD> <TBODY> <TR> <TD class="r data">1</TD> <TD class="r data">1</TD> <TD class="r data">2</TD> <TD class="r data">3</TD> <TD class="r data">4</TD> <TD class="r data">5</TD> <TD class="r data">6</TD> </TR> <TR> <TD class="r data">1</TD> <TD class="r data">2</TD> <TD class="r data">2</TD> <TD class="r data">4</TD> <TD class="r data">4</TD> <TD class="r data">6</TD> <TD class="r data">6</TD> </TR> </TBODY> </TABLE> </DIV> </DIV> </DIV> Thu, 16 Sep 2021 18:22:58 GMT novinosrin 2021-09-16T18:22:58Z how to make two rows of data with same ID to have same value when one of them has blank https://communities.sas.com/t5/SAS-Programming/how-to-make-two-rows-of-data-with-same-ID-to-have-same-value/m-p/768174#M243624 <TABLE border="1"><TBODY><TR><TD>ID</TD><TD>a</TD><TD>b</TD><TD>c</TD><TD>d</TD><TD>e</TD><TD>f</TD></TR><TR><TD>1</TD><TD>1</TD><TD>2</TD><TD>3</TD><TD>4</TD><TD>5</TD><TD>6</TD></TR><TR><TD>1</TD><TD>2</TD><TD>&nbsp;</TD><TD>4</TD><TD>&nbsp;</TD><TD>6</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want the result be:</P><TABLE border="1"><TBODY><TR><TD>ID</TD><TD>a</TD><TD>b</TD><TD>c</TD><TD>d</TD><TD>e</TD><TD>f</TD></TR><TR><TD>1</TD><TD>1</TD><TD>2</TD><TD>3</TD><TD>4</TD><TD>5</TD><TD>6</TD></TR><TR><TD>1</TD><TD>2</TD><TD>2</TD><TD>4</TD><TD>4</TD><TD>6</TD><TD>6</TD></TR></TBODY></TABLE> Thu, 16 Sep 2021 17:59:37 GMT https://communities.sas.com/t5/SAS-Programming/how-to-make-two-rows-of-data-with-same-ID-to-have-same-value/m-p/768174#M243624 ttqkroe 2021-09-16T17:59:37Z Re: how to make two rows of data with same ID to have same value when one of them has blank https://communities.sas.com/t5/SAS-Programming/how-to-make-two-rows-of-data-with-same-ID-to-have-same-value/m-p/768179#M243628 <PRE><CODE class=" language-sas"> data have; input ID a b c d e f; cards; 1 1 2 3 4 5 6 1 2 . 4 . 6 . ; data want; update have(obs=0) have; by id; output; run; </CODE></PRE> <P>&nbsp;</P> <DIV class="branch"> <DIV> <DIV align="center"> <TABLE class="table" summary="Procedure Print: Data Set WORK.WANT" frame="box" rules="all" cellspacing="0" cellpadding="5"> <THEAD> <TR> <TH class="r header" scope="col">ID</TH> <TH class="r header" scope="col">a</TH> <TH class="r header" scope="col">b</TH> <TH class="r header" scope="col">c</TH> <TH class="r header" scope="col">d</TH> <TH class="r header" scope="col">e</TH> <TH class="r header" scope="col">f</TH> </TR> </THEAD> <TBODY> <TR> <TD class="r data">1</TD> <TD class="r data">1</TD> <TD class="r data">2</TD> <TD class="r data">3</TD> <TD class="r data">4</TD> <TD class="r data">5</TD> <TD class="r data">6</TD> </TR> <TR> <TD class="r data">1</TD> <TD class="r data">2</TD> <TD class="r data">2</TD> <TD class="r data">4</TD> <TD class="r data">4</TD> <TD class="r data">6</TD> <TD class="r data">6</TD> </TR> </TBODY> </TABLE> </DIV> </DIV> </DIV> Thu, 16 Sep 2021 18:22:58 GMT https://communities.sas.com/t5/SAS-Programming/how-to-make-two-rows-of-data-with-same-ID-to-have-same-value/m-p/768179#M243628 novinosrin 2021-09-16T18:22:58Z