2x2 Frequency Table - Add Totals

[amarikow57]

Hello,

I am new to SAS, so this is probably a simple solution. Attached is the PROC CONTENTS of my data and the results from PROC FREQ. Below is the code I used.

proc freq data=Homework.inpatientAmountoregon;
	table bene_sex_ident_cd*inpatientTotalAmount;
title "Gender Total Payments";
run;

I don't really care about the frequency within each interval of inpatientTotalAmount. I only want the total payments made for each gender. How would I go about making a 2x2 table to display that? 

[PaigeMiller]

I only want the total payments made for each gender.

How about this?

proc freq data=Homework.inpatientAmountoregon;
	table bene_sex_ident_cd;
title "Gender Total Payments";
run;

[amarikow57]

Wouldn't that only get me the number of males and females in dataset?

[PaigeMiller · Accepted solution]

proc freq data=Homework.inpatientAmountoregon;
	table bene_sex_ident_cd;
    weight inpatientTotalAmount;
title "Gender Total Payments";
run;

[amarikow57]

Yes! I figured out how to do it with PROC SUMMARY too, and the numbers match up. Thank you!