topic Dataflux add a Grand total row to an excel output file in SAS Programming

Dataflux add a Grand total row to an excel output file

beamer108 — Thu, 18 Mar 2021 16:13:48 GMT

I have a datajob that writes output to an excel file. It shows multiple rows which include fields like total_sales, total_income etc. Is it possible to create a final summary row to the output that would give me a grand total for each of these columns?

Re: Dataflux add a Grand total row to an excel output file

ChrisNZ — Thu, 18 Mar 2021 22:48:37 GMT

Yes it is.

Please show us how you write to Excel.

Re: Dataflux add a Grand total row to an excel output file

beamer108 — Fri, 19 Mar 2021 11:06:25 GMT

I first write my data output to a "txt file output" node then join it to a "data target (insert)" node.

Re: Dataflux add a Grand total row to an excel output file

Cynthia_sas — Fri, 19 Mar 2021 16:24:23 GMT

Hi:
I'm not going to move this since someone has already posted here. However, most of the DataFlux and DI Studio questions are posted in this Forum: https://communities.sas.com/t5/Data-Management/ct-p/data_management and so in the future, you might want to ask your DataFlux questions there.
Cynthia

Re: Dataflux add a Grand total row to an excel output file

beamer108 — Fri, 19 Mar 2021 17:18:31 GMT

Thank you Cynthia, I wasn't sure where to post it.