I don't know much about EG point and click tools. Here is simple code to do what you want though
/* 1 */
data have;
input Postcode $ 1-7;
datalines;
AL7 1JR
AL7 4HQ
AL7 4HQ
AL7 4HQ
B13 8JL
B15 2GW
B15 2GW
;
data want;
set have;
NewPostcode=compress(Postcode);
run;
/* 2 */
data have;
input ID$ var1 var2 var3;
datalines;
1 . 3 4
2 2 0 .
3 . . 3
4 . 8 .
5 5 . .
;
/* Replace missing with zero */
proc stdize data=have out=wantZero reponly missing=0;
run;
/* Replace missing with mean */
proc stdize data=have out=wantMean reponly missing=mean;
run;
... View more
