SAs Excel and multiple tabs.

[SASPhile]

Can SAS automatcially create datasets for each tab in an excel worksheet without giving the tab name?

Say there is a worksheet reports.xls and there are 5 tabs. so 5 datasets to be created when user gives the worksheet name.

[Reeza]

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.

[SASPhile]

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?

[Reeza]

---

@SASPhile wrote:

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.