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
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.