|
Hi Art,
did you use c="" or c=" "? In 9.1.3 on Win XP I see nothing with c=""...
Gerhard
On Tue, 14 Jul 2009 13:24:18 -0400, Arthur Tabachneck
<art297@NETSCAPE.NET> wrote:
>Paul,
>
>On SAS 9.1.3, inn a Windows 2003 server environment, it yields:
>"123.456","bb"," ","0.456",".","end rec"
>
>Art
>----------
>On Tue, 14 Jul 2009 13:04:09 -0400, Paul Dorfman <sashole@BELLSOUTH.NET>
>wrote:
>
>>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
>>------------
|