|
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
.-.-. -.-
| 
