topic Find the average post-intervention umaqs score for each patient in Statistical Procedures

Find the average post-intervention umaqs score for each patient

CathyVI — Fri, 03 Mar 2023 20:44:47 GMT

Hi,

I have a dataset called wide1 with the following id variables which represent each individual. Here is a sample of my data below.

How would I find the average post-intervention umaqs score for each patient? umaqs0 is measure before intervention, umaqs6- umaqs26 is measure post intervention.

I want using the code below but am not sure if this is right.

proc means data=wide1;
var umaqs6 umaqs12 umaqs26;
run;

Obs ID Group _NAME_ umaqs0 umaqs6 umaqs12 umaqs26123456

14789	2	umaqs	10	10	15	15
15170	2	umaqs	16	20	20	20
15611	1	umaqs	10	20	18	22
15697	1	umaqs	10	10	10	11
15844	1	umaqs	21	26	26	27
15846	2	umaqs	26	29	28	24

Re: Find the average post-intervention umaqs score for each patient

PaigeMiller — Fri, 03 Mar 2023 21:11:19 GMT

From now on, data should be provided as working SAS data step code (instructions) and not as screen captures.

It is not clear to me which column is the patient, as you have not provided a variable named patient. Honestly, it is hard to align the data you do show with your description.

I want using the code below but am not sure if this is right.

proc means data=wide1;
var umaqs6 umaqs12 umaqs26;
run;

Any time you are not sure if your code is right, my recommendation is that you actually try the code and see.

Re: Find the average post-intervention umaqs score for each patient

StatDave — Fri, 03 Mar 2023 21:21:59 GMT

If what you want is to compute the average across several variables for each row of your data set, then you can use the MEAN function in the DATA step. For example, these statements compute the average across the umaqs6-umaqs26 variables for each row and record the average in a new variable called AVG_UMAQS:

data new;

set your-dataset-name;

avg_umaqs=mean(of umaqs2-umaqs26);

run;

Re: Find the average post-intervention umaqs score for each patient

CathyVI — Fri, 03 Mar 2023 21:22:32 GMT

@PaigeMiller Thank you for your observation.

This is the sample data. I have more than 100 rows. How do I find the average post-intervention umaqs score for each patient? It is the "each patient" that's getting me confused.

data wide1;
input ID$ Group umaqs0 umaqs6 umaqs12 umaqs26;
datalines;
14789 2 10 10 15 15
15170 2 16 20 20 20
15611 1 10 20 18 22
15697 1 10 10 10 11
15844 1 21 26 26 27
;run;

Re: Find the average post-intervention umaqs score for each patient

PaigeMiller — Fri, 03 Mar 2023 21:40:36 GMT

@CathyVI wrote:

@PaigeMiller Thank you for your observation.

This is the sample data. I have more than 100 rows. How do I find the average post-intervention umaqs score for each patient? It is the "each patient" that's getting me confused.

data wide1;
input ID$ Group umaqs0 umaqs6 umaqs12 umaqs26;
datalines;
14789 2 10 10 15 15
15170 2 16 20 20 20
15611 1 10 20 18 22
15697 1 10 10 10 11
15844 1 21 26 26 27
;run;

You still haven't made it clear what "each patient" means here. Are we trying to average numbers across rows? (If so then I think @StatDave is on the right track) Or are you not trying to average across rows, and you want something else?