sum one column and group by two others

Keets — Thu, 30 Jul 2020 22:39:53 GMT

Hello,

I have a big dataset with 3 values that are of interest. ID, Visite and WSL_Flaechen.

Visite ranges from 1 to 5 and WSL_Flaechen from 1 to 2.

With the following code i managed to group by Visite and count the WSL_Flaechen for each ID.

But instead i want count of WSL_Flaechen (blue arrow) to be multiplied with the value of WSL_Flaechen (red arrow) and display the sum of that for each ID.

So ID 4001 has

(1*8 + 2*12) = 32 on Visite 1 and

2 + 20 = 22 on Visite 2

and 26 on Visite 3

and so on...

The dataset only has 1s and 2s and the WSL_Flaechen field and i cant seem to just sum them up. I only display the count of 1s and 2s in seperate fields. How to i properly use the sum function here?

When i try to get sum in there i get the "statistical variable other than N without analysis variable" error.

Sincerely,

Keets

Re: sum one column and group by two others

Reeza — Thu, 30 Jul 2020 22:56:22 GMT

Look at the WEIGHT or FREQ statement within the PROC instead - and double check your numbers, especially if you have any missing values or non integers.

@Keets wrote:

Hello,

I have a big dataset with 3 values that are of interest. ID, Visite and WSL_Flaechen.

Visite ranges from 1 to 5 and WSL_Flaechen from 1 to 2.

With the following code i managed to group by Visite and count the WSL_Flaechen for each ID.

But instead i want count of WSL_Flaechen (blue arrow) to be multiplied with the value of WSL_Flaechen (red arrow) and display the sum of that for each ID.

So ID 4001 has

(1*8 + 2*12) = 32 on Visite 1 and

2 + 20 = 22 on Visite 2

and 26 on Visite 3

and so on...

The dataset only has 1s and 2s and the WSL_Flaechen field and i cant seem to just sum them up. I only display the count of 1s and 2s in seperate fields. How to i properly use the sum function here?

When i try to get sum in there i get the "statistical variable other than N without analysis variable" error.

Sincerely,

Keets

topic sum one column and group by two others in SAS Data Management

sum one column and group by two others

Re: sum one column and group by two others