Showing results for 
Search instead for 
Did you mean: 

SAS Proc Freq within DataRobot?

SAS Proc Freq within DataRobot?

Using DataRobot as an efficient way to store + manipulate data. My background is in the SAS platform, and even others such as SPSS. My question: Is it possible to simply do something like a Proc FREQ within the DataRobot platform? I was thinking that there may be a fairly easy command from within a Spark SQL section? But maybe that is strictly used for SQL stuff?

Labels (1)
0 Kudos
2 Replies

TY so much. Works perfectly!

0 Kudos



Yes, you are correct, there are easy command within Spark SQL, as Spark SQL has not much differences with other SQL languages. 
This command is GROUP BY. To calculate frequency by column your command will something like:

SELECT id, count(*) as Frequency FROM table GROUP BY id
0 Kudos