topic How do I create a calculated column in an existing dataset in SAS Programming

How do I create a calculated column in an existing dataset

adityal2810 — Sun, 18 Feb 2018 21:34:07 GMT

Week Sales Cum_Sales
1 160 0
2 390 160
3 800 550
4 995 1350
5 1250 2345
6 1630 3595
7 1750
8 2000
9 2250
10 2500

The columns week and sales are provided in the dataset. I am creating a new column called cumulative_sales where the first entry is always zero and the consecutive entries are the sum of sales one week before that

data B2;
set B2;
by week;
if first.week then cumulative_sales=0;
cumulative_sales = cumulative_sales + sales;
if last.week then output;
run;

Please mention the corrections in the code

Re: How do I create a calculated column in an existing dataset

Astounding — Sun, 18 Feb 2018 21:47:06 GMT

Here, you're increasing the cumulative sales and then outputting. You need to output first:

data want;

set have;

output;

cumulative_sales + sales;

run;

Re: How do I create a calculated column in an existing dataset

andreas_lds — Mon, 19 Feb 2018 07:11:08 GMT

And using "by week" is only necessary, if you have multiple observations for one week.

Re: How do I create a calculated column in an existing dataset

srinath3111 — Mon, 19 Feb 2018 09:13:05 GMT

Hi,

options missing=0;
data want;
set have;
x=lag(sales);
cum_sales+x;
drop x;
run;