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.