Superfunction INTNX will help you 🙂   data have1; length id date_daily ret date_month 8; informat date_daily anydtdte.; format date_daily yymmdd10. date_month yymmn6.; input id date_daily ret; date_month = intnx('month',date_daily,0,'end'); datalines; 40 3/3/2005 -0.30 40 6/23/2010 0.28 45 12/15/2015 -0.08 48 10/31/2008 -0.01 48 7/7/2007 0.78 48 1/20/2013 0.54 ; run; data have2; length id date_month value 8; informat date_month anydtdte.; format date_month yymmn6.; input id date_month value; datalines; 40 3/31/2005 12 40 4/30/2005 7 40 8/31/2009 10 40 6/30/2010 20 45 10/31/2015 40 45 11/30/2015 42 45 12/31/2015 24 48 10/31/2008 18 48 11/30/2008 45 48 1/20/2013 33 48 7/31/2006 12 48 7/31/2007 10 48 1/31/2013 29 ; run; proc sql; create table want as select a.id, a.date_month,a.ret, b.value from have1 as a left join have2 as b on a.id = b.id and a.date_month=b.date_month ; quit; ... View more

Ok, i think i get it. In newer versions of VA you will have dynamic text that might be better than the button bar. But in 7.1 you could use the pie chart (which allows aggregated/grouped values) and remove the actual pie and only show the text. Maybe if you use one pie for each level och your hierarchy you would get what you want?   Lets say in the first report you show one pie with sa1-sa4. In the next report wou show the same pie and another with the next level FAC1-FAC4, and so on. You create interactions to each of the objects and filter them due to the selections made?   //Fredrik ... View more

Try using Format:     ... View more

Try creating an own graph using the grapgh designer. Choose Bar chart and line chart. You should be able to stack the barchart and have the line at the same time 🙂   //Fredrik ... View more

One way without coding is to open management console and right-click on the SAS Folders folder in then Folders view and select Export SAS Package. On the first page you can filter on reports and when you click next you will se a list of all reports in your repository.   //Fredrik   ... View more

Hmm, I think it works when I run it 🙂   Does your code look like this:   data one; length id 8 first_term $6 program$32; input id first_term program; datalines; 610 199601 Libarts 610 201001 Medtran 610 201102 Photo 510 199701 Libarts1 510 201101 Medtran1 510 201302 Photo1 ; run; data two; length Id 8 Term $6 CRN $32; input id term crn; datalines; 610 199602 211 610 199702 213 610 200501 102 610 200903 302 610 200903 321 610 201001 124 610 201001 153 610 201001 150 610 201001 142 610 201002 225 610 201002 242 610 201002 244 610 201003 316 610 201101 103 610 201101 121 610 201101 142 610 201101 145 610 201102 242 610 201102 242 610 201103 315 610 201201 140 610 201201 140 610 201201 150 610 201202 211 610 201202 241 610 201202 242 510 199702 211 510 199802 213 510 200601 102 510 200904 302 510 200905 321 510 201101 124 510 201101 153 510 201101 150 510 201101 142 510 201102 225 510 201102 242 510 201102 244 510 201103 316 510 201401 103 510 201401 121 ; run; proc sort data=one; by id descending first_term; run; data one; set one; by id descending first_term; length fromdate todate $6; fromdate = first_term; todate = lag(first_term); if first.id then todate = '599901'; run; proc sql; create table tog as select two.id, two.term, two.crn, one.program from one inner join two on one.id = two.id and one.fromdate <= two.term < one.todate ; run; ... View more