Solved: Count Flag based on Conditions - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Calcite | Level 5

Calcite | Level 5

Count Flag based on Conditions

Posted 10-15-2018 03:22 AM (713 views)

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.

1 ACCEPTED SOLUTION

Accepted Solutions

Rhodochrosite | Level 12

Rhodochrosite | Level 12

Re: Count Flag based on Conditions

Posted 10-15-2018 10:09 AM (662 views) | In reply to rarahsghsdd

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

View solution in original post

1 REPLY 1

Rhodochrosite | Level 12

Rhodochrosite | Level 12

Re: Count Flag based on Conditions

Posted 10-15-2018 10:09 AM (663 views) | In reply to rarahsghsdd

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