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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.