Count Flag based on Conditions

[rarahsghsdd]

Hi SAS Community,

I am working on SAS Visual Analytics and Struck in some logic. I have a column of character which has three flag "0","1" and "DROP".

i need to count the flag based on conditions of flag. I working on Cross tab  and i need to count the "0" flag against different Shops.

I tried custom category but it wont work as measure in cross tab and i also tried this Count [_ByGroup_] (( 'New_Code'n[Raw] Contains '0' )) and other different approach but it is giving error. please suggest some solution.

Thanks.

[FredrikE · Accepted solution]

You should be able to do that with a calculated measure.

if [flag] = '0' then 1

else 0

and then use this measure in your calculations?

//Fredrik