Hi Vince, To be Precise on what i have required is, I need the putput of the graph in the attached. By using only GCHART and I am attaching the below code for your refernece. PROC SQL; CREATE TABLE Consumer_NEW AS SELECT DISTINCT A.*,COUNT(Consumer_Closed) AS Consumer_Review_Closed FROM Consumer A group by newdate; quit; PROC SQL; CREATE TABLE OPENED1_NEW_repo AS SELECT DISTINCT A.*,COUNT(CASE_RK) AS Provider_Review_Opened FROM OPENED1_NEW_1 A group by newdate; quit; PROC SQL; CREATE TABLE GRAPH AS SELECT distinct (A.newdate),A.Consumer_Review_Closed,B.Provider_Review_Opened FROM Consumer_NEW A INNER JOIN OPENED1_NEW_repo B ON A.newdate=B.newdate; quit; data ds2; set GRAPH; n=_n_; rename newdate=year; run; data _null_; set ds2 end=eof; if eof then call symput('skip',left(n)); run; data ds2; set ds2; resp=Provider_Review_Opened; mid='Provider_Review_Opened'; output; resp=Consumer_Review_Closed; mid='Consumer_Review_Closed'; output; run; proc sort; by year mid; run; data ds2; set ds2; array change _NUMERIC_; do over change; if change=. then change=0; end; run; I need to get the graph of this by using only GCHART.please reply at the earliest. Thanks, harish
... View more