Date:         Tue, 14 Jul 2009 13:34:39 -0400
Reply-To:     Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Subject:      Re: Nulls left unquoted by DSD/tilde combo

Hi Nat,
if you use "" instead of " " in 9.1.3 nothing is visible. How does that
come out in 9.2?
Gerhard


On Tue, 14 Jul 2009 13:22:53 -0400, Nat Wooding
<Nathaniel.Wooding@DOM.COM> wrote:

>Paul
>
>Perhaps the little grey cells are getting sunburned!!
>
>What operating system are you using. I just ran your code using 9.1.3 and
>9.2 under WinXP Pro and in both case got
>
>"123.456","bb"," ","0.456",".","end rec"
>NOTE: DATA statement used (Total process time):
>      real time           1.53 seconds
>      cpu time            0.04 seconds
>
>which does include the quotes around the missing values.
>
>Nat
>
>Nat Wooding
>Environmental Specialist III
>Dominion, Environmental Biology
>4111 Castlewood Rd
>Richmond, VA 23234
>Phone:804-271-5313, Fax: 804-271-2977
>       Cel Phone: 804-205-0752
>
>
>
>             Paul Dorfman
>             <sashole@BELLSOUT
>             H.NET>                                                     To
>             Sent by: "SAS(r)          SAS-L@LISTSERV.UGA.EDU
>             Discussion"                                                cc
>             <SAS-L@LISTSERV.U
>             GA.EDU>                                               Subject
>                                       Nulls left unquoted by DSD/tilde
>                                       combo
>             07/14/2009 01:04
>             PM
>
>
>             Please respond to
>               Paul Dorfman
>             <sashole@BELLSOUT
>                  H.NET>
>
>
>
>
>
>
>SAS-L,
>
>Reading the SAS doc portion related to DSD/tilde modifier interaction, I
>find
>
>"By default, data values that do not contain the delimiter that you
>specify are not enclosed in quotation marks. However, you can use the
>tilde (~) modifier to force any data value, INCLUDING MISSING VALUES, to
>be enclosed in quotation marks, even if it contains no embedded
delimiter."
>
>Yet,
>
>data _null_ ;
>   a = 123.456 ; b = "bb" ; c = "" ; d = .456; e = . ; f = "end rec" ;
>   file log dlm = ',' dsd ;
>   put ( _all_ ) ( ~ ) ;
>run ;
>
>yields:
>
>"123.456","bb",,"0.456",,"end rec"
>
>which, obvioulsy, leaves the missing values unquoted. Does anyone observe
>any cranial maladroitness on my part? Do I misread the doc and/or miscode
>FILE/PUT?
>
>Kind regards
>------------
>Paul Dorfman
>Jax, FL
>------------
>
>
>CONFIDENTIALITY NOTICE:  This electronic message contains
>information which may be legally confidential and or privileged and
>does not in any case represent a firm ENERGY COMMODITY bid or offer
>relating thereto which binds the sender without an additional
>express written confirmation to that effect.  The information is
>intended solely for the individual or entity named above and access
>by anyone else is unauthorized.  If you are not the intended
>recipient, any disclosure, copying, distribution, or use of the
>contents of this information is prohibited and may be unlawful.  If
>you have received this electronic transmission in error, please
>reply immediately to the sender that you have received the message
>in error, and delete it.  Thank you.