BookmarkSubscribeRSS Feed
Scott_87
Calcite | Level 5

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

1 REPLY 1
gergely_batho
SAS Employee

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ó

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 2569 views
  • 0 likes
  • 2 in conversation