Date:         Fri, 5 Sep 2008 09:30:45 -0600
Reply-To:     JD <jdiebal@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         JD <jdiebal@GMAIL.COM>
Subject:      Re: Trendline in SAS vs Excel
Comments: To: Arthur Tabachneck <art297@netscape.net>
In-Reply-To:  <200809042307.m84JvHBg028796@malibu.cc.uga.edu>
Content-Type: text/plain; charset=ISO-8859-1

I'm must be missing something. Can you tell me what's wrong with the
following example? I can only get the regression line to show up.
Also, how would I turn this into a bar chart with a regression line?
thank you.

/* Set graphics options */
goptions reset=all ;

/* Create input data set, b */
data b;
input month date7. actual;
cards;
01jan96 3.5
02feb96 1.5
03mar96 1.7
04apr96 2.2
05may96 2.2
06jun96 2.9
07jul96 2.3
08aug96 2.4
09sep96 1.6
09oct96 2.6
09nov96 3.6
09dec96 5.6
;
run;


symbol1 color=black interpol=needle v=none c=red w=5;
symbol2 color=black interpol=rl v=none ;

proc gplot data=b;

format month mmddyy8.;
  symbol1 i=r;
  plot actual*month=1 actual*month=2 ;
run;
quit;





On Thu, Sep 4, 2008 at 5:07 PM, Arthur Tabachneck <art297@netscape.net> wrote:
>
> Take a look at: http://xrl.us/oqa3v
>
> or, in long form:
>
> http://www.listserv.uga.edu/cgi-bin/wa?A2=ind0207B&L=sas-
> l&D=1&H=0&O=D&T=1&P=15928
>
> Art
> --------
> On Thu, 4 Sep 2008 16:42:39 -0600, JD <jdiebal@GMAIL.COM> wrote:
>
> >If I have data in Excel such as below, I would simply create a simple bar
> >graph, right click on the data series in that graph and select 'Add
> >Trendline'. For a data such as below the trendline would be a line
> >'skimming' the top of each bar going from bottom left to top right. Of
> >course the trendline would not track the bars with real data but the
> concept
> >is the same.
> >
> >Month  Cost  M1       1  M1       2  M1       3  M1       4  M1
> >5  M1
> >6
> >...
> >M12     12
> >
> >Can someone tell me how to do something similar in SAS so I can generate a
> >similar chart? thank you.