topic Running counts in SAS Dataflux Data Management Studio 2.5 in SAS Data Management

Running counts in SAS Dataflux Data Management Studio 2.5

TRACESA — Fri, 13 Apr 2018 18:22:49 GMT

Hello,

I've been creating complex jobs in SAS Dataflux Data Management Studio for a few years now and am having trouble creating one that should be very simple. Essentially I want to make a job where a manager who does not know how to code can query a database strictly for counts and adjust basic where clause parameters. The output should be something visual. Any help is greatly appreciated!

Re: Running counts in SAS Dataflux Data Management Studio 2.5

TomKari — Fri, 13 Apr 2018 19:47:22 GMT

I'm not sure that's the best tool to use for exploratory data analysis; I'm not surprised you're finding it challenging.

If I had to meet a requirement like that, I would reach for either Enterprise Guide or SAS Studio.

Tom

Re: Running counts in SAS Dataflux Data Management Studio 2.5

audrey — Sat, 14 Apr 2018 08:45:46 GMT

Hi,

Did you try to use a Data Input node, then a Data Validation (for your WHERE clauses) and HTML Report output?

Audrey