https://communities.sas.com/t5/SAS-Programming/combine-rows/m-p/679671#M205258 Thank you once again <a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/31304">@PeterClemmensen</a>.<BR /><BR />Have a nice day! Thu, 27 Aug 2020 09:42:29 GMT Mikkel_madsen 2020-08-27T09:42:29Z https://communities.sas.com/t5/SAS-Programming/combine-rows/m-p/679666#M205255 <P>Hi,</P> <P>&nbsp;</P> <P>I have trouble with a simple task. I have the following to variables:</P> <P>&nbsp;</P> <P>POSeast&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; POS_east</P> <P>4.234561&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.</P> <P>3.123546&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.</P> <P>3.446732&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.</P> <P>3.456573&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.&nbsp;</P> <P>3.732464&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.</P> <P>3.879823&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.</P> <P>.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3.452245</P> <P>.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3.123457</P> <P>.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3.456246</P> <P>.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3.673245</P> <P>.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3.123657</P> <P>&nbsp;</P> <P>I have thousands of observations. How do I combine them to one single variable:</P> <P>&nbsp;</P> <P>Newposeast</P> <P>4.234561&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P> <P>3.123546&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P> <P>3.446732&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P> <P>3.456573&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P> <P>3.732464&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P> <P>3.879823&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P> <P>3.452245</P> <P>3.123457</P> <P>3.456246</P> <P>3.673245</P> <P>3.123657</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Thank you!&nbsp;</P> Thu, 27 Aug 2020 08:54:52 GMT https://communities.sas.com/t5/SAS-Programming/combine-rows/m-p/679666#M205255 Mikkel_madsen 2020-08-27T08:54:52Z https://communities.sas.com/t5/SAS-Programming/combine-rows/m-p/679669#M205256 <PRE><CODE class=" language-sas">data have; input POSeast POS_east; datalines; 4.234561 . 3.123546 . 3.446732 . 3.456573 . 3.732464 . 3.879823 . . 3.452245 . 3.123457 . 3.456246 . 3.673245 . 3.123657 ; data want; set have; Newposeast = coalesce(POSeast, POS_east); keep Newposeast; run;</CODE></PRE> Thu, 27 Aug 2020 09:10:15 GMT https://communities.sas.com/t5/SAS-Programming/combine-rows/m-p/679669#M205256 PeterClemmensen 2020-08-27T09:10:15Z https://communities.sas.com/t5/SAS-Programming/combine-rows/m-p/679671#M205258 Thank you once again <a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/31304">@PeterClemmensen</a>.<BR /><BR />Have a nice day! Thu, 27 Aug 2020 09:42:29 GMT https://communities.sas.com/t5/SAS-Programming/combine-rows/m-p/679671#M205258 Mikkel_madsen 2020-08-27T09:42:29Z