topic Re: Calculations Across Various Columns? in SAS Procedures

Calculations Across Various Columns?

brandonepena931 — Wed, 23 Dec 2020 18:19:26 GMT

I'm trying to do some calculations with a data set like the one below:

Item_Set_1 Item_Set_2 Value Calculation

xyz 1

aaa 2

bbb 3

ccc 4

ddd 5

eee 6

I want to do it so that I take the corresponding value to Item_Set_1 and multiply by the corresponding value to Item_Set_2. Any easy way to do this?

Re: Calculations Across Various Columns?

Shmuel — Wed, 23 Dec 2020 18:35:15 GMT

data want;

set have;

retain prev_value;

prev_value = lag(value);

if _N_ > 1 then calculation = value * prev_value;

run;

Re: Calculations Across Various Columns?

brandonepena931 — Wed, 23 Dec 2020 19:04:35 GMT

Sorry, my dataset is quite a bit large and doesn't follow the exact pattern as shown above. It's a bit more random

Re: Calculations Across Various Columns?

Kurt_Bremser — Wed, 23 Dec 2020 19:09:59 GMT

I see no matching values in the item_set variables. Please explain what you mean by "corresponding".

Re: Calculations Across Various Columns?

brandonepena931 — Wed, 23 Dec 2020 19:25:31 GMT

Apologies for that. See the example below for something a bit more accurate.
Time Item_Set_1 Item_Set_2 Value Calculation

period1 xyz 1

period2 aaa 2

period3 bbb 3

period4 ccc 4

period5 ddd 5

period6 eee 6

Re: Calculations Across Various Columns?

nrk1787db1 — Tue, 12 Jan 2021 16:16:31 GMT

Writing detailed requirement with examples will help people trying to understand the problems you are facing and help you out.