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 (February 1996, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Fri, 16 Feb 1996 19:37:43 EET
Reply-To:     Arjen Raateland <raateland@VYH.FI>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Arjen Raateland <raateland@VYH.FI>
Organization: National Board of Waters and the Environment
Subject:      Re: UPDATE character var to missing i.e. blank?

In article <1996Feb16.190230@vyh.fi>, raateland@vyh.fi (Arjen Raateland) writes: > I need to update a character variable to blanks in a master file using > the UPDATE statement in a DATA step.

> I also tried > flag = '_' ; > in the transaction file. It doesn't cause any notes as in the earlier > run, but it doesn't work either.

I'm sorry to have bothered you all. The update works perfectly, but my data is even more dotty than I already knew. For good measure I include the log and some output of my little test:

14340 data master ; 14341 input num flag $ ; 14342 cards ; NOTE: The data set WORK.MASTER has 3 observations and 2 variables. NOTE: The DATA statement used 0.66 seconds. 14346 ; 14347 run ; 14348 14349 data trans ; 14350 length flag $ 8 ; 14351 num = 2 ; 14352 flag = '_' ; 14353 output ; 14354 run ; NOTE: The data set WORK.TRANS has 1 observations and 2 variables. NOTE: The DATA statement used 0.7 seconds. 14355 14356 data updated ; 14357 update master trans ; 14358 by num ; 14359 run ; NOTE: The data set WORK.UPDATED has 3 observations and 2 variables. NOTE: The DATA statement used 0.71 seconds.

OBS NUM FLAG

1 1 abc 2 2 3 3 ghi

It's just too late to think straight.

--... ...-- -.. . --- .... ..--- --.. .- --.. Arjen Raateland, SAS Support Finnish Environment Agency Helsinki, Finland .-.-. -.-


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