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

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

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
  • 2470 views
  • 0 likes
  • 2 in conversation