topic SAs Excel and multiple tabs. in New SAS User

SAs Excel and multiple tabs.

SASPhile — Mon, 05 Nov 2018 15:58:36 GMT

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.

Re: SAs Excel and multiple tabs.

Reeza — Mon, 05 Nov 2018 16:03:38 GMT

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.

Re: SAs Excel and multiple tabs.

SASPhile — Thu, 08 Nov 2018 16:14:57 GMT

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?

Re: SAs Excel and multiple tabs.

Reeza — Thu, 08 Nov 2018 16:17:06 GMT

@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.