SP.
=========================================================================
Date:         Fri, 21 Feb 2003 12:35:41 -0500
Reply-To:     rpresley <rpresley@GMCF.ORG>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         rpresley <rpresley@GMCF.ORG>
Subject:      Make directory listing available as a macro variable
Content-Type: text/plain; charset="iso-8859-1"

SAS 8.2, Windows.

We have directories such as c:\excel .

I want to be able to include the names of the files in this directory into a
SAS macro variable so I can then use that macro variable in a program that
imports all of the excel files in a directory.  It looks like I might be
able to use a pipe command to get the dir listing into a flat file but I
have not figured this out yet.

Any help would be appreciated.

Thanks,

Rodney

Rodney J. Presley, PhD
Director of Data Analysis
Georgia Medical Care Foundation
57 Executive Park South, NE
suite 200
Atlanta, GA  30329-2224

404-982-7574
404-982-7592  fax