You mentioned that you'd like to create a report with a cross table. How should the resulting cross table look like? Could you sketch it?
Creating needed variables:
the count of the rec_id Hover mouse over rec_id > click r-m-b > New calculation... > Type = Count
the distinct count of company_id (which I did with aggregated value and distinct) Hover mouse over company_id > click r-m-b > New calculation... > Type = Distinct Count
the sum of signals Check that measures aggregation is Sum
a signal per company_id so for company A 1 signal, B 1 signal (not 2 signals) and C 1 signal I'm not sure if I understand this. Will the result be always 1? Is there any possibility that it will be zero or something else? If it is always one then let's just create a New Calculated Item with simple 1 and set aggregation to Min or Max. If it's something else we might need utilize AggregateTableI() operator. And finally how should this result be embedded to the Cross table
Thanks for your answers, with AggregateTable it can probably do what I would want to do, unfortunately I'm on version 7.5.
I want to know whether there is a signal for a company. If I would build a query I would create an aggregated table with company_id and the sum of signals and another query to check if the signal=>1 then 1 else 0 for each company.
Instead of creating a new datasource I would want to do it in an expression. If I can't use aggregatetable, is there another way?
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.