Date:         Tue, 17 Oct 2000 14:32:25 -0400
Reply-To:     Jim Agnew <agnew@HSC.VCU.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jim Agnew <agnew@HSC.VCU.EDU>
Organization: Virginia Commonwealth of Virginia
Subject:      Re: excel files--->sas datasets
Content-Type: text/plain; charset=us-ascii

i stand in awe.......

Jim

Steven Dubnoff wrote:
>
> On Tue, 17 Oct 2000 10:53:38 -0500, Huitman Huang <huihuang@iupui.edu>
> wrote:
>
> >Dear all:
> >
> >I am going to transfer hundreds of excel files to sas datasets.
> >Is there any efficient way to do this instead of one by one?
> >(I am using dbmscopy).
>
> Try Stat/Transfer.  It has a wildcard facility.  For example:
>
>         st \in\*.xls \out\*.sd2
>
> will transfer all of the Excel files in the directory '\in' to SAS
> files in the directory '\out'.
>
> >
> >BTW, is there any way to transfer those excel files to csv files?
> >
> In Stat/Transfer:
>
>         st \in\*.xls \out\*.csv
>
> Best,
>
> Steve
>
> ----------------------------------------------------------------
> Steven Dubnoff              sdubnoff@circlesys.com
> Circle Systems              We make your data instantly usable.
> Download Stat/Transfer from http://www.stattransfer.com
> 1001 Fourth Avenue, #3200   (206) 682-3783
> Seattle, WA 98154           Fax (206) 328-4788