I am using PROC SQL on SAS.

The table on the left is the one I have. I want to create the table on the right, i.e creating as many columns as there are different values for the column 'value' (they are known and only 3 of them : "a", "b" and "c"). 

The value is the one from "col". If it doesn't exist for corresponding 'value', default value is 0. I tried using GROUP BY and CASE, but I still wound up with a table with 6 lines.

![Tables](https://i.stack.imgur.com/KhIni.png)

Thanks in advance.