topic Re: How to select values in column 3 based on value from col 2 and find mean? in SAS Procedures

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

swsh016 — Wed, 20 Jan 2021 15:25:38 GMT

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

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

ballardw — Wed, 20 Jan 2021 15:35:30 GMT

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.

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

swsh016 — Wed, 20 Jan 2021 16:12:13 GMT

[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