In 6.12 you can also use PROC EXPORT which is documented for version 7/8 eg. proc export data=data1 replace dbms=tab outfile="c:\data1.txt"; run; Don't look for any documentation in version 6.12, but most of the options for V7 seem to work. RH > -----Original Message----- > From: charles_s_patridge@MY-DEJA.COM > [mailto: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 > over. > > > > See > > http://www.sashelp.com/CodeLibrary/getcode.asp?codeID=92 > > for documentation on how to use it as a DM command or proc > display/af > command. The link has all of the documentation from SI. > > > > One limitation that I have faced many times with EFI is the > inability > 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 > macro > > >out there that loops through all of the columns, figures out the > appropriate > > >lengths and writes out all columns and rows. > > > > > >I'm currently using proc export, but I can't figure out > how to get it > to > > >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. >