Hi Team,
I am creating one excel report from a dataset with two months of data set and I want to create 2 tables on one tab in excel file for each months data.
Please help
Thanks
@kajal_30 wrote:
Hi Team,
I am creating one excel report from a dataset with two months of data set and I want to create 2 tables on one tab in excel file for each months data.
If you are using ODS EXCEL, you can use the option sheet_interval='NONE' which forces all output onto one tab (until you change it).
Since there's no date, here's an example using SASHELP.CLASS and using BY group processing for 2 age values:
If you don't like the BY line, you can turn that off using system options.
Hope this helps,
Cynthia
Thanks For your reply.
While using the same approach it says
ERROR: Unable to load module 'SpreadsheetML' from template store!
EROR: No body file.EXCEL output will not be created.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.