proc means help

[pangea17]

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.   

[Astounding · Accepted solution]

Add this option to the PROC MEANS statement:  NWAY

[pangea17]

Thanks for the assistance!