group rows into different datasets by condition.. ( picture attached) : 
favorite
I need to create 7 datasets ((local, web, call, local&call, local&web, call&web, all ) depending on if the customer has used a channel from the below sample data.


[please see this picture for more details on the sample table][1]

So if a customer has used all three channels in one instance and in the other instance he just uses either of them, then that row with Customer=1 should go to the'all' dataset. Similarly for 3, if he has used local and web in one instance and just web in another instance, then it should go to the 'local&web' dataset.

Customer IDs should not be duplicated in other dataset i.e. customer 1 can belong to wither one of the dataset only.

I am stuck with this, can anyone give me a snippet of either sas or sql code to proceed further.

Thanks !


  [1]: http://i.stack.imgur.com/OAIMp.png