topic Re: SAS array addition // FOR EACH? in SAS Programming

SAS array addition // FOR EACH?

buffalol — Mon, 19 Jun 2017 12:36:22 GMT

I'm putting together a dataset using arrays created from another dataset. Lets say the dataset is as follows:

input shop year sales;
datalines;
01 01 20000
01 02 23500
01 03 21020
02 01 23664
02 02 15420
02 03 14200
03 01 25623
03 02 12500
03 03 20030
;
run;

I want to get the total sales for each shop using an array.

Re: SAS array addition // FOR EACH?

PeterClemmensen — Mon, 19 Jun 2017 12:41:22 GMT

Why do you want to use an array to do this? You can do it like this

data have;
input shop year sales;
datalines;
01 01 20000
01 02 23500
01 03 21020
02 01 23664
02 02 15420
02 03 14200
03 01 25623
03 02 12500
03 03 20030
;

proc sort data = have;
	by shop;
run;

data want(keep = shop total);
	set have;
	by shop;
	if first.shop then total = 0;
	total + sales;
	if last.shop then output;
run;

Re: SAS array addition // FOR EACH?

Tom — Mon, 19 Jun 2017 12:51:07 GMT

Why would you want to use an array?

To get the total sales just use PROC SUMMARY.

proc summary data=have nway ;
  class shop;
  var sales ;
  output out=want sum=total_sales;
run;

Re: SAS array addition // FOR EACH?

RW9 — Mon, 19 Jun 2017 12:52:07 GMT

Look at proc means or summary with a by line for shop. This is the purpose of such procedures:

http://www2.sas.com/proceedings/sugi29/240-29.pdf

For example:

proc means data=have;
  by shop;
  var sales;
  output out=want sum=sum;
run;

Re: SAS array addition // FOR EACH?

Reeza — Mon, 19 Jun 2017 13:28:39 GMT

As others have implied an Array is not the correct method for solving this problem. In SAS, an Array is used on a single row, typically, not across multiple rows.

You can summarize data using a summary PROC, PROC SQL, or a data step using FIRST/LAST.