Good morning data_null; I created a mock sample of what I'm trying to accomplish and loaded it to Box.com (sharing site) https://app.box.com/s/mmapprud9sve9v1p77xr In the mock up you see on one tab PLAN_A vs. PLAN_B and on the second tab you see PLAN_B vs. PLAN_B. In our prior conversation we solved how to take the data and convert it to a point where I can do a side by side comparison of various health plans per category via TRANSPOSE and PROC REPORT. Now the additional requirement is to build a complex report with the information based on different scenarios: IE: One XLS might contain all HMO PLANS for Suffolk County and provide a side by side for PLAN_A vs each competitor. These are separated tab by tab, which means each competitor has one tab to itself per the comparison with PLAN_A (This logic I'm programming and as stated above was normal done by creating a separate dataset for each compare then exporting to the same XLS but on a different tab). The problem is how do I perform the same task with the output from proc report? I don't mind programming each data set with it's own TRANSPOSE/REPORT. If you think of all the Health Plans in NY - I'm comparing PLAN_A per each County (which creates a separate XLS for each one, Suffolk, Nassau, etc) and within each XLS are all the competitors for PLAN_A. Each one on it's own tab. PLAN_A vs PLAN_B (tab 1) PLAN_A vs PLAN_C (tab 2), etc.... When I look at last year report that was created manually it was 10 XLS documents with over 20 tabs in each XLS. This is why I need to find a way to automate the output from PROC TRANSPOSE / PROC REPORT into multiple XLS on multiple tabs based on the DATASET I define within my PROC SQL to parse the data. Pheeeeeeeeeeeeeeeeeeeewwwwwwwwwwwwwwwwwwwwwwwwwwww Derrick Rountree │ Sr. Business Data Analyst, Medicare Products │ Office (646) 447-5992
... View more