Charting CA-Datacom/DB Data

CHART procedure programs work with CA-Datacom/DB data that is described by view descriptors just as they do with SAS data files. The following example uses the view descriptor Vlib.AllOrdr to create a vertical bar chart of the number of orders per product:

proc chart data=vlib.allordr;
   vbar stocknum;
   title 'Data Described by VLIB.ALLORDR';
run;

Vlib.AllOrdr accesses data from the table Order. The following output shows the information for this example. STOCKNUM represents each product. The number of orders for each product is represented by the height of the bar.

Results of Charting CA-Datacom/DB Data

                         Data Described by VLIB.ALLORDR                        1
 Frequency

 8 +     *****     *****                                   *****     *****
   |     *****     *****                                   *****     *****
   |     *****     *****                                   *****     *****
   |     *****     *****                                   *****     *****
   |     *****     *****                                   *****     *****
 7 +     *****     *****                                   *****     *****
   |     *****     *****                                   *****     *****
   |     *****     *****                                   *****     *****
   |     *****     *****                                   *****     *****
   |     *****     *****                                   *****     *****
 6 +     *****     *****     *****                         *****     *****
   |     *****     *****     *****                         *****     *****
   |     *****     *****     *****                         *****     *****
   |     *****     *****     *****                         *****     *****
   |     *****     *****     *****                         *****     *****
 5 +     *****     *****     *****                         *****     *****
   |     *****     *****     *****                         *****     *****
   |     *****     *****     *****                         *****     *****
   |     *****     *****     *****                         *****     *****
   |     *****     *****     *****                         *****     *****
 4 +     *****     *****     *****                         *****     *****
   |     *****     *****     *****                         *****     *****
   |     *****     *****     *****                         *****     *****
   |     *****     *****     *****                         *****     *****
   |     *****     *****     *****                         *****     *****
 3 +     *****     *****     *****                         *****     *****
   |     *****     *****     *****                         *****     *****
   |     *****     *****     *****                         *****     *****
   |     *****     *****     *****                         *****     *****
   |     *****     *****     *****                         *****     *****
 2 +     *****     *****     *****     *****               *****     *****
   |     *****     *****     *****     *****               *****     *****
   |     *****     *****     *****     *****               *****     *****
   |     *****     *****     *****     *****               *****     *****
   |     *****     *****     *****     *****               *****     *****
 1 +     *****     *****     *****     *****               *****     *****
   |     *****     *****     *****     *****               *****     *****
   |     *****     *****     *****     *****               *****     *****
   |     *****     *****     *****     *****               *****     *****
   |     *****     *****     *****     *****               *****     *****
   ----------------------------------------------------------------------------
          750       2250      3750      5250      6750      8250      9750

                                 STOCKNUM

For more information about the CHART procedure, see the Base SAS Procedures Guide.

If you have SAS/GRAPH software, you can create colored block charts, plots, and other graphics based on CA-Datacom/DB data. See the SAS/GRAPH: Reference for more information about the types of graphics that you can produce with this SAS software product.