topic Re: To merge two columns under a single name in SAS Programming https://communities.sas.com/t5/SAS-Programming/To-merge-two-columns-under-a-single-name/m-p/603141#M174731 <P>Do you want this in a data step? And Why?</P> <P>&nbsp;</P> <P>Also, I don't understand the form of your result data. Please be more specific.</P> Mon, 11 Nov 2019 10:36:53 GMT PeterClemmensen 2019-11-11T10:36:53Z To merge two columns under a single name https://communities.sas.com/t5/SAS-Programming/To-merge-two-columns-under-a-single-name/m-p/603139#M174729 <P>&nbsp;</P><P>&nbsp;</P><P>Hi all ,</P><P>i have a dataset with two variables. i want to merge two columns into a single one such that the second column will be subgroup for the first.</P><P>&nbsp;</P><P>&nbsp;color$&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; flower$;</P><P>yellow<BR />red<BR />red&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;rose<BR />yellow<BR />white&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;jasmine<BR />white&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;lilly<BR />red<BR />white<BR />i want my final dataset to look like this ;<BR />yellow<BR />red<BR />&nbsp; &nbsp; rose<BR />white<BR />&nbsp; &nbsp; jasmine<BR />&nbsp; &nbsp; lilly</P><P>please help...</P> Mon, 11 Nov 2019 10:22:05 GMT https://communities.sas.com/t5/SAS-Programming/To-merge-two-columns-under-a-single-name/m-p/603139#M174729 AKHILA 2019-11-11T10:22:05Z Re: To merge two columns under a single name https://communities.sas.com/t5/SAS-Programming/To-merge-two-columns-under-a-single-name/m-p/603141#M174731 <P>Do you want this in a data step? And Why?</P> <P>&nbsp;</P> <P>Also, I don't understand the form of your result data. Please be more specific.</P> Mon, 11 Nov 2019 10:36:53 GMT https://communities.sas.com/t5/SAS-Programming/To-merge-two-columns-under-a-single-name/m-p/603141#M174731 PeterClemmensen 2019-11-11T10:36:53Z