topic Re: How to create a table with actual data and percentage? in SAS Enterprise Guide

How to create a table with actual data and percentage?

KellyW1117 — Fri, 19 Jun 2015 13:45:39 GMT

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 — Fri, 19 Jun 2015 14:09:23 GMT

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 — Fri, 19 Jun 2015 14:20:55 GMT

Hello Mark,

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