Hi Team,
I have data as below
subject dose1 dose2 dose3 dose4
101 0.32 0.93 0.54 0.61
102 0.23 0.99 0.54 0.71
103 0.32 0.23 0.84 0.71
104 0.33 0.93 0.64 0.61
105 0.22 0.73 0.44 0.66
I need to calculate GMR(geometric mean ratio) acrooss doses like dose1-dose2, dose2-dose3 and dose3- dose4. I wanted to find the geometric
mean across each variable for the whole subjects. so i want the output has below
Doses GMR value(geometric mean ratio)
Dose1
Dose2 xx
Dose3 xx
Dose4 xx
so what procedure i need to use to calculate GMR across doses . is it possible to calculate GMR in proc TTest procedure if yes, wat is the option available to use in syntax?
Can you please illustrate the full calculation? I'm familiar with geometric mean but that doesn't look like what you're looking for here so want to be absolutely sure.
Making assumptions:
data diff;
set have;
dose2_dose1 = dose2-dose1;
dose3_dose2 = dose3-dose2;
dose4_dose3 = dose4-dose3;
run;
proc ttest data=diff dist=lognormal;
var dose2_dose1 dose3_dose2 dose4_dose3;
ods select confLimits = WANT;
run;
proc print data=want;run;
https://blogs.sas.com/content/iml/2019/10/02/geometric-mean-deviation-cv-sas.html
@mounikag wrote:
Hi Team,
I have data as below
subject dose1 dose2 dose3 dose4
101 0.32 0.93 0.54 0.61
102 0.23 0.99 0.54 0.71
103 0.32 0.23 0.84 0.71
104 0.33 0.93 0.64 0.61
105 0.22 0.73 0.44 0.66
I need to calculate GMR(geometric mean ratio) acrooss doses like dose1-dose2, dose2-dose3 and dose3- dose4. I wanted to find the geometric
mean across each variable for the whole subjects. so i want the output has below
Doses GMR value(geometric mean ratio)
Dose1
Dose2 xx
Dose3 xx
Dose4 xx
so what procedure i need to use to calculate GMR across doses . is it possible to calculate GMR in proc TTest procedure if yes, wat is the option available to use in syntax?
Can you please illustrate the full calculation? I'm familiar with geometric mean but that doesn't look like what you're looking for here so want to be absolutely sure.
Making assumptions:
data diff;
set have;
dose2_dose1 = dose2-dose1;
dose3_dose2 = dose3-dose2;
dose4_dose3 = dose4-dose3;
run;
proc ttest data=diff dist=lognormal;
var dose2_dose1 dose3_dose2 dose4_dose3;
ods select confLimits = WANT;
run;
proc print data=want;run;
https://blogs.sas.com/content/iml/2019/10/02/geometric-mean-deviation-cv-sas.html
@mounikag wrote:
Hi Team,
I have data as below
subject dose1 dose2 dose3 dose4
101 0.32 0.93 0.54 0.61
102 0.23 0.99 0.54 0.71
103 0.32 0.23 0.84 0.71
104 0.33 0.93 0.64 0.61
105 0.22 0.73 0.44 0.66
I need to calculate GMR(geometric mean ratio) acrooss doses like dose1-dose2, dose2-dose3 and dose3- dose4. I wanted to find the geometric
mean across each variable for the whole subjects. so i want the output has below
Doses GMR value(geometric mean ratio)
Dose1
Dose2 xx
Dose3 xx
Dose4 xx
so what procedure i need to use to calculate GMR across doses . is it possible to calculate GMR in proc TTest procedure if yes, wat is the option available to use in syntax?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.
Find more tutorials on the SAS Users YouTube channel.