[using EG 9.4] I have a data set that looks like this: product sale_date price
abc 01/01/2018 1.13
abc 06/01/2018 1.29
abc 02/02/2018 1.23
xyz 02/01/2018 1.54
xyz 08/01/2018 1.58
xyz 03/02/2018 1.41 And I need to plot two series (one for each product) on a pbspline plot of "price vs date". I have tried a number of variations but am unable to get two separate series. Here's what I used most recently: ods graphics on / height=600 width=900 noborder;
proc sgplot data=work.product_daily_sales(where=(product IN ('abc', 'xyz')));
by product;
pbspline x=sale_date y=price / legendlabel='company1' markerattrs=(symbol=circle color=blue size=5) lineattrs=(color=blue);
pbspline x=sale_date y=price / legendlabel='company2' markerattrs=(symbol=circle color=red size=5) lineattrs=(color=red);
xaxis label='Date';
yaxis label='US Price ($)';
title 'Sales Price by date of sale';
run;
quit; Basically, I am comparing prices for a similar product to two different companies and I need to show the difference in pricing on the one graph. The above code gets me closest to what I want but displays two graphs. Can anyone help? Thanks in advance.
... View more