topic Re: Calculate mean median IQR sum sumpct in Statistical Procedures

Calculate mean median IQR sum sumpct

ybz12003 — Thu, 22 Sep 2022 17:45:02 GMT

Hello,

I have a dataset shown below. I would like to get mean/median/IQR/sum/sum_percent in each "Lab/Pham/Diag" group, excluding the missing values. Please let me know how to approach, thanks.

data Bill;  
	length caseid $10 Lab 3 Pham 4 Diag 4; 
	infile datalines delimiter=','; 
	input Caseid Lab Pham Diag;  
	datalines;                     
	EC1R00002,200,6000,5500,
	AC1R00012,100, , 7000,
	EC1R00013,50,3800, ,
	BH1U00185, ,4600,1500,
	EN1R01252,700,9000,2900,
	CY1K01251, ,500, , 
	BH1U99185,900,5600,8500,
	OP1R00252,360,9900,8900,
	PCHK01401,770,, , 
;

Re: Calculate mean median IQR sum sumpct

PaigeMiller — Thu, 22 Sep 2022 18:01:24 GMT

I don't know what you mean by "sum_percent"

Otherwise, this gets the job done:

proc means data=bill stackodsoutput mean median p25 p75 sum;
    ods output summary=summary;
    var lab pham diag;
run;

You will have to compute the IQR from the p75 and p25 values.

Re: Calculate mean median IQR sum sumpct

ybz12003 — Thu, 22 Sep 2022 18:07:32 GMT

Lab (Sum_%)= Lab_sum / [Sum(Lab+Pha+Dia)]

Re: Calculate mean median IQR sum sumpct

PaigeMiller — Thu, 22 Sep 2022 18:14:29 GMT

@ybz12003 wrote:
Lab (Sum_%)= Lab_sum / [Sum(Lab+Pha+Dia)]

I'm not sure what this means. From the data you posted, the sums are

LAB 3080

PHAM 39400

Diag 34300

So are you asking for code to compute 3080/(3080+39400+34300) ??

Re: Calculate mean median IQR sum sumpct

ybz12003 — Thu, 22 Sep 2022 18:17:04 GMT

Yes

Re: Calculate mean median IQR sum sumpct

PaigeMiller — Thu, 22 Sep 2022 18:29:23 GMT

proc means data=bill stackodsoutput mean median p25 p75 sum;
   ods output summary=summary;
   var lab pham diag;
run;
proc sql;
    create table want as select
    *,
    sum / sum(sum) as sum_pct
    from summary;
quit;

Re: Calculate mean median IQR sum sumpct

ybz12003 — Thu, 22 Sep 2022 20:16:23 GMT

Is it a way to format the number to one digit after the decimal?

Re: Calculate mean median IQR sum sumpct

PaigeMiller — Thu, 22 Sep 2022 20:31:27 GMT

Yes, assign the proper format to the variable.