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:
There you'll find a description (sorry, only in German) and a download
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.
On Wed, 11 Apr 2007 05:14:59 -0400, Gerhard Hellriegel
>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.
>If I find more, I post it.
>On Tue, 10 Apr 2007 23:09:37 -0400, Howard Schreier <hs AT dc-sug DOT org>
>>On Tue, 10 Apr 2007 17:53:31 -0400, Krishnan Viswanathan
>>>I have the following issue.
>>>I have around 100 dbf files that i want to import into sas, modify the
>>>and export it out again as dbf.
>>>I can use sas/access and do this tediously. Searching the web, various
>>>etc. i came across Mel Widawki's papers on getlist and dbfacc from SUGI
>>>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
>>>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
>>>that i can use and is willing to share?
>>Look for Richard Hockey's DBF2SAS and SAS2DBF macros.