06-19-2015 09:45 AM
Sorry to bother those who had seen my post earlier. I have attached my post several days ago and hope to get help.
I still have no idea how to make a matrix-shape table based on the data I have.
Here is the code I used to flag which CCs each ID has. I don't know what the next step is.
PROC TRANSPOSE DATA=idcc
BY IDs ;
06-19-2015 10:09 AM
Last things first: Your title is awesome. 'a table with actual data' made me smile, I did not lol but I did smile.
Second things second. If you provide the data you have, followed by the outcome you are hoping for you are much more likely to get a helpful answer.