Prev: reading xls without proc import or changing file type
Next: Siebel Business Analyst with Pharma -- Milpitas CA
From: db on 18 Mar 2010 16:35
Hi I am tring to draw a graph with following dataset. but because they
are not in same scale, it just gives me 3 straight lines if I ovelay
them together. Is there a way to improve my gplot logic to see actual
movements on the lines ? Thanks

data have;
input n var1 var2 var3;
datalines;

1 9.091894617 9.644068945 9.161465204
2 9.092007185 9.644911105 9.161885152
3 9.091218941 9.643939319 9.161570208
4 9.091782036 9.644328147 9.161885152
5 9.092232284 9.644392937 9.161990111
6 9.092232284 9.644587282 9.161990111
7 9.092569836 9.644781588 9.162199997
8 9.093019729 9.644716824 9.162304923
9 9.092569836 9.643939319 9.161780181
10 9.092007185 9.644068945 9.162095059
11 9.092344814 9.643809677 9.162095059
12 9.092344814 9.6438745 9.161780181
13 9.092569836 9.644198555 9.162095059
14 9.093019729 9.644457723 9.162095059
15 9.093357017 9.644587282 9.162409838
16 9.093357017 9.644068945 9.162095059
17 9.093357017 9.643939319 9.162095059
18 9.094143578 9.644263353 9.163039099
19 9.094255893 9.644522504 9.16293425
20 9.094368196 9.644587282 9.163039099
21 9.094480486 9.644522504 9.163039099
22 9.094143578 9.644392937 9.162829389
23 9.09346942 9.644652055 9.162724518
24 9.09369419 9.644587282 9.162724518
25 9.09403125 9.644846349 9.163248764
26 9.094480486 9.645105349 9.163353581
27 9.094592763 9.645299555 9.16356318
28 9.094705028 9.645364282 9.16356318
29 9.095041748 9.645687855 9.163772736
;
run;

proc gplot data=have;
plot var1*n var2*n var3*n / overlay;
run;
From: Paige Miller on 19 Mar 2010 08:09
On Mar 18, 4:35 pm, db <daronnebonn...(a)gmail.com> wrote:
> Hi I am tring to draw a graph with following dataset. but because they
> are not in same scale, it just gives me 3 straight lines if I ovelay
> them together. Is there a way to improve my gplot logic to see actual
> movements on the lines ? Thanks
>
> data have;
> input n var1 var2 var3;
> datalines;
>
> 1       9.091894617     9.644068945     9.161465204
> 2       9.092007185     9.644911105     9.161885152
> 3       9.091218941     9.643939319     9.161570208
> 4       9.091782036     9.644328147     9.161885152
> 5       9.092232284     9.644392937     9.161990111
> 6       9.092232284     9.644587282     9.161990111
> 7       9.092569836     9.644781588     9.162199997
> 8       9.093019729     9.644716824     9.162304923
> 9       9.092569836     9.643939319     9.161780181
> 10      9.092007185     9.644068945     9.162095059
> 11      9.092344814     9.643809677     9.162095059
> 12      9.092344814     9.6438745       9.161780181
> 13      9.092569836     9.644198555     9.162095059
> 14      9.093019729     9.644457723     9.162095059
> 15      9.093357017     9.644587282     9.162409838
> 16      9.093357017     9.644068945     9.162095059
> 17      9.093357017     9.643939319     9.162095059
> 18      9.094143578     9.644263353     9.163039099
> 19      9.094255893     9.644522504     9.16293425
> 20      9.094368196     9.644587282     9.163039099
> 21      9.094480486     9.644522504     9.163039099
> 22      9.094143578     9.644392937     9.162829389
> 23      9.09346942      9.644652055     9.162724518
> 24      9.09369419      9.644587282     9.162724518
> 25      9.09403125      9.644846349     9.163248764
> 26      9.094480486     9.645105349     9.163353581
> 27      9.094592763     9.645299555     9.16356318
> 28      9.094705028     9.645364282     9.16356318
> 29      9.095041748     9.645687855     9.163772736
> ;
> run;
>
> proc gplot data=have;
>         plot var1*n  var2*n var3*n / overlay;
> run;

For you to get a plot showing "movement" on the lines, you can either:

1) Not put them on the same vertical axis
2) Use separate vertical axes for two of them (PLOT2 statement)
3) Standardize the data first (PROC STANDARD)

--
Paige Miller
paige\dot\miller \at\ kodak\dot\com
 | 
Pages: 1
Prev: reading xls without proc import or changing file type
Next: Siebel Business Analyst with Pharma -- Milpitas CA