Data visualization with SAS programming

Work Schedule month view

Reply
New Contributor
Posts: 3

Work Schedule month view

Hi.

I have just started learning SAS eg. What a great tool!!! 

currently on v9.4.

right now I'm working on a work schedule issue.

As a test-case I'm trying to replicate something I used to do in excel.

 

So this is the case.

 

INPUT:

prompts:

Schedule start (01.01.2018)

Schedule end (31.01.2018)

 

dataset:

 

 

NAME

ROLE

FROM

TO

LOCATION

TYPE

James

A

01.01.2018

09.01.2018

1A

NORMAL

James

A

19.01.2018

20.01.2018

1B

EXTRA

Anna

B

10.01.2018

18.01.2018

1C

NORMAL

Anna

B

22.01.2018

30.01.2018

1B

NORMAL

Peter

C

04.01.2018

13.01.2018

1A

NORMAL

Peter

C

18.01.2018

23.01.2018

1C

NORMAL

Kath

D

15.01.2018

15.01.2018

1C

EXTRA

 

OUTPUT:

 

se attached file: ScheduleOUTPUT.pdf

 

----

 

Is this possible?

If so, where to start?

 

Thank you!

 

Br,

Bjoern

Super User
Posts: 20,203

Re: Work Schedule month view

Yes it's possible. I would start with PROC REPORT and picking a destination, ie do you want PDF or XLSX file. 

 

Highlighting/traffic lighting is very well documented across the forum here or on lexjansen.com you'll find lots of examples.

 

New Contributor
Posts: 3

Re: Work Schedule month view

Hi. thanks for a quick reply.

I guess excel is what I need.

or PDF, the easiest way?.

Ask a Question
Discussion stats
  • 2 replies
  • 75 views
  • 0 likes
  • 2 in conversation