Using CA-Datacom/DB Data in SAS Programs

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 Software: Reference, Volumes 1 and 2 for more information about the kinds of graphics you can produce with this SAS software product.

Top of Page