topic How to take a SAS Dataset and sum up individual columns in SAS Programming

How to take a SAS Dataset and sum up individual columns

PETE — Mon, 28 Sep 2015 20:02:05 GMT

Hi - getting bogged down on the simple idea of taking mutiple columns from a dataset and summing up certain columns. To give you an example of what i'm doing, i want to take the below example and sum up the "eligible column" so that the final column is summed up. Any suggestions on how to get moving on it?

Style	Type	Region	Eligible
LC	Long	Asia	1
LC	Long	Asia	1
LC	Long	Asia	0
LC	Long	Asia	1
SC	Short	Emea	0
SC	Short	Emea	1



LC	Long	Asia	3
SC	Short	Emea	1

Re: How to take a SAS Dataset and sum up individual columns

ballardw — Mon, 28 Sep 2015 20:41:00 GMT

If you want a dataset for output them Proc means or summary:

proc summary data=have nway;

class style type region;

var eligible;

output out=want sum=;

run;

The sum= says keep the same variable but sum within the combinations of style, type and region.

There will be to other variables in the output, _type_ that can be used to determine combinations of the class variable when not using the NWAY option and _freq_ that says how many records were used.

Re: How to take a SAS Dataset and sum up individual columns

kthenaj — Mon, 28 Sep 2015 20:53:51 GMT

Do you want another variable in your data set of the sum? Do you just want to know the summed value? Wasn't exactly sure what you wanted so here are two options. Hope they help.

data Pete;
input Style $ Type $ Region $ Eligible;

/*Option 1: Creating a cumulative sum variable*/
retain EligibleSum 0;
EligibleSum = EligibleSum + Eligible;

datalines;
LC Long Asia 1
LC Long Asia 1
LC Long Asia 0
LC Long Asia 1
SC Short Emea 0
SC Short Emea 1
LC Long Asia 3
SC Short Emea 1
;

/*Option 2: Simply determining the sum of the Eligible variable*/
proc print data = Pete;
sum Eligible;
run;

Re: How to take a SAS Dataset and sum up individual columns

PETE — Tue, 29 Sep 2015 11:11:17 GMT

Thank you for the guidance.

One follow up question - whats the best way to "ignore" a column in a dataset that you don't need? If=Delete function?

Re: How to take a SAS Dataset and sum up individual columns

dcruik — Tue, 29 Sep 2015 13:59:36 GMT

You can use a DROP statement, either in parenthesis during the DATA statement, or after the SET statement, not in parenthesis.

data want (DROP=variable);
set have;
run;

data want;
set have;
DROP variable;
run;

Re: How to take a SAS Dataset and sum up individual columns

ballardw — Tue, 29 Sep 2015 14:25:07 GMT

If you use the proc summary approach any variable not explicitly listed in the syntax will not be in the output.