SGPLOT creating vertical lines for each data point

[lchristensen]

I have code creating a plot via SGPLOT. The output has vertical lines for each data point. I want a line graph with each series. How we I get rid of the vertical lines?

[PaigeMiller]

Code should be posted as text in the SAS code box (click on the "little running man" icon). Since I never download file attachments, I request you include a screen capture of your graph in your reply by clicking on the "Insert Photos" icon.

[lchristensen]

One person wants it imbedded as text, another as an attachment. 

[lchristensen]

Proc Sort data=Work.Read_Port;
by SMFDTIME RRS5POID;
run;
ods pdf file = "z:\Mainframe\GPSE\MAR and HMAI\HMAI Samples\POID.pdf";
proc sgplot data=Work.Read_Port;
series y = RRS5ERCS x = SMFDTIME;
series y = RRS5EWCS x = SMFDTIME;
title1 'Hitachi Mainframe Analytic Interpreter: Subtype-5, RRS5ERCS, RRS5EWCS';
run;
ods pdf startpage=now;
ods pdf close;

[ballardw · Accepted solution]

You need to include data as well.

XAXIS DISCRETE is intended for x values that aren't continuous, or nearly so.

Series plots generally assume that axis values will be continuous.

So it is unlikely that you actually want a DISCRETE axis for a SERIES plot. I sugges removing your XAXIS Discrete option and see if things make more sense.

[lchristensen]

Removing XAXIS discrete made no difference, I actually put that in hoping it would.

[lchristensen]

I printed the data and there were multiple values for the RRS5POID and it interleaved them since it was sorted by date/time/RRS5POID and some of the RRS5POID values were zeroes. Adding a 'by SMFRSSN RRS5POID' gave me the proper results.

Thank you