How to create a table with actual data and percentage?

[KellyW1117]

Hello everyone,

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

  OUT=WORK.idcc1

  PREFIX=CC

  NAME=Source

  LABEL=Label;

  BY IDs ;

  ID CC;

  VAR HCC;

QUIT;

[Steelers_In_DC]

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.

Cheers

[KellyW1117]

Hello Mark,

Thanks for the quick reply. I have attached a link which fully explains which tables/results I'm hoping for.