Annette,

Perhaps this bit of code will shed some light. If you know the variable order, which you can easily obtain from the CONTENTS procedure, then you can employee your scheme for replacing values with missing. By the way, a blank corresponding to a missing character value.

305 data _null_; 306 a="One"; b="Horse"; 307 x=1;y=2;z=3; 308 array numer (*) _numeric_; 309 array charact (*) _character_; 310 dim_num=dim(numer); 311 dim_cha=dim(charact); 312 put dim_num= dim_cha= numer(dim_num-1)= charact(dim_cha)=; 313 var=vname(charact(1)); 314 put var=; 315 run;

dim_num=3 dim_cha=2 y=2 b=Horse var=a NOTE: DATA statement used: real time 0.05 seconds cpu time 0.00 seconds

Regards,

Kevin

Kevin Viel Georgia Medical Care Foundation 57 Executive Park South, NE suite 200 Atlanta, GA 30329-2224

-----Original Message----- From: Annette [mailto:anne5432@UNI.DE] Sent: Thursday, March 21, 2002 9:52 AM To: SAS-L@LISTSERV.UGA.EDU Subject: set list of 'mixed' variables to missing

hello, However, I am to set to missing selected mixed (num, char) vars (e.g. VAR, ANIMAL, and TEXT) in selected rows (by ID). I guess some ARRAY would be convenient, but my efforts were not uccessful until now. The data set contains hundreds of character and numeric vars. The idea is this: old: ID TEST VAR ANIMAL TEXT TAPE 1 1 7 3 dgffg hghg 2 7 4 2 hghf hhh 3 4 5 3 dgffg hghg 4 7 . . . hhh 5 6 5 3 dgffg hghg ; new: ID TEST VAR ANIMAL TEXT TAPE 1 1 7 3 dgffg hghg 2 7 . . . hhh 3 4 5 3 dgffg hghg 4 7 . . . hhh 5 6 5 3 dgffg hghg ; Thank you in advance, Annette