Not sure what you are asking for.
You can export a dataset to SHEET in an XLSX workbook. Either adding or replacing a sheet in an existing workbook, or creating a new workbook.
You can also create a sheet in an XLS workbook but why would anyone use that ancient proprietary format instead of the modern public format of an XLSS workbook.
Secure your spot at the must-attend AI and analytics event of 2024: SAS Innovate 2024! Get ready for a jam-packed agenda featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.
Register by March 1 to snag the Early Bird rate of just $695! Don't miss out on this exclusive offer.
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.