|
Unfortunately another no.. Tried both options but the missing character
is already a '.' so that didn't change anything.
I also really thought that the generating a text column of the numeric
value and hard coding all . to "." would do the trick but somehow when
exporting the dataset it puts it back to blanks..
Thanks however..
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Jim
Groeneveld
Sent: 22 September, 2008 15:59 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: exporting blanks
Hi Richard,
In various cases OPTIONS MISSING='.'; might help, but I'm not sure
whether
it'll help you too, it's officially intended for numerical variables
only.
Another option is to recode all exclusive single spaces to a dot before
writing them out: (*untested code*)
DATA ........ (DROP=I);
SET .........;
Array AllChar (*) _CHARACTER_;
DO I = 1 TO DIM(AllChar);
IF (MISSING(AllChar)) THEN AllChar = '.';
END;
RUN;
Regards - Jim.
--
Jim Groeneveld, Netherlands
Statistician, SAS consultant
home.hccnet.nl/jim.groeneveld
My computer and I present macro Count with SPSS-like syntax at PhUSE
2008.
On Mon, 22 Sep 2008 13:28:04 +0200, Richard Hooijmaijers
<Richard.Hooijmaijers@KINESIS-PHARMA.COM> wrote:
>Hi,
>
>I have a question regarding the export of blank (numeric values). I
>would like to export a SAS dataset to a prn file (space delimited). But
>in the exported file I would like to have a "." for missing numeric
>values instead of a blank value. Is there a way to do this? I managed
>to do it for a csv file by using ODS, but it won't work for a space
>delimited file. Also I would like to use export (if possible) and not
>use the datastep with the file/infile statement, but if there is no
>other way...
>
>Thanks,
>Richard
>
>-----------------------------------------------------------------------
---------
>De informatie opgenomen in dit bericht kan vertrouwelijk zijn en is
uitsluitend bestemd
>voor de geadresseerde. Indien u dit bericht onterecht ontvangt, wordt u
verzocht de
>inhoud niet te gebruiken en de afzender direct te informeren door het
bericht te retourneren.
>-----------------------------------------------------------------------
---------
>The information contained in this message may be confidential and is
intended to be
>exclusively for the addressee. Should you receive this message
unintentionally, please do
>not use the contents herein and notify the sender immediately by return
e-mail.
>-----------------------------------------------------------------------
---------
--------------------------------------------------------------------------------
De informatie opgenomen in dit bericht kan vertrouwelijk zijn en is uitsluitend bestemd
voor de geadresseerde. Indien u dit bericht onterecht ontvangt, wordt u verzocht de
inhoud niet te gebruiken en de afzender direct te informeren door het bericht te retourneren.
--------------------------------------------------------------------------------
The information contained in this message may be confidential and is intended to be
exclusively for the addressee. Should you receive this message unintentionally, please do
not use the contents herein and notify the sender immediately by return e-mail.
--------------------------------------------------------------------------------
| 
