topic Re: Sgplot in SAS Programming

Sgplot

Vasundha — Mon, 21 Nov 2022 11:39:47 GMT

Hi Everyone.

I created a line chart in sas eg by taking a table as input which has date values of every Monday to Thursday. When I take last 7 days data from that table, I was getting non existing date values in my report also. Could anyone please help me out to get rid of them. Thanks. I've attached the sample report of it. As you see the below attached report, actually I don't have 11Nov, 12, 13 in my input table but still I was getting them that shouldn't happen.

Here's my code for line chart proc sgplot:

Proc sgplot data=have nocycleattrs;
Series x = dates y= A / lineattrs=(color=blue);
Series x = dates y= B / lineattrs=(color=green);
Series x = dates y= C / lineattrs=(color=red);
run;

Re: Sgplot

PeterClemmensen — Mon, 21 Nov 2022 12:01:27 GMT

Can you attach some sample data? Makes it easier to help you.

Re: Sgplot

Vasundha — Mon, 21 Nov 2022 12:16:46 GMT

Sure here it is :

Data have;
Input in_date : date9. readings;
format in_date date9.;
Datalines;
08Nov2022 89
09NOV2022 61
10NOV2022 60
14NOV2022 53
15NOV2022 45
16NOV2022 15
17NOV2022 12
;
run;

Re: Sgplot

Kurt_Bremser — Mon, 21 Nov 2022 12:21:32 GMT

This is not the dataset you use in your SGPLOT procedure, none of the variables used in the plot are there. Please post the real dataset with variables dates, a, b and c.

Re: Sgplot

PeterClemmensen — Mon, 21 Nov 2022 12:28:06 GMT

Your posted data does not contain the variables from the posted PROC SGPLOT Code.

However, I interpret your problem like this. You do not have 11, 12, 13 Nov in your data. So you do not want to display them in your graph.

You can add the line below in your code to achieve this.

xaxis type = discrete;

Re: Sgplot

Vasundha — Mon, 21 Nov 2022 12:30:26 GMT

Extremely Sorry here it is.

Data have;
Input dates : date9. A B C;
format dates date9.;
Datalines;
08Nov2022 89 468  120
09NOV2022 61 345 287
10NOV2022 60 900 111
14NOV2022 53 127 123
15NOV2022 45 460 430
16NOV2022 15 230 550
17NOV2022 12 310 589
;
run;

Re: Sgplot

Vasundha — Mon, 21 Nov 2022 12:32:14 GMT

It worked, please fill your heart heartily thanked.

Re: Sgplot

PeterClemmensen — Mon, 21 Nov 2022 12:33:13 GMT

Heartily filled 🙂

Re: Sgplot

Kurt_Bremser — Mon, 21 Nov 2022 12:33:57 GMT

To avoid autofill of dates, use VLINE instead of SERIES.