SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Sum Group By using SAS DI Transformation

Reply
Contributor
Posts: 36

Sum Group By using SAS DI Transformation

Can anyone please help me in finding out the best suitable transformation to implement group by on multiple fields with Summing up few of them? used EXTRACT transformation but its not giving proper result.

Super User
Posts: 5,257

Re: Sum Group By using SAS DI Transformation

Not really sure what you try to implement.

First, try to code first in SQL outside DIS.

 

Attach sample input data, and desired output, and perhaps what you've tried that's not working.

Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 282 views
  • 0 likes
  • 2 in conversation