topic Re: SGPLOT XAXIS WEEK VALUES FROM START OF WEEK TO END OF WEEK in Graphics Programming

SGPLOT XAXIS WEEK VALUES FROM START OF WEEK TO END OF WEEK

erikhendrickson — Tue, 11 Jan 2022 04:56:54 GMT

I am trying to figure out how to make my xaxis with the weekly intervals list the end of week (Saturday) rather than the start of the week (Sunday). Any help would be greatly appreciated. proc sgplot data=merged_gender (where=(&period)) dattrmap=attrmap; title1 "Opioid Encounters by Gender"; yaxis label="Number of Encounters"; series y=MovAv_OPIOID_ENCOUNTER x=admitdt1 / group=gender attrid=gender name="series1" lineattrs=(pattern=solid thickness=2); reg y=OPIOID_ENCOUNTER x=admitdt1 / group=gender nomarkers attrid=gender lineattrs=(pattern=dash thickness=2); xaxis label="Encounter Date" tickvalueformat=mmddyy8. interval=week offsetmin=0 offsetmax=0; symbol1 interpol=join width=10 ci=cxEC8B16 cv=cx546EF0; keylegend "series1" / title=''; run;

Re: SGPLOT XAXIS WEEK VALUES FROM START OF WEEK TO END OF WEEK

Ksharp — Tue, 11 Jan 2022 11:41:19 GMT

data have;
call streaminit(123);
do date='04jan2020'd to '01jun2020'd;
y=rand('uniform');output;
end;
format date date9.;
run;

proc sgplot data=have;
series x=date y=y;
xaxis type=linear  values=('04jan2020'd to '01jun2020'd by week) fitpolicy=rotate ;
run;

Re: SGPLOT XAXIS WEEK VALUES FROM START OF WEEK TO END OF WEEK

erikhendrickson — Tue, 11 Jan 2022 19:04:30 GMT

Thank you!

Is there a way to do the same process but with a date format mmddyy8. ?

Re: SGPLOT XAXIS WEEK VALUES FROM START OF WEEK TO END OF WEEK

Ksharp — Wed, 12 Jan 2022 12:31:43 GMT

of course. Just change format:
format date date9.;
---->
format date mmddyy8.;