DATA Step, Macro, Functions and more

How do I Chart/Plot Prior Month, Month 2 Week 1, Month 2 Week 2, etc.. YTD

Reply
Contributor CLE
Contributor
Posts: 21

How do I Chart/Plot Prior Month, Month 2 Week 1, Month 2 Week 2, etc.. YTD

Hi, I'm looking to build a report that can display the same Y axis and multiple times on the X axis -

 

Example: June (Total Month), July week 1, July week 2, July week 3, and YTD all in the same chart.  Any helpful suggestions are appreciated. 

 

I do not have VA.  SAS 9.4

Super User
Posts: 11,343

Re: How do I Chart/Plot Prior Month, Month 2 Week 1, Month 2 Week 2, etc.. YTD

Way to little information.

What type of chart? Bar, Box, series, scatter something else?

What does your data look like. Best is to post a data step of some of the data. Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat... will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.

 

Which variables are to be plotted? Sums, counts, values, percentages or ???

Ask a Question
Discussion stats
  • 1 reply
  • 72 views
  • 0 likes
  • 2 in conversation