topic SGPLOT creating vertical lines for each data point in Statistical Procedures

SGPLOT creating vertical lines for each data point

lchristensen — Sun, 07 Aug 2022 18:40:43 GMT

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?

Re: SGPLOT creating vertical lines for each data point

PaigeMiller — Sun, 07 Aug 2022 20:25:38 GMT

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.

Re: SGPLOT creating vertical lines for each data point

ballardw — Sun, 07 Aug 2022 20:50:44 GMT

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.

Re: SGPLOT creating vertical lines for each data point

lchristensen — Sun, 07 Aug 2022 23:23:55 GMT

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

Re: SGPLOT creating vertical lines for each data point

lchristensen — Sun, 07 Aug 2022 23:25:09 GMT

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

Re: SGPLOT creating vertical lines for each data point

lchristensen — Sun, 07 Aug 2022 23:26:22 GMT

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;

Re: SGPLOT creating vertical lines for each data point

lchristensen — Mon, 08 Aug 2022 00:37:58 GMT

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