topic Re: Merging observations under one variable name in SAS Programming https://communities.sas.com/t5/SAS-Programming/Merging-observations-under-one-variable-name/m-p/273844#M54581 <P>Use the COALESCEC() funtion.&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 30 May 2016 02:45:16 GMT Reeza 2016-05-30T02:45:16Z Merging observations under one variable name https://communities.sas.com/t5/SAS-Programming/Merging-observations-under-one-variable-name/m-p/273842#M54580 <P>Hi All,</P> <P>I have the following data set where I want to bring all variables under one new variable. can someone please tell me how do i do that. Thanks.</P> <P>&nbsp;</P> <P>ID &nbsp; &nbsp;Summer &nbsp; Fall &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Spring</P> <P>101 Math &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P> <P>101 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;English</P> <P>101 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Physics</P> <P>&nbsp;</P> <P>Expected Output:</P> <P>ID &nbsp; &nbsp;Summer &nbsp; Fall &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Spring &nbsp; &nbsp;All_Courses</P> <P>101 Math &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<SPAN>Math</SPAN> &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P> <P>101 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;English &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<SPAN>English</SPAN></P> <P>101 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Physics &nbsp;&nbsp;<SPAN>Physics</SPAN></P> <P>&nbsp;</P> Mon, 30 May 2016 02:40:32 GMT https://communities.sas.com/t5/SAS-Programming/Merging-observations-under-one-variable-name/m-p/273842#M54580 mlogan 2016-05-30T02:40:32Z Re: Merging observations under one variable name https://communities.sas.com/t5/SAS-Programming/Merging-observations-under-one-variable-name/m-p/273844#M54581 <P>Use the COALESCEC() funtion.&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 30 May 2016 02:45:16 GMT https://communities.sas.com/t5/SAS-Programming/Merging-observations-under-one-variable-name/m-p/273844#M54581 Reeza 2016-05-30T02:45:16Z Re: Merging observations under one variable name https://communities.sas.com/t5/SAS-Programming/Merging-observations-under-one-variable-name/m-p/273845#M54582 <PRE><CODE class=" language-sas">All_Courses = cats(Summer, Fall, Spring);</CODE></PRE> Mon, 30 May 2016 02:47:08 GMT https://communities.sas.com/t5/SAS-Programming/Merging-observations-under-one-variable-name/m-p/273845#M54582 SASKiwi 2016-05-30T02:47:08Z Re: Merging observations under one variable name https://communities.sas.com/t5/SAS-Programming/Merging-observations-under-one-variable-name/m-p/273918#M54597 <P>This looks&nbsp;like some&nbsp;made up sample data. What is the underlying requirement?</P> <P>From a data perspective, I would rather see the following outcome&nbsp;(after transposing):</P> <P>&nbsp;</P> <P><STRONG>ID &nbsp; &nbsp;Term &nbsp; &nbsp; &nbsp; Course</STRONG></P> <P>101 Summer &nbsp; <SPAN>Math</SPAN> &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P> <P>101 Spring &nbsp; &nbsp; &nbsp;<SPAN>English</SPAN></P> <P>101&nbsp;Fall &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<SPAN>Physics</SPAN></P> Mon, 30 May 2016 14:02:09 GMT https://communities.sas.com/t5/SAS-Programming/Merging-observations-under-one-variable-name/m-p/273918#M54597 LinusH 2016-05-30T14:02:09Z