How to select values in column 3 based on value from col 2 and find mean?

[swsh016]

Col1 The year 2013-14	col2 Consumers of different vegetable Task1 Select consumers of beet	col3 Intake (gms) of all vegetable Task2 select quantity of beet intake	col4 Find Mean_1 quantity of beet intake
The year 2015-16	Select consumers of beet	select quantity of beet intake	Find Mean_2 quantity of beet intake
The year 2017-18	Select consumers of beet	select quantity of beet intake	Find Mean_3 quantity of beet intake

Compare 3 means with ANOVA

[ballardw]

Your subject is pretty meaningless as Col3 shows no numeric values, so no "mean" can be calculated. Also how are we supposed to use the value Col2 to select anything from Col3? We need some sort of rules.

I suspect that you do not even have a SAS data set.

Show us actual values, describe how to use Col2 with Col3 and best would be to include a small worked example given the example values.

[swsh016]

[image: image.png]
I did the selection of values from second colum :
aspfmt=.;
if DR1IFDCD in (75100800 75202011 ) then
aspfmt=1;
else
aspfmt=0;
I dont know how to select values from DR1GRMS that match values from
DR1FDCD and find mean of those values.
Thanks