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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.