To create a tab-delimited file from PC SAS, you can do the following:

Globals Desktop Data Access & Management Export Wizard Specify the SAS source dataset Standard format--From the drop down, choose Tab Delimited *.txt

Hope this helps, Royce

"Muhlbaier, Lawrence H." <lawrence.muhlbaier@DUKE.EDU> on 12/02/99 04:48:34 PM

Please respond to "Muhlbaier, Lawrence H." <lawrence.muhlbaier@DUKE.EDU>

To: SAS-L@LISTSERV.UGA.EDU cc: (bcc: Royce Claytor/IT/VANCPOWER) Subject: Re: Creating delimited ASCII file from SAS dataset

There is a contributed SAS macro called %flatfile that does just what you want. I think that you can get it from the SAS website. Otherwise just search the SAS-L archives for %flatfile.

Julia Hertl wrote:

> Hi SAS-L, > I have what I know is a very simple question, but I can't find the solution > anywhere. I need to create an ASCII file (cows2.dat) which is either tab- > or comma-delimited (it doesn't matter which) out of a SAS dataset (cows). I > am using SAS 6.12 on UNIX, and when I submit the code: > > data _NULL_; set cows; > file 'cows2.dat' dlm'09'x; > put var1 var2 var3 var4; > > I get an error message saying "Invalid option name DLM". I got the same > error when I tried dlm'05'x and "Invalid option name DSD" when I tried with > the option dsd. > > Usually when I create ASCII files out of SAS datasets, it is sufficient for > them to be space-delimited, but this time I need an ASCII file which is > tab- or comma-delimited. > > Does anyone have any suggestions? > > Thank you. > > Julia Hertl > Section of Epidemiology > Dept. of Population Medicine and Diagnostic Sciences > College of Veterinary Medicine > Cornell University > Ithaca, NY 14853

-- Lawrence H. ('Doc') Muhlbaier muhlb001@mc.duke.edu Assistant Research Professor Duke University Medical Center 919-668-8774 (office) DUMC 3865 919-383-0595 (home) Durham, NC 27710-7510 919-668-7057 (FAX)