topic Re: Basic Statistics with DataFlux in SAS Data Management

Basic Statistics with DataFlux

margautz — Fri, 05 Feb 2016 09:57:41 GMT

Hello,

I am new in the community and I am new using DataFlux.

I am wondering if it possible to create a DataJob with basics statistics on row and not on column.

I try to explain better my idea with an example:

I have three columns: family, products, price

family	product	price
AAA	x	1000
AAA	y	1500
BBB	z	100
AAA	w	1000
BBB	d	2000
CCC	f	500
CCC	e

and I would like to have Basic Statistics like

family	max	min	avg	null_value
AAA	1500	1000	1166	0
BBB	2000	100	1050	0
CCC	500	500	500	1

beacuse if I do a simple "Basic Statistics" Node on 'price' column, I will obtain

max	2000
min	500
avg	1016
null	1

Thank you for your time and help!

Margherita

Re: Basic Statistics with DataFlux

LinusH — Fri, 05 Feb 2016 12:07:19 GMT

Don't know about the possibilities in data flux. What do you want to do with this report?
If you have the possibility to use SAS on your data, this is a simple PROC MEANS (or Summary Statistics task from Enterprise Guide/Addin 4 MS Office).

Re: Basic Statistics with DataFlux

margautz — Fri, 05 Feb 2016 16:35:32 GMT

Thank you Linus for your replay!

That is the answer that I was expecting 🙂 It was a report that one colleague ask to me, but I would like to be sure.

Thank you again