Date: Mon, 16 Apr 2007 09:42:38 -0700
Reply-To: Syb it <sas_datalover@YAHOO.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Syb it <sas_datalover@YAHOO.COM>
Subject: Re: graph this
In-Reply-To: <200704161516.l3GAkxXA018013@malibu.cc.uga.edu>
Content-Type: text/plain; charset=iso-8859-1
NOw given this output, how then could I adjust the scale on the X-Axis, such that I have things evenly space out by say $.1;$.2 up to $1.0?? Any suggestions?
Ya Huang <ya.huang@AMYLIN.COM> wrote: Just surround the code with ods/html:
ods html file="c:\temp\junk.xls" gpath="c:\temp";
data have;
name='Tom '; do price=0.07,0.09,0.09,0.10,0.10,0.10,0.11,0.63; output; end;
name='James'; do price=0.67,0.70; output; end;
name='Chris'; do price=0.70,0.70,0.75,0.70,0.70; output; end;
name='Mike '; do price=0.07,0.07,0.08,0.10,0.10,0.10,0.10,0.10; output; end;
name='Sean '; do price=0.50; output; end;
run;
proc gchart;
hbar price / discrete subgroup=name;
run;
quit;
ods html close;
On Mon, 16 Apr 2007 06:59:06 -0700, Syb it wrote:
>Nat,
>
> I work with people that like to see things in color. So I'd say I have a
preference for the bar charts that Huang came up with.
>
> My challenge now is trying to get that in Excel or something like that.
I need to figure out how to export a graph (Any ideas?), so it can be
presented much easier in powerpoint or something like that.
>
> Thanks guys for your input.
>
>
>Nat Wooding wrote:
> Take a look at the following. How close is this to what you one. One
issue
>is that the names sometimes "collide" but this could be somewhat taken care
>of by dithering the data. I can show you how to do that if this approach is
>close to what you want.
>
>
>data syb;
>input Salesman $6. price;
>cards;
>Tom 0.07
>Tom 0.09
>Tom 0.09
>Tom 0.10
>Tom 0.10
>Tom 0.10
>Tom 0.11
>Tom 0.63
>James 0.67
>James 0.70
>Chris 0.70
>Chris 0.70
>Chris 0.75
>Chris 0.70
>Chris 0.70
>Chris 0.70
>Mike 0.07
>Mike 0.07
>Mike 0.08
>Mike 0.10
>Mike 0.10
>Mike 0.10
>Mike 0.10
>Mike 0.10
>Sean 0.50
>proc sort data=syb nodupkey;
>by price salesman;
>proc print;
>run;
>
>proc gplot;
>plot price*price=salesman;
>symbol1 i=none pointlabel=("#salesman") V=NONE;
>run;
>quit;
>
>Nat Wooding
>Environmental Specialist III
>Dominion, Environmental Biology
>4111 Castlewood Rd
>Richmond, VA 23234
>Phone:804-271-5313, Fax: 804-271-2977
>
>
>
>Syb it
>HOO.COM> To
>Sent by: "SAS(r) SAS-L@LISTSERV.UGA.EDU
>Discussion" cc
>GA.EDU> Subject
>Re: graph this
>
>04/16/2007 09:18
>AM
>
>
>Please respond to
>Syb it
>HOO.COM>
>
>
>
>
>
>
>The data looks like this:
>
>Tom: 0.07; 0.09; 0.09; 0.10; 0.10; 0.10 ; 0.11; 0.63
>James: 0.67; 0.70
>Chris: 0.70; 0.70; 0.75; 0.70; 0.70
>Mike: 0.07; 0.07; 0.08; 0.10; 0.10; 0.10; 0.10; 0.10
>Sean: 0.50
>
>The values in the tables are the prices for which certain products were
>sold. For example looking at Tom’s sales, we see that this person prices
>ranged from $0.07 to $0.63. For Sean only one product sold for $.50. I
>need to put this on a graph to show which salesperson had the most dominant
>price. I had in mind putting price on the X-axis such that it ranges from
>$.10 to $.75 and have names stack up by price. I could do it manually, but
>any suggestions in SAS?
>
>
>Nat Wooding wrote:
>Your data, at least as it appears on my email, has all of the numbers in
>a
>single column so I can't really see what they are supposed to look like.
>Could you retype them and we can probably give you a much better answer.
>
>
>
>Nat Wooding
>Environmental Specialist III
>Dominion, Environmental Biology
>4111 Castlewood Rd
>Richmond, VA 23234
>Phone:804-271-5313, Fax: 804-271-2977
>
>
>
>Syb it
>HOO.COM> To
>Sent by: "SAS(r) SAS-L@LISTSERV.UGA.EDU
>Discussion" cc
>GA.EDU> Subject
>graph this
>
>04/16/2007 09:02
>AM
>
>
>Please respond to
>Syb it
>HOO.COM>
>
>
>
>
>
>
>Dear All,
>
>I have sales data that looks like this:
>
>Tom
>James
>Chris
>Mike
>Sean
>0.07
>
>0.70
>0.07
>
>0.09
>
>0.70
>0.07
>
>0.09
>
>0.75
>0.08
>
>0.09
>
>
>
>
>0.10
>0.67
>0.70
>0.10
>
>0.10
>
>
>0.10
>
>0.10
>
>
>0.10
>
>0.11
>
>
>0.10
>
>0.63
>0.70
>0.70
>0.10
>0.50
>
>
>The values in the tables are the prices for which certain products were
>sold. For example looking at Tom’s sales, we see that this person prices
>ranged from $0.07 to $0.63. For Sean only one product sold for $.50. I
>need to put this on a graph to show which salesperson had the most dominant
>price. I had in mind putting price on the X-axis such that it ranges from
>$.10 to $.75 and have names stack up by price. I could do it manually, but
>any suggestions in SAS?
>
>Thanks,
>
>it.
>
>
>---------------------------------
>Ahhh...imagining that irresistible "new car" smell?
>Check outnew cars at Yahoo! Autos.
>
>
>-----------------------------------------
>CONFIDENTIALITY NOTICE: This electronic message contains
>information which may be legally confidential and/or privileged and
>does not in any case represent a firm ENERGY COMMODITY bid or offer
>relating thereto which binds the sender without an additional
>express written confirmation to that effect. The information is
>intended solely for the individual or entity named above and access
>by anyone else is unauthorized. If you are not the intended
>recipient, any disclosure, copying, distribution, or use of the
>contents of this information is prohibited and may be unlawful. If
>you have received this electronic transmission in error, please
>reply immediately to the sender that you have received the message
>in error, and delete it. Thank you.
>
>
>
>---------------------------------
>Ahhh...imagining that irresistible "new car" smell?
>Check outnew cars at Yahoo! Autos.
>
>
>
>---------------------------------
>Ahhh...imagining that irresistible "new car" smell?
> Check outnew cars at Yahoo! Autos.
---------------------------------
Ahhh...imagining that irresistible "new car" smell?
Check outnew cars at Yahoo! Autos.
| 
