Thank you.  Your example has helped me get most of the way there.  I have complicated it slightly by keying off of two variables instead of one.  With two variables there is the possibility of an empty dataset.  Is there a way to only do a proc export when the number of observations is greater than zero? data have; infile cards; input hatch source $ Value $; cards; 1   A   this 2   A   that 1   B   here 2   C   there ; proc sql noprint; select distinct hatch into:hatches separated by ' ' from have; select distinct source into:sources separated by ' ' from have; quit; %macro splitData(hatches=, sources=, basename=); %do i=1 %to %sysfunc(countw(&hatches));    %do j=1 %to %sysfunc(countw(&sources));       %let hat=%scan(&hatches,&i);       %let src=%scan(&sources,&j);       data &basename&hat&src;       set have;       where hatch=&hat and source="&src";       proc export outfile="&basename&hat&src..dbf" dbms=dbf replace;       run;    %end; %end; %mend; %splitData(hatches=&hatches, sources=&sources, basename=test) ... View more

Thanks Art.  However, the output of your example includes name=1, name=2, etc.  Is there a way to show the original names in the output instead of the value we are using to specify their order? ... View more

Thanks Tom.  That is a good point about the lenght and substring.  I'll probably implement something like that. ... View more

Thanks ballardw, that is exactly what I was looking for.  I only had to make one small modification to get it working.  That was to remove the empty quotes: %let path= %sysfunc(tranwrd(&a,&b,)); tranwrd was replacing the filename with the two adjacent quotes.  Removing them made it do what I needed. ... View more

Thanks Tom. Attempting your first suggestion: 1774  %let Current=; 1775  %Current; NOTE: The infile PRESENT is:       Unnamed Pipe Access Device,       PROCESS=CD,RECFM=V,LRECL=256 Stderr output: The handle is invalid. NOTE: 0 records were read from the infile PRESENT. NOTE: DATA statement used (Total process time):       real time           0.03 seconds       cpu time            0.01 seconds NOTE: Libref CURRENT was successfully assigned as follows:       Engine:        V9       Physical Name: C:\Users\barrisw\ 1776  %put Current="&Current"; Current="" 1777  %include "&Current\linemg.sas"; WARNING: Physical file does not exist, C:\linemg.sas. ERROR: Cannot open %INCLUDE file \linemg.sas. I've already tried usine ./linemg.sas but the current working directory inside the SAS environment is not the same as where the .sas file sits in the filesystem. using sysfunc and pathname... looks like it is picking up my home directory and not the directory where the .sas program exists. NOTE: Libref CURRENT was successfully assigned as follows:       Engine:        V9       Physical Name: C:\Users\barrisw 1341  %let Current=%sysfunc(pathname(Current)); 1342  %include "&Current\linemg.sas"; WARNING: Physical file does not exist, C:\Users\barrisw\linemg.sas. ERROR: Cannot open %INCLUDE file C:\Users\barrisw\linemg.sas. ... View more

Hi Ksharp, Thanks for the advice.  However, when I tried to run this I got errors.  Perhaps I'm not doing this correctly: Plus, I dont' want to have to specify the directory in the sas program. filename fname pipe 'dir m:\L01mg300\*.sas /S /b'; data _null_; infile fname; input; call symputx(scan(_infile_,-2,'.\'),_infile_); run; %put _user_; %include "&a1"; Log output: NOTE: Copyright (c) 2002-2008 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) Proprietary Software 9.2 (TS2M3) NOTE: This session is executing on the X64_DSRV08  platform. NOTE: SAS initialization used:       real time           1.96 seconds       cpu time            0.79 seconds 1    filename fname pipe 'dir m:\L01mg300\*.sas /S /b'; 2    data _null_; 3    infile fname; 4    input; 5    call symputx(scan(_infile_,-2,'.\'),_infile_); 6    run; NOTE: The infile FNAME is:       Unnamed Pipe Access Device,       PROCESS=dir m:\L01mg300\*.sas /S /b,RECFM=V,       LRECL=256 Stderr output: There is not enough space on the disk. NOTE: 0 records were read from the infile FNAME. NOTE: DATA statement used (Total process time):       real time           0.15 seconds       cpu time            0.03 seconds 7    %put _user_; 8    %include "&a1"; WARNING: Apparent symbolic reference A1 not resolved. WARNING: Physical file does not exist, C:\Users\barrisw\&a1. ERROR: Cannot open %INCLUDE file &a1. ... View more

Hi Art, I don't think that Current or Present are defined anywhere else.  I've found that if I navigate inside Windows Explorer to the sas file and double-click on it, it opens the SAS environment window.  If I then click on the "run" icon it works.  However, if I first start the SAS environment and then use File-> Open Program and then navigate to that same sas file, and then run it, it issues the errors I mentioned. Successful run (double clicking on sas file in windows explorer): 1    * ConCheck.sas ; 2    %include 'c:\SASUtils\dissectionIO20110912.sas'; 22   %include 'c:\SASUtils\Current.sas'; 38   %Current; NOTE: The infile PRESENT is:       Unnamed Pipe Access Device,       PROCESS=CD,RECFM=V,LRECL=256 NOTE: 1 record was read from the infile PRESENT.       The minimum record length was 11.       The maximum record length was 11. NOTE: DATA statement used (Total process time):       real time           0.03 seconds       cpu time            0.00 seconds NOTE: Libref CURRENT was successfully assigned as follows:       Engine:        V9       Physical Name: M:\L01mg300 39   %include "&Current\linemg.sas"; Failed run (navigating to file from sas environment): 1    * ConCheck.sas ; 2    %include 'c:\SASUtils\dissectionIO20110912.sas'; 22   %include 'c:\SASUtils\Current.sas'; 38   %Current; NOTE: The infile PRESENT is:       Unnamed Pipe Access Device,       PROCESS=CD,RECFM=V,LRECL=256 Stderr output: The handle is invalid. NOTE: 0 records were read from the infile PRESENT. NOTE: DATA statement used (Total process time):       real time           0.03 seconds       cpu time            0.00 seconds NOTE: Libref CURRENT was successfully assigned as follows:       Engine:        V9       Physical Name: C:\Users\barrisw\ 39   %include "&Current\linemg.sas"; WARNING: Physical file does not exist, C:\linemg.sas. ERROR: Cannot open %INCLUDE file \linemg.sas. ... View more

Hi Art, This is exactly what I was looking for.  However, I can't seem to get it to work.  I tried this piece of code: * ConCheck.sas ; %include 'c:\SASUtils\dissectionIO20110912.sas'; %include 'c:\SASUtils\Current.sas'; %Current; %include "&Current\linemg.sas"'; The output log shows this: 1    * ConCheck.sas ; 2    %include 'c:\SASUtils\dissectionIO20110912.sas'; 22   %include 'c:\SASUtils\Current.sas'; 38   %Current; NOTE: The infile PRESENT is:       Unnamed Pipe Access Device,       PROCESS=CD,RECFM=V,LRECL=256 Stderr output: The handle is invalid. NOTE: 0 records were read from the infile PRESENT. NOTE: DATA statement used (Total process time):       real time           0.14 seconds       cpu time            0.03 seconds NOTE: Libref CURRENT was successfully assigned as follows:       Engine:        V9       Physical Name: C:\Users\barrisw\ 39   %include "&Current\linemg.sas"; WARNING: Physical file does not exist, C:\linemg.sas. ERROR: Cannot open %INCLUDE file \linemg.sas. ... View more