Count Flag based on Conditions

rarahsghsdd — Mon, 15 Oct 2018 07:22:54 GMT

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.

Re: Count Flag based on Conditions

FredrikE — Mon, 15 Oct 2018 14:09:28 GMT

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

topic Count Flag based on Conditions in SAS Visual Analytics

Count Flag based on Conditions

Re: Count Flag based on Conditions