topic Excel Export in SAS Programming

Excel Export

overky — Thu, 03 Aug 2017 19:27:31 GMT

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

Re: Excel Export

PeterClemmensen — Thu, 03 Aug 2017 19:37:15 GMT

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

Re: Excel Export

PaigeMiller — Thu, 03 Aug 2017 19:37:26 GMT

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

Re: Excel Export

novinosrin — Thu, 03 Aug 2017 19:38:25 GMT

@PaigeMiller i love that. Cheers! lol

Re: Excel Export

overky — Thu, 03 Aug 2017 19:49:04 GMT

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.

Re: Excel Export

PaigeMiller — Thu, 03 Aug 2017 20:07:28 GMT

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.

Re: Excel Export

overky — Thu, 03 Aug 2017 20:07:56 GMT

Loop makes sense.