logo Getting Started with SAS Enterprise Guide Main menubacknext


You have created reports that show the total inventory for each product by category number. Suppose that you also want to know what products and product categories are most and least profitable to the company so that you can make recommendations about the mix of products that the company should continue to sell. You want the reports to show the following information:

  • labels, rather than numbers, for the product categories
  • the total profit that is generated by sales of each product and product category
  • the average profit that is generated by sales of each product and product category
  • the data sorted by product category and then product

The data that you need in order to create this report is contained in several different tables. Using the Query Builder, you can join the tables that contain this information, and then you can run tasks on the query output. You need to join the following tables:

  • Products - a SAS data set that contains product information such as name, price, and quantity of stock. It also contains category identification numbers.

  • Orders - a SAS data set that contains data from customer orders.

  • Categories - the SAS data set that you created from a text file that contains labels for category identification numbers.

None of the tables contain profit data, but you can add a computed column for profit in the query.

Query output showing columns from tables joined in the query

Next you start a query and add the tables that you need.

Main menubacknext