Date: Mon, 16 Apr 2007 06:59:06 -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: <OFFC6685CD.603371FE-ON852572BF.004B4427-852572BF.004B6BE3@dom.com>
Content-Type: text/plain; charset=iso-8859-1
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 <Nathaniel.Wooding@DOM.COM> 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.
