topic Re: Splitting Columns in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Splitting-Columns/m-p/163758#M12609 <HTML><HEAD></HEAD><BODY><P>Does Transpose Task help? Probably not.</P><P>A workarond: with a Query Builder create a new variable, which is the concatenation of 2 or more variables. Than you can use the new variable in one of the tasks (Split or Transpose).</P><P></P><P>Message was edited by: Gergely Bathó</P></BODY></HTML> Mon, 29 Sep 2014 12:11:41 GMT gergely_batho 2014-09-29T12:11:41Z Splitting Columns https://communities.sas.com/t5/SAS-Enterprise-Guide/Splitting-Columns/m-p/163757#M12608 <HTML><HEAD></HEAD><BODY><P>Hi guys</P><P>Im in the process of starting to use EG now, in the past JMP was our tool of choice. What im noticing is that in JMP, splitting a datasets columns was pretty simple and was capable of splitting by multiple columns (like the screenshot below). But in EG it seems you can only split by one column (see last screenshot), im wondering is there anyway around this as I have to do this on a daily basis?</P><P><IMG alt="Capture.PNG" class="jive-image-thumbnail jive-image" height="380" src="https://communities.sas.com/legacyfs/online/7500_Capture.PNG" style="height: 380px; width: 529.411764705882px;" width="529" /></P><P><IMG alt="Capture1.PNG" class="jive-image" src="https://communities.sas.com/legacyfs/online/7501_Capture1.PNG" /></P></BODY></HTML> Mon, 29 Sep 2014 10:15:15 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Splitting-Columns/m-p/163757#M12608 Scott_87 2014-09-29T10:15:15Z Re: Splitting Columns https://communities.sas.com/t5/SAS-Enterprise-Guide/Splitting-Columns/m-p/163758#M12609 <HTML><HEAD></HEAD><BODY><P>Does Transpose Task help? Probably not.</P><P>A workarond: with a Query Builder create a new variable, which is the concatenation of 2 or more variables. Than you can use the new variable in one of the tasks (Split or Transpose).</P><P></P><P>Message was edited by: Gergely Bathó</P></BODY></HTML> Mon, 29 Sep 2014 12:11:41 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Splitting-Columns/m-p/163758#M12609 gergely_batho 2014-09-29T12:11:41Z