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.
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
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
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.