topic Re: Sgplot SCATTER Axis Range Order of Ranges in Graphics Programming

Sgplot SCATTER Axis Range Order of Ranges

SSTEAD — Fri, 24 Apr 2020 22:47:00 GMT

I am trying to plot an end of work, that extends beyond a given time boundary. The typical day is 07:00 - 07:00 (wraps over midnight) So I would like to display the scatter 07:00-24:00, a break and then 00:00-06:59; The Date is on the Y axis and the end

Time is on the X axis. Ranges works, but reorders the ranges, so it displays 0:00-24:00, rather than 07:00-24:00 a break and then 00:00-6:59.

How can I force the order of the ranges?

Thank you.

proc sgplot data=xxxx;
STYLEATTRS datacontrastcolors =(pink red) datasymbols=(circlefilled);
SCATTER X=bTimeOut Y=bDateIn /group=bCaseType
;
yaxis display=(nolabel) REVERSE values=('Jan2019' 'Feb2019' 'Mar2019' 'Apr2019' 'May2019' 'Jun2019'
'Jul2019' 'Aug2019' 'Sep2019' 'Oct2019' 'Nov2019' 'Dec2019');
xaxis label='Last Case Ending (hr)' ranges=('07:00't - '24:00't '00:00't - '06:59't);

run;

Re: Sgplot SCATTER Axis Range Order of Ranges

Jagadishkatam — Sat, 25 Apr 2020 09:29:42 GMT

Could you please try the below range

ranges=('00:00't - '06:59't '07:00't - '24:00't)

Re: Sgplot SCATTER Axis Range Order of Ranges

SSTEAD — Sat, 25 Apr 2020 18:22:24 GMT

No change.

Re: Sgplot SCATTER Axis Range Order of Ranges

SSTEAD — Sat, 25 Apr 2020 23:05:27 GMT

I have changed the bTimeOut variable to a datetime. It correctly places the value, but now I hav 01Jan60 and 02Jan60 suffixes after the time value on the x axis. I have tried "format bTimeOut timeampm.;" but then it reverts to a time variable and increments above 24:00 28:00, 32:00 etc. Any more ideas?

Thank you.

Re: Sgplot SCATTER Axis Range Order of Ranges

Jagadishkatam — Sun, 26 Apr 2020 06:27:18 GMT

Could you please convert the bTimeOut to timepart i.e., derive a new variable from bTimeOut like below and use the new variables for x axis

bTimeOutnew=timepart(bTimeOut);

Re: Sgplot SCATTER Axis Range Order of Ranges

SSTEAD — Sun, 26 Apr 2020 19:57:54 GMT

Jagadishkatam, Thank you for your replies.

Here is where I am today. The closest I can get is with the following:

proc sgplot data=lastchance NOAUTOLEGEND;

STYLEATTRS datacontrastcolors =(pink red) datasymbols=(circlefilled);

SCATTER X=NewTimeDateData Y=Call_Date /group=bCaseType ;

yaxis display=(nolabel)REVERSE

values=('Jan2019' 'Feb2019' 'Mar2019' 'Apr2019' 'May2019' 'Jun2019'

'Jul2019' 'Aug2019' 'Sep2019' 'Oct2019' 'Nov2019' 'Dec2019');

xaxis label='Last Case Ending (hr)'

/* ranges=('07:00't - '24:00't '24:00't-'48:00't) */

;

Title "Ending Time of Last Case of Day" ;

run;

It does plot it correctly, but I since I "normalized" the datetime value to cover each day with a possible day+1 overlap, I get the dates printed.

If I add the following format to NewTimeDateData :

format NewTimeDateData timeampm8. ;

I get the following message:

NOTE: The column format TIMEAMPM8 is replaced by an auto-generated format on the axis.

and the output displays this:

If I create bTimeOut to timepart:

It combines the day0 values and day1 values. Not what I wanted

Re: Sgplot SCATTER Axis Range Order of Ranges

Jagadishkatam — Mon, 27 Apr 2020 05:38:32 GMT

Is it possible to post the dataset screenshot, I wanted to check instead of the format, we need to derive the separate time variable and use that as x axis. I am not sure if you are doing it.

Re: Sgplot SCATTER Axis Range Order of Ranges

DanH_sas — Mon, 27 Apr 2020 12:20:52 GMT

Try using your normalized data time values, but get rid of the VALUES option and add the NOTIMESPLIT option, and the VALUESFORMAT option with a time format. Let me know if that works for you.

Re: Sgplot SCATTER Axis Range Order of Ranges

SSTEAD — Mon, 27 Apr 2020 16:38:46 GMT

Here is the Code, Dataset Screenshot and resulting Plot. As you can see, it is incorrect. I wanted the times 0:00-6:00 to follow 24:00. They neve will with this method.

proc sgplot DATA=lastchance ;

format bTimeOutnew time. ;

SCATTER X=bTimeOutnew Y=Call_Date /group=bCaseType attrid=CaseType markerattrs=(symbol=circlefilled size =11);

yaxisdisplay=(nolabel)REVERSE

values=('Jan2019' 'Feb2019' 'Mar2019' 'Apr2019' 'May2019' 'Jun2019'

'Jul2019''Aug2019''Sep2019''Oct2019''Nov2019''Dec2019');

xaxis label='Last Case Ending (hr)' ;

Title "Call Cases Using TIME FORMATTED Value" ;

run;

Re: Sgplot SCATTER Axis Range Order of Ranges

SSTEAD — Mon, 27 Apr 2020 16:44:28 GMT

Hi Dan,

Thank you very much!!! This worked! Here is the code I used and the resulting output:

proc sgplot DATA=lastchance ;

format NewTimeDateData OBStartTDdata timeampm8. ;

SCATTER X=NewTimeDateData Y=Call_Date /group=bCaseType attrid=CaseType markerattrs=(symbol=circlefilled size =11);

yaxisdisplay=(nolabel)REVERSE

values=('Jan2019' 'Feb2019' 'Mar2019' 'Apr2019' 'May2019' 'Jun2019'

'Jul2019''Aug2019''Sep2019''Oct2019''Nov2019''Dec2019');

xaxis label='Last Case Ending (hr)' VALUESFORMAT=TIMEAMPM8.;

Title "CALL CASES Using DateTime Value, Normalized to same day" ;

run;

Re: Sgplot SCATTER Axis Range Order of Ranges

DanH_sas — Mon, 27 Apr 2020 16:51:56 GMT

Try the following:

proc sgplot data=lastchance NOAUTOLEGEND; 
STYLEATTRS datacontrastcolors =(pink red) datasymbols=(circlefilled);
SCATTER X=NewTimeDateData Y=Call_Date /group=bCaseType ;
yaxis display=(nolabel)REVERSE
values=('Jan2019' 'Feb2019' 'Mar2019' 'Apr2019' 'May2019' 'Jun2019'
'Jul2019' 'Aug2019' 'Sep2019' 'Oct2019' 'Nov2019' 'Dec2019');
xaxis label='Last Case Ending (hr)' notimesplit value=time.;
Title "Ending Time of Last Case of Day" ;
run;

Re: Sgplot SCATTER Axis Range Order of Ranges

SSTEAD — Mon, 27 Apr 2020 18:49:10 GMT

That works fine, too. It is probably cleaner the way you just suggested, than declaring the format in a format statement as I did. I get tme same output, which is wanted I was looking for. Thank you.