LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (July 2009, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Tue, 14 Jul 2009 13:36:28 -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 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 >>------------


Back to: Top of message | Previous page | Main SAS-L page