Date: Tue, 14 Jul 2009 13:58:57 -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
Danke, sehr gut Nat!
thanks for testing!
Something magic has happened: I'm sure that I saw exactly the same as Paul
wrote. Then I tried the c=" " thing and saw " ". Now I tried c="" and
expected again ,, but see ," ",... I can't get it back! Unfortunately I
cleared the log already.
I tried it now also on a AIX / SAS 9.1.3 - all the same! Maybe the day was
too long already...
Gerhard
On Tue, 14 Jul 2009 13:43:10 -0400, Nat Wooding
<Nathaniel.Wooding@DOM.COM> wrote:
>Wie geht's, Gerhard
>(that's a Pennsylvania Dutch expression that I think that they invented)
Danke, sehr gut!
(could also be the Germans, I think...)
>
>Here is what I get -- 9.2, /ts2MO
>
>NOTE: Copyright (c) 2002-2008 by SAS Institute Inc., Cary, NC, USA.
>NOTE: SAS (r) Proprietary Software 9.2 (TS2M0)
> Licensed to DOMINION RESOURCES SERVICES INC, Site 70022437.
>NOTE: This session is executing on the XP_PRO platform.
>
>
>
>NOTE: SAS initialization used:
> real time 2.86 seconds
> cpu time 1.42 seconds
>
>1 data _null_ ;
>2 a = ""; b = " " ; c = " " ; * a has no space, b has 1 space , c
>has 2 spaces;
>3 file log dlm = ',' dsd ;
>4 put ( _all_ ) ( ~ ) ;
>5 run ;
>
>" "," "," "
>NOTE: DATA statement used (Total process time):
> real time 0.00 seconds
> cpu time 0.01 seconds
>
>so it appears that any empty character string is treated as a single
blank.
>
>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
>
>
>
> Gerhard
> Hellriegel
> <gerhard.hellrieg To
> el@T-ONLINE.DE> SAS-L@LISTSERV.UGA.EDU
> Sent by: "SAS(r) cc
> Discussion"
> <SAS-L@LISTSERV.U Subject
> GA.EDU> Re: Nulls left unquoted by
> DSD/tilde combo
>
> 07/14/2009 01:34
> PM
>
>
> Please respond to
> Gerhard
> Hellriegel
> <gerhard.hellrieg
> el@T-ONLINE.DE>
>
>
>
>
>
>
>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.
>
>
>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.
| 
