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.
Add this option to the PROC MEANS statement: NWAY
Add this option to the PROC MEANS statement: NWAY
Thanks for the assistance!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.