LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (July 1999, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Mon, 19 Jul 1999 09:11:16 -0700
Reply-To:   Paul OldenKamp <paul.oldenkamp@BOEING.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Comments:   To: Phil Mason <phil_mason@EMAIL.COM>
From:   Paul OldenKamp <paul.oldenkamp@BOEING.COM>
Organization:   The Boeing Company
Subject:   Re: SAS v8 & BBU
Comments:   To: SAS-L@LISTSERV.VT.EDU
Content-Type:   text/plain; charset=us-ascii

Phil Mason wrote: > > if anyone wants any bit of code tried out in v8, then you could send it to > me and I will give it a try - so long as it is quick & easy to run. > > Phil Mason > > p.s. I have my copy of SAS V8 because I am writing a book for the SAS Books > By Users programme (BBU). Want to write a book and get all the SAS software > you need? If so, check the SAS web site or ask me about it.

First my question on V8 shipping. At the PNWSUG Conference last month the SI folks told us that V8 would ship to *all* the V7 sites in July. Since we are well into July I was wondering whether any V7 sites have received V8. As of last week we haven't but SI sends things to us in funny ways so that we often don't get them. They told us that our 7-1 documentation CD(one for the whole Boeing Company I guess) was sent to us in May but nobody knows where it was sent and the Representatives who should have received it haven't.

Below is a SAS/GRAPH program using the annotate macros that behaves differently in 6.12 and 7. Could you run it in V8 Phil? At the PNWSUG I learned that changes have been made in the annotate macros between v6.12 and v7/8 but the changes are undocumented.

I got a program similar to this one to work in one session but in subsequent sessions I have not been able to get it to work. When I comment out the gridlab and gridsum macros in the datastep the main table appears, sometimes with additional uncalled for elements, and when I comment out the grid macro the gridlab and gridsum mostly seem to work but I cannot get both to work together. Here's the program:

proc format library=work ; value $prty 'A/C' = 'AOG/Critical' 'R/E' = 'Routine/Expedite' ; run;

data next00_t; infile cards; input @01 custind 2.0 @05 prty $5. @10 week 8. @20 stocked 2. @25 etosbysd 10.6 ; format week date7.; cards; 65.262998 0 48.296247 1 71.195679 14329 53.269971 14329 0 25.733042 14329 1 62.871967 14336 63.558060 14336 0 43.834494 14336 1 70.472497 14343 65.125700 14343 0 46.355140 14343 1 71.549656 14350 62.283137 14350 0 46.334451 14350 1 67.357829 14357 65.219881 14357 0 43.964365 14357 1 72.575921 14364 66.761178 14364 0 51.888939 14364 1 71.447010 14371 65.221478 14371 0 48.432056 14371 1 71.423974 14378 67.402359 14378 0 55.963303 14378 1 71.409788 14385 68.869048 14385 0 55.717489 14385 1 73.622366 14392 73.126914 14392 0 53.653137 14392 1 78.759740 14399 64.090909 14399 0 44.780988 14399 1 70.759575 14406 64.810413 14406 0 51.848907 14406 1 69.968354 14413 60.100205 14413 0 46.982055 14413 1 65.181675 14420 62.718724 14420 0 49.490420 14420 1 68.174176 14427 71.230249 14427 0 54.803261 14427 1 76.931594 ;; run;

options mprint mlogic symbolgen ; run;

%macro grid (row, col, txt, orgy, boxh, pos, font, fsize);

%system (2,3,3);

%bar (&col-3.5, &orgy-(&boxh*(&row)), &col+3.5, &orgy-(&boxh*&row+2), black, 0, E);

%label (&col-.03, &orgy-(&boxh*(&row-1)) - .3, &txt, black, 0, 0, &fsize, &font, &pos );

%mend grid;

%macro gridsum (row, txt, orgy, boxh, pos, font, fsize);

%system (1,3,3);

%bar (102, &orgy-(&boxh*(&row)), 110, &orgy-(&boxh*&row+2), black, 0, E);

%label (106, &orgy-(&boxh*(&row-1)) - .3, &txt, black, 0, 0, &fsize, &font, &pos );

%mend gridsum;

%macro gridlab (row, txt, orgy, boxh, pos, font, fsize);

%system (1,3,3);

%bar (-10, &orgy-(&boxh*(&row)), 0, &orgy-(&boxh*&row+2), black, 0, E);

%label (0, &orgy-(&boxh*(&row-1)) - .3, &txt, black, 0, 0, &fsize, &font, &pos );

%mend gridlab;

%annomac;

data anno1; length text $20; %dclanno; set next00_t(keep=week etosbysd custind week stocked prty) end=eof ; by custind prty week stocked; if 1 then do; if stocked eq . then do; if week eq . then do; %gridlab(1, 'Week End', 16, 2, 7, swissb, 1.65); %gridlab(2, 'All', 16, 2, 7, swissb, 1.65); %gridsum(1, 'Mean', 16, 2, 8, swissb, 1.65); %gridsum(2, put(etosbysd,5.2), 16, 2, 8, swissb, 1.65); end; else do; %grid(1, week, put(week,mmddyy5.), 16, 2, 8, swissb, 1.65); %grid(2, week, put(etosbysd,5.2), 16, 2, 8, swissb, 1.65); end; end; else if stocked then do; if week eq . then do; %gridlab(3, 'Yes', 16, 2, 7, swissb, 1.65); %gridsum(3, put(etosbysd,5.2), 16, 2, 8, swissb, 1.65); end; else do; %grid(3, week, put(etosbysd,5.2), 16, 2, 8, swissb, 1.65); end; end; else if not stocked then do; if week eq . then do; %gridlab(4, 'Not', 16, 2, 7, swissb, 1.65); %gridsum(4, put(etosbysd,5.2), 16, 2, 8, swissb, 1.65); end; else do; %grid(4, week, put(etosbysd,5.2), 16, 2, 8, swissb, 1.65); end; end; end; run;

options nobyline compress=yes ; run;

proc catalog c=work.gseg kill ; run;

goptions reset=all target=pscolor ftext=swissb ftitle=swissb rotate=landscape hsize=10 vsize=7.5 xmax=8.5 ymax=11 horigin=.5 vorigin=.5 ; run;

symbol1 f=special v=J i=j w=6 h=3 line=1 c=cx008000; symbol2 f=special v=K i=j w=6 h=3 line=2 c=cxff0000; symbol3 f=special v=L i=j w=6 h=3 line=3 c=cx0000ff; symbol4 f=special v=M i=j w=6 h=3 line=4 c=cx800080; symbol5 f=marker v=A i=j w=6 h=3 line=1 c=cxff0000; symbol6 f=marker v=B i=j w=6 h=3 line=2 c=cxff8000; symbol7 f=marker v=C i=j w=6 h=3 line=3 c=cxffff00; symbol8 f=marker v=D i=j w=6 h=3 line=4 c=cx00ff00; symbol9 f=marker v=M i=j w=6 h=3 line=1 c=cxff0000; symbol10 f=marker v=N i=j w=6 h=3 line=2 c=cxff8000; symbol11 f=marker v=O i=j w=6 h=3 line=3 c=cxffff00; symbol12 f=marker v=P i=j w=6 h=3 line=4 c=cx00ff00;

axis1 offset=(3.0,3.0) cells order=('02Apr99'd to '02Jul99'd by week) label=(h=2 ' ') major=(h=-1) value=none ;

axis2 order=(0 to 100 by 10) minor=(n=1) label=(a=90 'Percent Successful to Target Date') ;

legend1 cborder=black cframe=cxd0d0d0 position=(middle right outside) down=3 label=(position=top j=c h=1.5 'Part?') shape=symbol(4,3) cell value=(j=l 'All' j=l 'Not' j=l 'Yes' ) ;

title1 h=2 'Division'; footnote1 h=1 j=r 'Note: Includes xxx' j=l 'P. OldenKamp, xxx-xxx-xxxx' ; footnote2 h=1 j=r ' ' ; run;

proc gplot data=next00_t nocache ; by custind prty; title2 h=1.5 "#byval1 Order Entered"; title3 h=1.5 "#byval2"; plot etosbysd*week=stocked / anno=anno1 cframe=cxd0d0d0 haxis=axis1 legend=legend1 vaxis=axis2 autovref autohref ; format etosbysd 3. week mmddyy5. prty $prty.; run; quit;

-- ---------------------------------------------------------------------- // Paul OldenKamp // Boeing Commercial Airplane Group . // P. O. Box 3707, MS 36-40 |\ // Seattle, WA 98124-2207 | \____oo_ //==========================================((__| /___> // ___ ___ ___ ___ __ | // // /__// //__ / /\ // _ |// // /__//__//__ _/_ / //__/ '' //


Back to: Top of message | Previous page | Main SAS-L page