Help using Base SAS procedures

Proc Transpose, column percentages 100% for all variables under "ALL"

Reply
Occasional Contributor
Posts: 13

Proc Transpose, column percentages 100% for all variables under "ALL"

Hi,

I'm running following code:

proc tabulate;

class year patient_sex_text;

tables (all year)*(all patient_sex_text), n pctn<all patient_sex_text>;

run;

and following is the output I'm getting:

N

PctN

All

All

2290

100.00

Patient_Sex_Text

961

100.00

Female

Male

1329

100.00

year

1644

100.00

05/10-04/11

All

Patient_Sex_Text

675

41.06

Female

Male

969

58.94

05/11-04/12

All

646

100.00

Patient_Sex_Text

286

44.27

Female

Male

360

55.73

How can I change the column percent of the yellow highlighted cells from 100 to 41.97 and 58.03?

Thanks in advance!

Ask a Question
Discussion stats
  • 0 replies
  • 157 views
  • 0 likes
  • 1 in conversation