Date: Tue, 10 Dec 2002 04:16:59 -0500
Reply-To: Gerhard Hellriegel <ghellrieg@T-ONLINE.DE>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Gerhard Hellriegel <ghellrieg@T-ONLINE.DE>
Subject: Re: Exporting to SAS
On Mon, 9 Dec 2002 21:29:01 -0800, kipchak <kipchak@YAHOO.COM> wrote:
>I am looking at a situation where I need to enhance a Visual
>Basic/Access application, to write files that could be sent out to a
>SAS-based system. My source system does have a SAS foot-print on it.
>Is there a way to write out SAS-readable files. Would SAS read a plain
>Jane ASCII file? Do I need to create SAS Transport files somehow?
>Any help is appreciated.
For sure you can read a ASCII file into SAS. The easiest way is to create
the appropriate INPUT statement in VB to use it in SAS. So you can output
exactly that what you INPUT in SAS. You can even generate a complete data-
step to use in SAS which exactly fits to your needs.
To generate a transport format in VB is impossible without knowing the
exact structure for that files. In that case it would be easier to create a
standard format, like DBF for example. That is quite easy. That you can get
into SAS with ACCESS to PC files. But it's simpler to do it via INPUT
statement in a DATA-Step.