SS V9.4 on Windows Server
My data includes a date/time field (CurrentTime) and an interval of time in minutes (CTDelta_Time_In_Minutes). The SGPLOT should have the CurrentTime value on the x-axis and the CTDelta_Time_In_Minutes on the y-axis....and it doesn't.
The CurrentTime value is date/time including seconds. There may be as many as 12 records for every hour. The input dataset could contain weeks, maybe even months, of data.
The problem is the legend is unintelligible. I think it's trying to list every value on the chart and that could be thousands.
What I'd like is to have something like every hour as a marker. Can you offer advice?
SAS code is attached. Also a PDF of the plot is attached as a PDF.
filename URMETRCS 'z:\Mainframe\lchristensen\URMETRCS\URMETRCS_RPT.csv';
proc import datafile="URMETRCS" out=Work.Report_CSV dbms=csv;
Data Work.URMETRCS_EVENTLOG Work.CTDelta_Time;
infile URMETRCS end=eof length=reclen missover;
format CTDelta_Minutes 6.0;
CTDelta_Minutes = (CTDelta_Secs / 60); /* convert CTDelta_Secs to minutes */
proc print data=Work.Read_CSV noobs uniform;
proc sort data=Work.Read_CSV nodupkey;
proc sgplot data=Work.Read_CSV; /* graph with date/time on bottom and CTDelta_Time on y axis */
series x = CurrentTime y = CTDelta_Minutes ;
/* xaxis type = discrete; */
title1 "Hitachi Mainframe Replication Extenstion";
title2 "CTDelta Time in Minutes by Date/Time";
ods pdf close;
One clarification on the terminology - I think you mean the X-axis, rather than the Legend(?)
Since I don't have your data, I can't say for certain - but I suspect that the value you're plotting on the x-axis is character, rather than a numeric/datetime value. Convert those character values to numeric/datetime values, and then SAS won't feel compelled to show every x-value on the axis. 🙂
SAS is headed back to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team.
Interested in speaking? Content from our attendees is one of the reasons that makes SAS Innovate such a special event!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.