Using PROC TABULATE with conditional logic/grouping

andydcutler — Fri, 13 Nov 2015 15:43:24 GMT

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

Re: Using PROC TABULATE with conditional logic/grouping

Reeza — Fri, 13 Nov 2015 16:02:26 GMT

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.

topic Using PROC TABULATE with conditional logic/grouping in SAS Programming

Using PROC TABULATE with conditional logic/grouping

Re: Using PROC TABULATE with conditional logic/grouping