SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Basic Statistics with DataFlux

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 17
Accepted Solution

Basic Statistics with DataFlux

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

 

familyproductprice
AAAx1000
AAAy1500
BBBz100
AAAw1000
BBBd2000
CCCf500
CCCe 

 

 

and I would like to have Basic Statistics like

 

familymaxminavgnull_value
AAA1500100011660
BBB200010010500
CCC5005005001

 

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

 

max2000
min500
avg1016
null1

 

 

Thank you for your time and help!

Margherita

 


Accepted Solutions
Solution
‎02-05-2016 11:35 AM
Super User
Posts: 5,431

Re: Basic Statistics with DataFlux

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).
Data never sleeps

View solution in original post


All Replies
Solution
‎02-05-2016 11:35 AM
Super User
Posts: 5,431

Re: Basic Statistics with DataFlux

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).
Data never sleeps
Occasional Contributor
Posts: 17

Re: Basic Statistics with DataFlux

Thank you Linus for your replay!

 

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

 

Thank you again

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 281 views
  • 0 likes
  • 2 in conversation