BookmarkSubscribeRSS Feed
SanjayM
Calcite | Level 5
Can I have a single excel library pointing to a folder of excel files. The excel files showing as datasets in that library

instead of creating a excel library pointing to just one excel file.
1 REPLY 1
Cynthia_sas
SAS Super FREQ
Hi:
I'm not sure what you mean by an "Excel library". Imagine that you have this Excel workbook:
[pre]
c:\temp\mywb.xls
[/pre]

And in that Excel WORKBOOK are 2 Excel Worksheets (WOMBAT and KOALA).

In SAS, you would point to the Workbook as a SAS library:
[pre]
libname the_wb excel 'c:\temp\mywb.xls';
[/pre]
and you could reference the sheets as
the_wb.wombat and the_wb.koala.

But, when you look at the above Excel WB file, you still only see one file, not a collection of separate files.

However, there is a way in Excel technology to link multiple HTML files together in a directory structure like this:
c:\temp\main_report.html -- would be the main HTML file
and this "main" file would point to a set of files in a sub-directory structure like this:
[pre]
c:\temp\main_report.html
|
+----c:\temp\main_report_files\filelist.xml
|
+----c:\temp\main_report_files\wombat.html
|
+----c:\temp\main_report_files\koala.html
|
+----c:\temp\main_report_files\mystyle.css
[/pre]

So, then, if you opened main_report.html with Excel, it would, then open a multi-sheet workbook, where each HTML file was a separate tab or worksheet.

I don't know whether you can use a file structure like this with other types or file extensions and Excel. I have only seen the above technique with HTML files being linked together and then the "main" HTML file was opened with Excel.

To achieve this kind of structure with EG, you'd most probably have to use a code node to create the related files. If this is what you mean by your question, you might consider contacting Tech Support for more help. If this is NOT what you mean by your question, then you should definitely contact Tech Support to see whether they are familiar with the concept of an Excel library, as you mean it, and see if they know how to implement something like this in EG.

cynthia

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 542 views
  • 0 likes
  • 2 in conversation