|
hi,
why my code doesn't work with 'do over'. thanks.
ash007.
DATA TABLE_BIDON;
INPUT X1 X2 X3 X4 X5 $; CARDS;
2 . 5 1161 ABÉLIEN
35 6 3 1336 ALMÉRIC
82 1 5 1499
;RUN;
DATA TABLE_BIDON (DROP = _I);
SET TABLE_BIDON;
ARRAY A_VARNUM[*] _NUMERIC_; ARRAY A_VARCAR[*] _CHARACTER_;
DO OVER A_VARNUM[*];
IF A_VARNUM[*] = . THEN A_VARNUM[*] = 0;
END;
DO OVER A_VARCAR[*];
IF COMPRESS(A_VARCAR[*]) IN (".","") THEN A_VARCAR[*] = "Z";
END;
RUN;
|