The SAS Output Delivery System and reporting techniques

List Data task - issue with sub totals and totals

Reply
N/A
Posts: 0

List Data task - issue with sub totals and totals

Hi all

I want to use a list data task in EG project to develop a report

Fields are
BranchNo, Supplier, OrderType, OrderNo, OrderCost, Discount

Grouped on BranchNo, Supplier, OrderType, OrderNo

Sub totals for OrderCost, Discount (for each BranchNo, Supplier, OrderType, OrderNo)

Grand Total for OrderCost, Discount (for each BranchNo, Supplier)

How can we do it through List data
SAS Employee
Posts: 174

Re: List Data task - issue with sub totals and totals

Posted in reply to deleted_user
This question is appropriate for the SAS Enterprise Guide user forum:

http://support.sas.com/forums/forum.jspa?forumID=10

-- David Kelley, SAS
SAS Super FREQ
Posts: 8,866

Re: List Data task - issue with sub totals and totals

Posted in reply to deleted_user
Hi:
The List data task performs both subtotals and grand-totals on the same variables. In order to get subtotals on one set of variables and grandtotals on different variables in your final output, you would either have to use PROC REPORT or a DATA Step program.

Of the two choices, I would consider PROC REPORT to be the easier choice. There is no task, at this time, for PROC REPORT. So, you would have to use PROC REPORT in a code node to create this report.

For help with PROC REPORT, there is an excellent section in the documentation entitled, "How PROC REPORT Builds a Report". In addition if you Google for SUGI or SGF papers on PROC REPORT, you will find a lot of references. In addition for help with PROC REPORT and submitting code through an EG code node, your best bet might be to contact Tech Support.

cynthia
Ask a Question
Discussion stats
  • 2 replies
  • 121 views
  • 0 likes
  • 3 in conversation