Multiple lines per graph -- Put many graphs in one sheet too cluttered

[Nikos]

Hi,

I have a dataset which I attach herewith (too many obs).

I use the following three pieces of code to generate graphs and export them to Excel (I use msoffice2k since excelxp tagsets for some reason does not work for me)

Unfortunately the results I am getting are "horrible"..

I am getting:

-- messy huge labels

-- the dataset under the Graph etc..

When I am using the BY Dev_YR_MNTH; then I get 60 graphs while I would wish to have them all in one page side-by-side.

I would very much appreciate if you could help me out to make more presentable the output.

Thank you

Nikos

******************** ( 1 )  *********************************;

ods msoffice2k path="E:\Val_Results"(url=none) file="graph1.html" newfile=output style=normal;

title1 "Amt Development by Age";

symbol1 interpol=join value=dot;

proc gplot data= Test;

  plot Amt*Age=Dev_YR / hminor=0 autovref;

/* by Dev_YR_MNTH;*/

run;

title;

footnote;

ods msoffice2k close;

************************* (  2 )    **********************************************;

ods msoffice2k path="E:\Val_Results"(url=none) file="graph2.html" newfile=output style=normal;

title1 "Amt Development by Age";

symbol1 interpol=join value=dot;

proc gplot data= Test;

  plot Amt*Age=Dev_YR / hminor=0 autovref;

  by Dev_YR_MNTH;

run;

title;

footnote;

ods msoffice2k close;

********************** ( 3 )  ******************************;

ods msoffice2k path="E:\Val_Results"(url=none) file="graph3.html" newfile=output style=normal;

ods listing ;

ods graphics / reset width=11in height=16in;

proc sgpanel data=Test;        /* procedure statement */

  panelby Dev_YR /

novarname spacing=10 rows=5 ; /* classification statement */

  vline  Age /response=Amt group=Dev_YR_MNTH;            /* plot statement */

rowaxis offsetmin=0 offsetmax=.1 max=30;

run;

title;

footnote;

ods msoffice2k close;

*****************************************************;

A part of the data follows since I am not allowed to upload the whole thing

The rest of it goes similarly

  2010-AYMNTH-02   to  2010-AYMNTH-12   for Dev_Years 2010 to 2014 inclusive in total  3.600 Rows

Dev_YR_MNTH	Age	Label	Dev_YR	Amt
2010-AYMNTH-01	Age_001	001	2010	2,850,099
2010-AYMNTH-01	Age_002	002	2010	11,117,981
2010-AYMNTH-01	Age_003	003	2010	34,867,950
2010-AYMNTH-01	Age_004	004	2010	23,447,194
2010-AYMNTH-01	Age_005	005	2010	24,293,656
2010-AYMNTH-01	Age_006	006	2010	32,975,181
2010-AYMNTH-01	Age_007	007	2010	26,220,039
2010-AYMNTH-01	Age_008	008	2010	26,635,979
2010-AYMNTH-01	Age_009	009	2010	31,923,086
2010-AYMNTH-01	Age_010	010	2010	26,892,443
2010-AYMNTH-01	Age_011	011	2010	27,122,684
2010-AYMNTH-01	Age_012	012	2010	30,580,320
2010-AYMNTH-01	Age_013	013	2010	28,245,592
2010-AYMNTH-01	Age_014	014	2010	28,541,518
2010-AYMNTH-01	Age_015	015	2010	30,710,224
2010-AYMNTH-01	Age_016	016	2010	29,069,422
2010-AYMNTH-01	Age_017	017	2010	29,359,624
2010-AYMNTH-01	Age_018	018	2010	30,458,658
2010-AYMNTH-01	Age_019	019	2010	29,542,177
2010-AYMNTH-01	Age_020	020	2010	29,618,125
2010-AYMNTH-01	Age_021	021	2010	30,443,552
2010-AYMNTH-01	Age_022	022	2010	29,660,592
2010-AYMNTH-01	Age_023	023	2010	30,039,276
2010-AYMNTH-01	Age_024	024	2010	30,581,351
2010-AYMNTH-01	Age_025	025	2010	29,989,269
2010-AYMNTH-01	Age_026	026	2010	30,095,406
2010-AYMNTH-01	Age_027	027	2010	30,694,898
2010-AYMNTH-01	Age_028	028	2010	30,182,014
2010-AYMNTH-01	Age_029	029	2010	30,212,399
2010-AYMNTH-01	Age_030	030	2010	30,525,439
2010-AYMNTH-01	Age_031	031	2010	30,195,822
2010-AYMNTH-01	Age_032	032	2010	30,192,999
2010-AYMNTH-01	Age_033	033	2010	30,499,030
2010-AYMNTH-01	Age_034	034	2010	30,411,645
2010-AYMNTH-01	Age_035	035	2010	30,399,975
2010-AYMNTH-01	Age_036	036	2010	30,504,148
2010-AYMNTH-01	Age_037	037	2010	30,384,613
2010-AYMNTH-01	Age_038	038	2010	30,346,111
2010-AYMNTH-01	Age_039	039	2010	30,441,818
2010-AYMNTH-01	Age_040	040	2010	30,309,287
2010-AYMNTH-01	Age_041	041	2010	30,319,272
2010-AYMNTH-01	Age_042	042	2010	30,422,982
2010-AYMNTH-01	Age_043	043	2010	30,316,635
2010-AYMNTH-01	Age_044	044	2010	30,311,218
2010-AYMNTH-01	Age_045	045	2010	30,418,184
2010-AYMNTH-01	Age_046	046	2010	30,268,734
2010-AYMNTH-01	Age_047	047	2010	30,253,868
2010-AYMNTH-01	Age_048	048	2010	30,424,075
2010-AYMNTH-01	Age_049	049	2010	30,326,897
2010-AYMNTH-01	Age_050	050	2010	30,378,397
2010-AYMNTH-01	Age_051	051	2010	30,472,322
2010-AYMNTH-01	Age_052	052	2010	30,366,263
2010-AYMNTH-01	Age_053	053	2010	30,366,263
2010-AYMNTH-01	Age_054	054	2010	30,471,581
2010-AYMNTH-01	Age_055	055	2010	30,523,409
2010-AYMNTH-01	Age_056	056	2010	30,522,997
2010-AYMNTH-01	Age_057	057	2010	30,529,264
2010-AYMNTH-01	Age_058	058	2010	30,559,098
2010-AYMNTH-01	Age_059	059	2010	30,559,098
2010-AYMNTH-01	Age_060	060	2010	30,573,054

[Reeza]

60 graphs while I would wish to have them all in one page side-by-side.

Can you explain what you mean by that?

You want 60 graphs on one page, or 60 lines on one graph?

Can you post a sample of what you're looking to achieve?

[DanH_sas]

Try your SGPANEL code again; but, on the PANELBY statement, add the option ONEPANEL. That will force all of the panel cells to be on one page. Be sure you make the width and height big enough to hold them. Hope this helps!