topic Re: Work Schedule month view in Graphics Programming https://communities.sas.com/t5/Graphics-Programming/Work-Schedule-month-view/m-p/407075#M13904 <P>Yes it's possible. I would start with PROC REPORT and picking a destination, ie do you want PDF or XLSX file.&nbsp;</P> <P>&nbsp;</P> <P>Highlighting/traffic lighting is very well documented across the forum here or on lexjansen.com you'll find lots of examples.</P> <P>&nbsp;</P> Tue, 24 Oct 2017 20:57:14 GMT Reeza 2017-10-24T20:57:14Z Work Schedule month view https://communities.sas.com/t5/Graphics-Programming/Work-Schedule-month-view/m-p/407072#M13903 <P>Hi.</P><P>I have just started learning SAS eg. What a great tool!!!&nbsp;</P><P>currently on v9.4.</P><P>right now I'm working on a work schedule issue.</P><P>As a test-case I'm trying to replicate something I used to do in excel.</P><P>&nbsp;</P><P>So this is the case.</P><P>&nbsp;</P><P>INPUT:</P><P>prompts:</P><P>Schedule start (01.01.2018)</P><P>Schedule end (31.01.2018)</P><P>&nbsp;</P><P>dataset:</P><P>&nbsp;</P><P>&nbsp;</P><TABLE cellspacing="0" cellpadding="0"><TBODY><TR><TD><P><FONT color="#0000FF">NAME</FONT></P></TD><TD><P><FONT color="#0000FF">ROLE</FONT></P></TD><TD><P><FONT color="#0000FF">FROM</FONT></P></TD><TD><P><FONT color="#0000FF">TO</FONT></P></TD><TD><P><FONT color="#0000FF">LOCATION</FONT></P></TD><TD><P><FONT color="#0000FF">TYPE</FONT></P></TD></TR><TR><TD><P>James</P></TD><TD><P>A</P></TD><TD><P>01.01.2018</P></TD><TD><P>09.01.2018</P></TD><TD><P>1A</P></TD><TD><P>NORMAL</P></TD></TR><TR><TD><P>James</P></TD><TD><P>A</P></TD><TD><P>19.01.2018</P></TD><TD><P>20.01.2018</P></TD><TD><P>1B</P></TD><TD><P>EXTRA</P></TD></TR><TR><TD><P>Anna</P></TD><TD><P>B</P></TD><TD><P>10.01.2018</P></TD><TD><P>18.01.2018</P></TD><TD><P>1C</P></TD><TD><P>NORMAL</P></TD></TR><TR><TD><P>Anna</P></TD><TD><P>B</P></TD><TD><P>22.01.2018</P></TD><TD><P>30.01.2018</P></TD><TD><P>1B</P></TD><TD><P>NORMAL</P></TD></TR><TR><TD><P>Peter</P></TD><TD><P>C</P></TD><TD><P>04.01.2018</P></TD><TD><P>13.01.2018</P></TD><TD><P>1A</P></TD><TD><P>NORMAL</P></TD></TR><TR><TD><P>Peter</P></TD><TD><P>C</P></TD><TD><P>18.01.2018</P></TD><TD><P>23.01.2018</P></TD><TD><P>1C</P></TD><TD><P>NORMAL</P></TD></TR><TR><TD><P>Kath</P></TD><TD><P>D</P></TD><TD><P>15.01.2018</P></TD><TD><P>15.01.2018</P></TD><TD><P>1C</P></TD><TD><P>EXTRA</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>OUTPUT:</P><P>&nbsp;</P><P>se attached file: ScheduleOUTPUT.pdf</P><P>&nbsp;</P><P>----</P><P>&nbsp;</P><P>Is this possible?</P><P>If so, where to start?</P><P>&nbsp;</P><P>Thank you!</P><P>&nbsp;</P><P>Br,</P><P>Bjoern</P> Tue, 24 Oct 2017 20:49:53 GMT https://communities.sas.com/t5/Graphics-Programming/Work-Schedule-month-view/m-p/407072#M13903 Number7 2017-10-24T20:49:53Z Re: Work Schedule month view https://communities.sas.com/t5/Graphics-Programming/Work-Schedule-month-view/m-p/407075#M13904 <P>Yes it's possible. I would start with PROC REPORT and picking a destination, ie do you want PDF or XLSX file.&nbsp;</P> <P>&nbsp;</P> <P>Highlighting/traffic lighting is very well documented across the forum here or on lexjansen.com you'll find lots of examples.</P> <P>&nbsp;</P> Tue, 24 Oct 2017 20:57:14 GMT https://communities.sas.com/t5/Graphics-Programming/Work-Schedule-month-view/m-p/407075#M13904 Reeza 2017-10-24T20:57:14Z Re: Work Schedule month view https://communities.sas.com/t5/Graphics-Programming/Work-Schedule-month-view/m-p/407088#M13905 <P>Hi. thanks for a quick reply.</P><P>I guess excel is what I need.</P><P>or PDF, the easiest way?.</P> Tue, 24 Oct 2017 21:36:19 GMT https://communities.sas.com/t5/Graphics-Programming/Work-Schedule-month-view/m-p/407088#M13905 Number7 2017-10-24T21:36:19Z