home *** CD-ROM | disk | FTP | other *** search
/ NetNews Usenet Archive 1992 #26 / NN_1992_26.iso / spool / bit / listserv / sasl / 4956 < prev    next >
Encoding:
Internet Message Format  |  1992-11-08  |  5.7 KB
  1. Path: sparky!uunet!stanford.edu!bu.edu!wupost!zaphod.mps.ohio-state.edu!darwin.sura.net!paladin.american.edu!auvm!ESPRESSO.BOEING.COM!OLDENKMP
  2. From: oldenkmp@ESPRESSO.BOEING.COM ((P. Oldenkamp 5-4481))
  3. Newsgroups: bit.listserv.sas-l
  4. Subject: WHERE statement in PROC PLOT?
  5. Message-ID: <9211062136.AA02552@espresso.bcs.eca>
  6. Date: 6 Nov 92 21:36:25 GMT
  7. Sender: "SAS(r) Discussion" <SAS-L@UGA.BITNET>
  8. Reply-To: "(P. Oldenkamp 5-4481)" <oldenkmp@ESPRESSO.BOEING.COM>
  9. Lines: 79
  10. Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
  11. Comments: To: sas-l@uga.cc.uga.edu
  12.  
  13. ----------------------------------------------------------------------
  14. CONTENT:  QUESTION--WHERE statement in PROC PLOT doesn't work right
  15. REL/PLTF: 6.07TS302--MVS/ESA
  16. E-ADDR:   oldenkmp@ESPRESSO.boeing.com
  17. NAME:     Paul OldenKamp
  18. PHONE:    206-865-4481
  19. ----------------------------------------------------------------------
  20. SAS thinks that all the data is missing when I add a WHERE statement to
  21. a PROC PLOT interactive session.  We recently did maintenance to TS302
  22. but I don't recall having tried this before.  Here is a short example
  23. using the SASUSER.HOUSES dataset from SAS/ASSIST:
  24.  
  25.  | NOTE: AUTOEXEC processing completed.                                       |
  26.  |                                                                            |
  27.  | 1    proc plot                                                             |
  28.  | 2     data=sasuser.houses                                                  |
  29.  | 3     uniform                                                              |
  30.  | 4     ;                                                                    |
  31.  | 5     plot sqfeet * price /                                                |
  32.  | 6     ;                                                                    |
  33.  | 7    run;                                                                  |
  34.  |                                                                            |
  35.  | WARNING: Label for variable SQFEET is too long for axis. Try increasing ax |
  36.  |          length or reducing label length. Variable name will be used inste |
  37.  | 8     where price lt 80000;                                                |
  38.  | 9     ;                                                                    |
  39.  | 10    plot sqfeet * price /                                                |
  40.  | 11    ;                                                                    |
  41.  | 12   run;                                                                  |
  42.  |                                                                            |
  43.  | ERROR: All values missing for plot of SQFEET * PRICE.                      |
  44.  |        PLOT request will be ignored.                                       |
  45.  | 13   quit;                                                                 |
  46.  |                                                                            |
  47.  | NOTE: The PROCEDURE PLOT used the following resources:                     |
  48.  |       CPU     time -         00:00:00.04                                   |
  49.  |       Elapsed time -         00:06:18.71                                   |
  50.  |       Vector affinity time - 00:00:00.00                                   |
  51.  |       Vector usage    time - 00:00:00.00                                   |
  52.  |       RSM Hiperspace  time - 00:00:00.00                                   |
  53.  |       EXCP count   - 18                                                    |
  54.  |       Task  memory - 2394K (30K data, 2364K program)                       |
  55.  |       Total memory - 3699K (1032K data, 2667K program)                     |
  56.  |                                                                            |
  57.  | 14   run;                                                                  |
  58.  |
  59.  
  60. Output from the first PLOT statement:
  61.  
  62.  |                                                                            |
  63.  |                                 The SAS System                             |
  64.  |                                                 13:12 Friday, November 6,  |
  65.  |                                                                            |
  66.  |           Plot of SQFEET*PRICE.  Legend: A = 1 obs, B = 2 obs, etc.        |
  67.  | SQFEET                                                                     |
  68.  |   3000 +                                                                   |
  69.  |        |                                                                   |
  70.  |        |                                                                   |
  71.  |   2000 +                                                   A        A      |
  72.  |        |                                      AA  A    A A                 |
  73.  |        |                         AA A  A  B                                |
  74.  |   1000 +                     A                                             |
  75.  |        |         A                                                         |
  76.  |        |                                                                   |
  77.  |      0 +                                                                   |
  78.  |        --+----------+----------+----------+----------+----------+--------- |
  79.  |       $20,000    $40,000    $60,000    $80,000   $100,000   $120,000  $140 |
  80.  |                                      Asking price                          |
  81.  
  82. ----------------------------------------------------------------------
  83.            //  Paul OldenKamp
  84.           //   BCS Research and Technology          .
  85.          //    P. O. Box 24346, MS 7L-21            |\
  86.         //     Seattle, WA   98124-0346             | \____oo_
  87.        //==========================================((__|  /___>
  88.       //       ___ ___ ___ ___     __                  | //
  89.      //       /__//  //__  /  /\ //  _                 |//
  90.     //       /__//__//__ _/_ /  //__/                  ''
  91.        //
  92.