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
Use PROC EXPAND with a (where=(Type='A')) option.
For the append part of your program, check out the code in this article
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
@PaigeMiller i love that. Cheers! lol
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.
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.
Loop makes sense.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.