Date:         Wed, 11 Apr 2007 05:47:23 -0400
Reply-To:     Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Subject:      Re: DBF to SAS and back

I've found my macros:

http://www.urz.uni-heidelberg.de/statistik/sas-ah/01.01.04/DBFMakros.html

There you'll find a description (sorry, only in German) and a download
link.
DBF2SAS converts from DBF to SAS
SAS2DBF the other way

A little in addition is ALL2DBF. It fetches all datasets and views (? not
sure, didn't look into. If not, it's easy to enhance) from a given SAS
library and creates DBF files from that.

I hope that works all. If not, let me know.
Gerhard




On Wed, 11 Apr 2007 05:14:59 -0400, Gerhard Hellriegel
<gerhard.hellriegel@T-ONLINE.DE> wrote:

>I've written macros to read and write DBF files a few years ago. I'm not
>at home just now, but tonight I'll look for them.
>Maybe I find them at Uni Heidelberg's website.
>
>What I found there up to now, is a macro, not mine, to read DBF data into
>a SAS dataset, but not the other direction.
>
>ftp://ftp.uni-heidelberg.de/pub/sas/makros/dbtosas.sas
>
>If I find more, I post it.
>Gerhard
>
>
>On Tue, 10 Apr 2007 23:09:37 -0400, Howard Schreier <hs AT dc-sug DOT org>
><nospam@HOWLES.COM> wrote:
>
>>On Tue, 10 Apr 2007 17:53:31 -0400, Krishnan Viswanathan
>><krisviswanathan@GMAIL.COM> wrote:
>>
>>>I have the following issue.
>>>
>>>I have around 100 dbf files that i want to import into sas, modify the
>files
>>>and export it out again as dbf.
>>>
>>>I can use sas/access and do this tediously. Searching the web, various
>fora,
>>>etc. i came across Mel Widawki's papers on getlist and dbfacc from SUGI
>23
>>>and they seem like possible solutions to my needs (or at least the first
>>>part). However, i am unable to find the getlist and dbfacc macros
>anywhere.
>>>
>>>My question to the list is :
>>>1. Are these macros easily available or does MW control access to it? (I
>>>have emailed my request to him)
>>>2. If these macros are unavailable does anyone have any potential
>solutions
>>>that i can use and is willing to share?
>>>
>>>TIA,
>>>Krishnan
>>
>>Look for Richard Hockey's DBF2SAS and SAS2DBF macros.