Using PROC TABULATE with conditional logic/grouping

[andydcutler]

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

[Reeza]

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.