Excel Export

[overky]

I have a dataset that has multiple "types" that I need to export to and append to different excel sheets.

Data:

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.

Suggestions?

Thanks

Kyle

[PeterClemmensen]

Use PROC EXPAND with a (where=(Type='A')) option.

For the append part of your program, check out the code in this article

http://www2.sas.com/proceedings/sugi31/024-31.pdf

[PaigeMiller]

Run a PROC EXPORT to create a sheet when TYPE='A'

Run another PROC EXPORT to the same Excel file to create a different sheet when TYPE='B'

Repeat as needed

[novinosrin]

@PaigeMiller i love that. Cheers! lol

[overky]

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.

[PaigeMiller]

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.

[overky]

Loop makes sense.