From: oldenkmp@ESPRESSO.BOEING.COM ((P. Oldenkamp 5-4481))
Newsgroups: bit.listserv.sas-l
Subject: WHERE statement in PROC PLOT?
Date: 6 Nov 92 21:36:25 GMT
Reply-To: "(P. Oldenkamp 5-4481)" <oldenkmp@ESPRESSO.BOEING.COM>
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Comments: To: sas-l@uga.cc.uga.edu

----------------------------------------------------------------------
CONTENT:  QUESTION--WHERE statement in PROC PLOT doesn't work right
REL/PLTF: 6.07TS302--MVS/ESA
E-ADDR:   oldenkmp@ESPRESSO.boeing.com
NAME:     Paul OldenKamp
PHONE:    206-865-4481
----------------------------------------------------------------------
SAS thinks that all the data is missing when I add a WHERE statement to
a PROC PLOT interactive session.  We recently did maintenance to TS302
but I don't recall having tried this before.  Here is a short example
using the SASUSER.HOUSES dataset from SAS/ASSIST:

 | NOTE: AUTOEXEC processing completed.                                       |
 |                                                                            |
 | 1    proc plot                                                             |
 | 2     data=sasuser.houses                                                  |
 | 3     uniform                                                              |
 | 4     ;                                                                    |
 | 5     plot sqfeet * price /                                                |
 | 6     ;                                                                    |
 | 7    run;                                                                  |
 |                                                                            |
 | WARNING: Label for variable SQFEET is too long for axis. Try increasing ax |
 |          length or reducing label length. Variable name will be used inste |
 | 8     where price lt 80000;                                                |
 | 9     ;                                                                    |
 | 10    plot sqfeet * price /                                                |
 | 11    ;                                                                    |
 | 12   run;                                                                  |
 |                                                                            |
 | ERROR: All values missing for plot of SQFEET * PRICE.                      |
 |        PLOT request will be ignored.                                       |
 | 13   quit;                                                                 |
 |                                                                            |
 | NOTE: The PROCEDURE PLOT used the following resources:                     |
 |       CPU     time -         00:00:00.04                                   |
 |       Elapsed time -         00:06:18.71                                   |
 |       Vector affinity time - 00:00:00.00                                   |
 |       Vector usage    time - 00:00:00.00                                   |
 |       RSM Hiperspace  time - 00:00:00.00                                   |
 |       EXCP count   - 18                                                    |
 |       Task  memory - 2394K (30K data, 2364K program)                       |
 |       Total memory - 3699K (1032K data, 2667K program)                     |
 |                                                                            |
 | 14   run;                                                                  |
 |

Output from the first PLOT statement:

 |                                                                            |
 |                                 The SAS System                             |
 |                                                 13:12 Friday, November 6,  |
 |                                                                            |
 |           Plot of SQFEET*PRICE.  Legend: A = 1 obs, B = 2 obs, etc.        |
 | SQFEET                                                                     |
 |   3000 +                                                                   |
 |        |                                                                   |
 |        |                                                                   |
 |   2000 +                                                   A        A      |
 |        |                                      AA  A    A A                 |
 |        |                         AA A  A  B                                |
 |   1000 +                     A                                             |
 |        |         A                                                         |
 |        |                                                                   |
 |      0 +                                                                   |
 |        --+----------+----------+----------+----------+----------+--------- |
 |       $20,000    $40,000    $60,000    $80,000   $100,000   $120,000  $140 |
 |                                      Asking price                          |

----------------------------------------------------------------------
	       //  Paul OldenKamp
	      //   BCS Research and Technology          .
	     //    P. O. Box 24346, MS 7L-21            |\
	    //     Seattle, WA   98124-0346             | \____oo_
	   //==========================================((__|  /___>
	  //       ___ ___ ___ ___     __                  | //
	 //       /__//  //__  /  /\ //  _                 |//
	//       /__//__//__ _/_ /  //__/                  ''
       //