Since datetimes are numbers of seconds change any increment to a multiple you like: do temp=first_time to second_time by 60; if weekday(datepart(temp)) ne 1 and datepart(temp) ne holiday('NEWYEAR',year(datepart(temp))) and datepart(temp) ne holiday('MEMORIAL',year(datepart(temp))) and datepart(temp) ne holiday('USINDEPENDENCE',year(datepart(temp))) and datepart(temp) ne holiday('LABOR',year(datepart(temp))) and datepart(temp) ne holiday('THANKSGIVING',year(datepart(temp))) and datepart(temp) ne holiday('CHRISTMAS',year(datepart(temp))) then seconds+60; end; increments by 60 seconds or one minute   do temp=first_time to second_time by 3600; if weekday(datepart(temp)) ne 1 and datepart(temp) ne holiday('NEWYEAR',year(datepart(temp))) and datepart(temp) ne holiday('MEMORIAL',year(datepart(temp))) and datepart(temp) ne holiday('USINDEPENDENCE',year(datepart(temp))) and datepart(temp) ne holiday('LABOR',year(datepart(temp))) and datepart(temp) ne holiday('THANKSGIVING',year(datepart(temp))) and datepart(temp) ne holiday('CHRISTMAS',year(datepart(temp))) then seconds+3600; end; increment by 3600 seconds or 1 hour. 24*3600= 24 hours (1 day).     ... View more

Being "old school" I would plot the lines, and then annotate the markers (using data step logic when you create the annotate dataset, to control which markers to use). ... View more

apologies I misunderstood - the +3 finds the position of 'Z' - remove it (or change to +0) to get position of string ... View more

This is perfect! And so simple too. Thank you! ... View more

Thank you! This works too. ... View more

These work around codes work for me. Now, I'm having the percentage display on the bars (datalabel). Is it possible to limit the decimal places to one only. It's displaying 3 and that's too much.   Thanks.   ... View more

Hello @kz_ ,   I erase all observations on purpose (to have zero observations). The 2nd data-step should work fine. I can submit it over here. Very weird!   Koen ... View more

proc catalog catalog=work.formats; delete gen.format; run; ... View more

One way to accomplish what you're wanting is to loop through the values and call a macro, rather than using the built-in 'by' statement. Here is a minimal example demonstrating how to do it that way:   data my_data; set sashelp.electric; run; %macro do_graphs(cust); data tempdata; set my_data (where=(customer="&cust")); run; title "&cust"; proc sgplot data=tempdata; series x=year y=revenue; run; proc sgplot data=tempdata; histogram revenue; run; proc sgplot data=tempdata; heatmap x=year y=revenue; run; %mend; proc sql; create table loopdata as select unique customer from my_data; quit; run; data _null_; set loopdata; call execute('%do_graphs('|| customer ||');'); run; ... View more

Being "old school" I would plot the lines, and then annotate the markers (using data step logic when you create the annotate dataset, to control which markers to use). ... View more