|Date: ||Wed, 8 Mar 2000 10:04:09 +1000|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||Hockey Richard <rhockey@MATER.ORG.AU>|
|Subject: ||Re: SAS to text macro|
|Content-Type: ||text/plain; charset="iso-8859-1"|
In 6.12 you can also use PROC EXPORT which is documented for version 7/8 eg.
proc export data=data1 replace dbms=tab
Don't look for any documentation in version 6.12, but most of the options
for V7 seem to work.
> -----Original Message-----
> From: charles_s_patridge@MY-DEJA.COM
> Sent: Wednesday, 8 March 2000 3:23 AM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: Re: SAS to text macro
> Hi Dave,
> I tried your tip out because I did not know anything about the
> dexport feature.
> It worked like a charm on our Windows NT SAS version.
> However, it choked when trying it on our Alpha OpenVms version of
> SAS v 6.12
> I suspect without a lot of work on my part that this feature needs a
> Windows type interface, correct ???
> We do not have a windows GUI interface for our Alpha system as yet but
> will be in the near future.
> Thanks for the tip,
> Charles Patridge
> Email: Charles_S_Patridge@prodigy.net
> In article <200003071126801.SM00188@www3>,
> "David L. Ward" <dward@SASHELP.COM> wrote:
> > _the_ macro may not be a macro at all. By far (IMHO) the
> easiest way
> to export a data set to a csv or tab delimited file is to use EFI
> (external file interface) which SAS has provided programmatic control
> > See
> > http://www.sashelp.com/CodeLibrary/getcode.asp?codeID=92
> > for documentation on how to use it as a DM command or proc
> command. The link has all of the documentation from SI.
> > One limitation that I have faced many times with EFI is the
> to write the data set labels instead of the variable names as
> the first
> row. When this happens, you need to use _the_ macro, which I believe
> used to be from Ian Whitlock?
> > HTH
> > David Ward
> > SASHelp.com
> > -----Original Message-----
> > From: Nigel Tufnel <dousk8@HOTMAIL.COM>
> > Sent: 3/7/00 3:26:18 PM
> > Subject: SAS to text macro
> > > Can someone sent me _the_ macro that writes out any sas
> data set to
> a text
> > >file (specifically, a tab delimited text file). I think
> I've seen a
> > >out there that loops through all of the columns, figures out the
> > >lengths and writes out all columns and rows.
> > >
> > >I'm currently using proc export, but I can't figure out
> how to get it
> > >supress column headers.
> > >
> > >Thanks in advance for your help.
> > >
> > >______________________________________________________
> > >Get Your Private, Free Email at http://www.hotmail.com
> > >
> > _____________________________________________________
> > Sent by SASHelp.com user DWard
> > SASHelp.com - On-Line SAS Resources
> > Web interface to SAS-L at http://www.sashelp.com/sasl
> Charles Patridge - PDPC, Ltd.
> 172 Monce Road - Burlington, CT 06013 USA
> Phone: 860-673-9278 or 860-675-9026
> Email: Charles_S_Patridge@prodigy.net - Web: www.sasconsig.com
> Sent via Deja.com http://www.deja.com/
> Before you buy.