DATA Step, Macro, Functions and more

Using PROC TABULATE with conditional logic/grouping

Reply
New Contributor
Posts: 3

Using PROC TABULATE with conditional logic/grouping

[ Edited ]

Hi,

 

I'm (very) new to SAS and I'm trying to perform some analysis on data using (potentially) PROC TABULATE.  I'll provide a very truncated view of this data here to illustrate and try to explain:

 

ProductName, ProductPrice

Product A         5

Product B         5

Product C         6

Product D         8

Product E         9

 

I'd like to display various stats by grouping the Products into 2 groups: 1 group where the ProductPrice is less than or equal to the median and another group where the ProductPrice is greater than the median.

 

Am I able to complete the above just using PROC TABULATE?  I'm trying to work out how I compare each ProductPrice to the median (6) and put that product in one of the 2 groups.

 

Many thanks

Super User
Posts: 17,824

Re: Using PROC TABULATE with conditional logic/grouping

I don't think you can. You'll need to calculate the median externally and create a grouping variable to specify the groups. You can then use proc report/tabluate to generate your report/output.
Ask a Question
Discussion stats
  • 1 reply
  • 135 views
  • 0 likes
  • 2 in conversation