topic Calculated item with count if function in SAS Visual Analytics

Calculated item with count if function

DarjaJafanova — Tue, 10 Mar 2020 18:05:29 GMT

Hi!

I am a new SAS VA user.

I have the following data variables: id (records are repeated) , department (three unique ones), status (yes/no)

I need to create a calculated item to count ids if department=one specific one AND status=no.

When I use AND operator, while creating a calculated item, it returns the result as an error: the expected type is boolean.

How can I do it?

PetriRoine — Tue, 10 Mar 2020 10:29:43 GMT

Please check the Result Type is Numeric.

Best regards,

Petri

DarjaJafanova — Tue, 10 Mar 2020 18:04:06 GMT

Thank you for such a clear and quick explanation provided, I finally managed to create this calculated item. I really appreciate your help.

Kind regards,

Darja Jafanova