topic Re: 2x2 Frequency Table - Add Totals in SAS Programming

2x2 Frequency Table - Add Totals

amarikow57 — Tue, 03 Nov 2020 17:39:42 GMT

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?

Re: 2x2 Frequency Table - Add Totals

PaigeMiller — Tue, 03 Nov 2020 17:44:58 GMT

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;

Re: 2x2 Frequency Table - Add Totals

amarikow57 — Tue, 03 Nov 2020 17:58:17 GMT

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

Re: 2x2 Frequency Table - Add Totals

PaigeMiller — Tue, 03 Nov 2020 18:04:51 GMT

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

Re: 2x2 Frequency Table - Add Totals

amarikow57 — Tue, 03 Nov 2020 18:18:21 GMT

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