DATA Step, Macro, Functions and more

Excel Export

Reply
Occasional Contributor
Posts: 19

Excel Export

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

PROC Star
Posts: 551

Re: Excel Export

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

Trusted Advisor
Posts: 1,615

Re: Excel Export

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

PROC Star
Posts: 172

Re: Excel Export

@PaigeMiller i love that. Cheers! lol

Occasional Contributor
Posts: 19

Re: Excel Export

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.

Trusted Advisor
Posts: 1,615

Re: Excel Export

[ Edited ]

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.

Occasional Contributor
Posts: 19

Re: Excel Export

Loop makes sense.

Ask a Question
Discussion stats
  • 6 replies
  • 82 views
  • 1 like
  • 4 in conversation