To some degree. It can generate automatic names, or names set from a variable or names from by groups. Sort of depends on how and what you're using, but in general it's possible.
a worksheet say master.xls has five sheets : credit,debit,mortgage,escrow,insuarance. Instead of giving the sheet names in a macro variable, is there a way for SAS to create 5 datasets for master.xls?
a worksheet say master.xls has five sheets : credit,debit,mortgage,escrow,insuarance. Instead of giving the sheet names in a macro variable, is there a way for SAS to create 5 datasets for master.xls?
Yes, but it depends on how your data is stored.
You really need to add some details if you want anything beyond yes it's possible.
Ready to join fellow brilliant minds for the SAS Hackathon?
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.