topic Re: Combining several variables in SAS Programming

Combining several variables

bryn — Mon, 03 Oct 2016 23:51:03 GMT

So I have merged together 2 data sets by the same last name. I now have several observation with the same last name. I want to combine all those variables(all with the same information in the other variables, just not in sales. I want to sum up all of the sales variables for each last name.

Any idea of how to do this??

Re: Combining several variables

ballardw — Tue, 04 Oct 2016 14:35:49 GMT

It would be helpful to see some example data and desired output.

It may be that something like

proc means data=yourdata sum;

class lastname;

var sales;

run;

does some of what you want.