Desktop productivity for business analysts and programmers

Splitting Columns

Reply
New Contributor
Posts: 2

Splitting Columns

Hi guys

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?

Capture.PNG

Capture1.PNG

SAS Employee
Posts: 340

Re: Splitting Columns

Does Transpose Task help? Probably not.

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).

Message was edited by: Gergely Bathó

Ask a Question
Discussion stats
  • 1 reply
  • 332 views
  • 0 likes
  • 2 in conversation