09-19-2017 04:31 AM
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
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.(Eg 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.
09-19-2017 09:57 AM
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.
09-19-2017 10:59 AM
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.
09-20-2017 02:27 AM - edited 09-20-2017 02:28 AM
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.