Desktop productivity for business analysts and programmers

Transpose task in SAS EG 4.3

Reply
Frequent Contributor
Posts: 80

Transpose task in SAS EG 4.3

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  

Frequent Contributor
Posts: 80

Re: Transpose task in SAS EG 4.3

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?

Frequent Contributor
Posts: 80

Re: Transpose task in SAS EG 4.3

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

Ask a Question
Discussion stats
  • 2 replies
  • 1299 views
  • 0 likes
  • 1 in conversation