BookmarkSubscribeRSS Feed
pcfriendly
Calcite | Level 5

Hi

I'm using the Tranpose task & am having some trouble with getting a field to appear where the 'Column' values of an Excel Pivot would be.

I'm using the Excel pivot analogy to explain what I need & make my question easier to understand.

When I start the task I select my graph icon that I want to transpose & I get the dialogue box with my table fields in the 'Name' area.

I drag each field over to the 'Task Roles' area to create the Transposed table.

I have my 'Group Analysis by' fields - this would be the 'Row' area of an Excel pivot - this presents OK.

I now want to add my calculations & I add them to the 'Transpose variables' area which would be the 'Data' area of a pivot.

The issue is I have a field that I want place in the 'Column' area of a pivot but wherever I place this field, 'Copy Variables', New Column Names' or wherever, I can't get this field to split the calculations across the top of the table in the 'Column' area of a pivot.

Hope my Excel Pivot analogy makes some sense.

Can anyone help me get the right? Cheers  

2 REPLIES 2
pcfriendly
Calcite | Level 5

OR maybe I'm using the wrong task???

If so, can anyone suggest how to change the table to summarise the data as one field as a list down the left side of the table eg East, West, North, South & across the top the Salespersons by names, Bill, Fred, Simon etc.

Now the Sales $ should populate the table for Bills sales in whichever region.

I'm trying a List table with one way frequency, any suggests?

pcfriendly
Calcite | Level 5

Got it,

The Summary tables task does this in case anyone wants to know.

Under Tasks >> Describe >> Summary tables Wizard. in Enterprise Guide 4.3.

Cheers

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 2306 views
  • 0 likes
  • 1 in conversation