Using CA-Datacom/DB Data in SAS Programs |
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.
Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.