08-03-2017 03:27 PM
I have a dataset that has multiple "types" that I need to export to and append to different excel sheets.
Type Dist1 Dist2 Dist3
A 0 0 2
B 1 1 23
C 23 32 45
Excel Workbook has 3 sheets (A, B, C) All "A" data each week needs apppended to the "A" sheet and so forth.
08-03-2017 03:37 PM
Use PROC EXPAND with a (where=(Type='A')) option.
For the append part of your program, check out the code in this article
08-03-2017 03:49 PM
Yes, I knew I could write multiple export statements did not know if they could be combined in anyway to shorten coding as I have lets say 26 types that all go to different sheets in different workbooks. But if not then I will write the multiple lines of code.
08-03-2017 04:06 PM - edited 08-03-2017 04:07 PM
This is an example where a macro could loop through all "types" and get the job done.
... if they could be combined in anyway to shorten coding as I have lets say 26 types that all go to different sheets in different workbooks ...
Sure would have been helpful to mention this in your first message.