proc means help

pangea17 — Wed, 20 Jul 2016 06:51:24 GMT

I am using enterprise guide 9.3. I have a dataset that has mutiple rows for a customer. I want to look at how many contacts a customer has a well as payments over the course of a month.

I am using a proc means to summarize the data.

proc means data = gregory n;

class primekey agency employeecode;

var count;

where blank is eq to "contacts";

output out = contacts n;

RUN;

proc means data = gregory n;

class primekey agency employeecode;

var count;

where blank is eq to "promise";

output out = promises n;

RUN;

What I want to do is merge the two output datasets by primekey to have a result:

primekey # contacts #promises agency employeecode etc.

abc 10 3

The problem I am having is that I get _type_ and _freq_ variables, which I can drop using (drop= _type_ _freq_),

however I get summaries for multiple _types_. I only want to keep the one where all the variables are listed out.

Re: proc means help

Astounding — Wed, 20 Jul 2016 07:57:38 GMT

Add this option to the PROC MEANS statement: NWAY

Re: proc means help

pangea17 — Wed, 20 Jul 2016 15:35:57 GMT

Thanks for the assistance!

topic Re: proc means help in SAS Procedures

proc means help

Re: proc means help

Re: proc means help