Desktop productivity for business analysts and programmers

Issue in Line Plot Graph - Horizontal axis

Reply
Frequent Contributor
Posts: 115

Issue in Line Plot Graph - Horizontal axis

Hi,

 

 

I'm using SAS EG to generate a report from a output of a query. In the Query output, the values are displayed as follows

 

Job Name : Job_XXXX

 

Month         Average Time

SEP-16      02:00:51

OCT-16      03:54:14

NOV-16      12:12:54

DEC-16      08:08:21

JAN-17       10:21:54

FEB-17       11:12:24

MAR-17      02:14:45

APR-17       05:06:45

MAY-17       05:08:21

JUN-17       12:12:12

JUL-17        08:08:07

AUG-17       09:08:17

SEP-17       10:05:35

 

While creating a line plot(Mulitple line plot from group column), I have given task roles as 

Horizontal(Limit :1) as Month

Vertical(Limit :1) as Average Time

Group(Limit : 1) as Job Name

 

and given horizontal major tricks as 13 and ran the report.

But from the output , I could not able to see all the months under horizontal axis and also I could see a strange thing that 

the values are not properly aligned in the graph.(EgSmiley Happy For horizontal axis(Dec-16), it showing Jan - 17 values (i.e 10:21:54). But when I move the cursor in the pointed value of line plot, its showing proper value as a pop - up..

 

I think, the issue is with horizontal axis displayed in the line plot.

 

Note : Month is a derived column from the date value and I have used intx function to retrieve that.  Im using SAS EG V4.1.

 

Please help me to resolve the issue. Thnaks in advance.

PROC Star
Posts: 1,334

Re: Issue in Line Plot Graph - Horizontal axis

Posted in reply to Helannivas

I tried to replicate it, and it worked perfectly for me. So, a couple of questions:

 

Is your "Month" value a SAS date value? I used a date value.

 

I didn't specity anything for the horizontal axis; I just moved the variable names to the horizontal and vertical roles, and let 'er rip.

 

Tom

 

Graph.png

Super User
Posts: 13,941

Re: Issue in Line Plot Graph - Horizontal axis

Posted in reply to Helannivas

Show the code for "deriving" your month value. I can see several ways that could be done such that you duplicate the values.

Also showing the actual code for the graph might help.

Frequent Contributor
Posts: 115

Re: Issue in Line Plot Graph - Horizontal axis

[ Edited ]

Hi,

 

Thanks for the response.

 

I have found out the solution for this. 

 

Under Horizontal major ticks , I have given "Specify"  as '01SEP16'd to '01SEP17'd by Month and the horizontal month (values) have rotated to 90 degree.

 

Now the 13 months values gets fitted into the graph and displayed proper graph.

 

Thanks

Ask a Question
Discussion stats
  • 3 replies
  • 231 views
  • 2 likes
  • 3 in conversation