Create an Excel Workbook That Runs SAS Programs - Exchanging Data Between SAS and Microsoft Excel - page 256

Directory Structure used for Processing

Directory File type Function

This directory stores the VBA and VBS
code for the project. Also, Excel will let
you export the UserForm1 code module.
This would be a good place to store the
download.

Y My_BAS_Files

Y My_Excel_Tool This directory stores the workbook tool.

This directory stores the SAS code for
the individual SAS programs in the
project. The fully tested SAS code files
can be stored here. Additional
directories could be created for backup
copies of SAS code that are being
developed.

Y My_Production_SAS_Code_Source_Directory

This directory stores subdirectories that
contain the monthly working files. Place
a directory here for each of the periodic
report groups. We are using monthly
directories here, but they could be daily
or quarterly. In this periodic directory,
place a folder for each of the reports.
Note: Other directories can be defined as needed to meet your departmental needs.

Y My_Monthly_Projects

Here would be a good place to store
common SAS files that can be included
in more than one program.

My_Department_Macro_code

This is where your data files reside. It
would be a good idea to put any variable
into the tool that could be used to
describe a part of the directory path. The
more flexible this part of the tool can be,
the more helpful it will be later in the
program execution.

Any_Other_Departmental_directories

The folder names are not important, as long as the reporting tool knows what they are and how to access
them. Most of these file names come directly from data entered into the screens on the tool. The only
notable exceptions to that are the name of the folder that holds the source code and the path names to
Excel.exe and SAS.exe.

Start by mapping to a directory space that is common for all users of the tool:
Q:\My_Tool
Any_Other_Departmental_Directories
My_BAS_Files
My_Department_Macro_code
My_Excel_Tool
My_Monthly_Projects
2012_07

JOB_01_Write_data_to_Excel_File
JOB_02_Read_data_from_Excel_File

2012_08

JOB_01_Write_data_to_Excel_File
JOB_02_Read_data_from_Excel_File
My_Production_SAS_Code_Source_Directory
Backup_Code_Copies