DATA Step, Macro, Functions and more

Proc Tabulate - How do I sum based on two conditional criteria

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Proc Tabulate - How do I sum based on two conditional criteria

Hi,

 

Is there any way to proc tabulate that sums a variable based on two conditional criteria.
Ie. Sum number of clients, in each state, by postcode.

Not sure how to post an example dataset. Using SAS EG 7.1.


Appreciate any help.


Accepted Solutions
Solution
‎04-10-2017 02:29 AM
Contributor
Posts: 57

Re: Proc Tabulate - How do I sum based on two conditional criteria

Posted in reply to danielpeac
Follow this video. Hopefully you can do easily.
https://www.youtube.com/watch?v=V-MdjZ-7d1U

View solution in original post


All Replies
Solution
‎04-10-2017 02:29 AM
Contributor
Posts: 57

Re: Proc Tabulate - How do I sum based on two conditional criteria

Posted in reply to danielpeac
Follow this video. Hopefully you can do easily.
https://www.youtube.com/watch?v=V-MdjZ-7d1U
Super User
Posts: 19,847

Re: Proc Tabulate - How do I sum based on two conditional criteria

Posted in reply to danielpeac

Either include the 2 variables in your BY or CLASS statement. 

 

If you want a table for each state/postcode then it goes in the BY statement, otherwise CLASS statement. 

New Contributor
Posts: 2

Re: Proc Tabulate - How do I sum based on two conditional criteria

Thanks both for your helpful advice.

 

I may have explained myself poorly, but the video above helped me get to where I needed to be. I ended up adding the second variable to the freq statement.

 

Daniel.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 129 views
  • 0 likes
  • 3 in conversation