topic Re: Divide the column value by the number of occurrences in SAS Programming

Divide the column value by the number of occurrences

max_ros — Mon, 30 Nov 2020 17:19:12 GMT

Hello everyone!
I have a dataset where in a column I have repeated but different values for some determinations of another variable (I don't know the number) and I would like to create a new column that contains these values divided by the number of occurrences. How can I do this with simple programming?

Attached the dataset with the "value" column of the values to be divided and the "value_1" column as I would like it (value_1 is the coloumn I 'd like to obtain).
Thanks again for those who want to help me
max

Re: Divide the column value by the number of occurrences

PaigeMiller — Mon, 30 Nov 2020 17:30:43 GMT

You don't mention the role of ID in this analysis. Is the grouping and the count of the number of occurrences determined by ID or by VALUE?

Should we ignore the typographical errors in the ID column and assume that these will always be spelled the same for each value of ID? Or does the problem solution have to fix the typographical errors first?

Re: Divide the column value by the number of occurrences

max_ros — Mon, 30 Nov 2020 17:39:07 GMT

Sorry for the bad asking. ID is the grouping. Values in value column are the same for every ID.

Re: Divide the column value by the number of occurrences

PaigeMiller — Mon, 30 Nov 2020 17:46:32 GMT

If you fix the mis-spellings under ID, this should work (otherwise you don't get the answers you want)

proc freq data=example;
    tables id/noprint out=counts;
run;
proc sort data=example;
    by id;
run;
data want;
    merge example counts;
    by id;
    value1 = value/count;
    keep id value value1;
run;

Re: Divide the column value by the number of occurrences

max_ros — Thu, 03 Dec 2020 15:32:17 GMT

tks a lot!

it works perfectly!

Re: Divide the column value by the number of occurrences

max_ros — Thu, 03 Dec 2020 15:33:11 GMT

thks a lot!