Calculated item with count if function

[DarjaJafanova]

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 · Accepted solution]

Hello @DarjaJafanova,

Please check the Result Type is Numeric. 

Best regards,

Petri

[DarjaJafanova]

Hi @PetriRoine,

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