SAS Proc Freq within DataRobot?

[zsfeinstein@yahoo.com]

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?

[Bogdan Tsal-Tsalko · Accepted solution]

Hi!

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

[zsfeinstein@yahoo.com · Accepted solution]

TY so much. Works perfectly!