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 (December 2001, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Thu, 20 Dec 2001 10:59:59 +0100
Reply-To:     Peter Crawford <peter.crawford@DB.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Peter Crawford <peter.crawford@DB.COM>
Subject:      Re: Update a flatfile "in place"? - Thank You!
Content-type: text/plain; charset=iso-8859-1

It is impressive how quickly a question comes to SAS-L and is resolved. This one arrived/discussed/argued/and concluded between the time I left this office yesterday, and my arrival today - nice to have normal hours (9-6)... :-) So this contribution seems a bit late, but I hope the warning may be appropriate. I use the sharebuffers option ( under the common misunderstanding that it was needed for "update in place" ) on both winXX (sas v6.08 - v8.2) and on ibm-aix (sas v8.1) platforms ( to update just the altlog files number in my config file). That was/is very successful. However, I was very disappointed to find the same technique on OS/390 just corrupts the file ! (ok I haven't tried again since updating to v8 ) - but, beware ! - assumptions of common file handling on two platforms need not guarantee multi-platform consistency !.

regards to the (high-speed) -L Peter Crawford

Datum: 20/12/2001 01:27 An: SAS-L@LISTSERV.UGA.EDU

Antwort an: Abe Anon <abe_anon@HOTMAIL.COM>

Betreff: Re: Update a flatfile "in place"? - Thank You! Nachrichtentext:

Many thanks to those who replied to my question on how to update a flatfile in place: David Cassell, Paul Dorfman, Sean Meldrum, David Ward, and others who responded off-list.

The definitive answer was supplied by Paul Dorfman, relayed by David Ward. I won't repeat it here, but would just like to mention that there was a lot of confusion over the SHAREBUFFERS option. Many thought that this option is what enabled the update in place to occur. Mr. Dorfman points out that SHAREBUFFERS is not necessary, it just saves a bit of memory.

See the post for the details, or search the SAS online doc for "Updating External Files in Place", or see the Version 6 SAS Language manual, example 4 under the INFILE statement.

Again, many thanks to al lwho replied.

Abe

_________________________________________________________________ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com

--

Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.

This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.


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