DATA Step, Macro, Functions and more

Import tab from one excel

Reply
Occasional Contributor
Posts: 15

Import tab from one excel

good Afternoon

 

Im wondering how i can go about importing a tab from a template in a sas program that creats a report on the fly.

 

 

PROC Star
Posts: 7,363

Re: Import tab from one excel

Not sure what you mean. If you are talking about using an Excel template to have SAS create a workbook using that template, then take a look at: http://www.sascommunity.org/wiki/A_Poor/Rich_SAS_Users_Proc_Export

 

Art, CEO, AnalystFinder.com

 

Occasional Contributor
Posts: 15

Re: Import tab from one excel

Thanks art.

I already have a program that creates thr workbook and all its tabs. However i have been asked to add a new tab. Ehich reada from other tabs. Since its already created. Im wondering if i can impoer the tab at the end or the creation job.

Ask a Question
Discussion stats
  • 2 replies
  • 96 views
  • 0 likes
  • 2 in conversation