Desktop productivity for business analysts and programmers

How to create a table with actual data and percentage?

Reply
Contributor
Posts: 21

How to create a table with actual data and percentage?

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;

Valued Guide
Posts: 854

Re: How to create a table with actual data and percentage?

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

Contributor
Posts: 21

Re: How to create a table with actual data and percentage?

Hello Mark,

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

Ask a Question
Discussion stats
  • 2 replies
  • 231 views
  • 1 like
  • 2 in conversation