topic Re: Enterprise guide formatting data: removing spaces, populating 0 where blank exists; in SAS Enterprise Guide

Enterprise guide formatting data: removing spaces, populating 0 where blank exists;

jimmansfield — Thu, 19 Sep 2019 05:23:47 GMT

What function in enterprise guide can perform the following? or should I write code?

removing spaces (zip code exampls from UK where we need exact to match; or fuzzy match contains instead) which is best?

Postcode
AL7 1JR
AL7 4HQ
AL7 4HQ
AL7 4HQ
B13 8JL
B15 2GW
B15 2GW

populating 0 where blank exists;

KOLcity_number KOLcity_networkscore
. .
. .
. .
. .
. .
. .
. .
. .
. .
. .
1 1
1 1
. .
1 1
1 1
1 1
1 1
1 1
1 1
. .
1 1

Populating means or median where blanks exist

SurgAdmissions
0
0
0
0
35439
0
0
0
0
54372
0
54372
0
0
0
0
76629
0
30692
49311
0
23813
63084
0
2360

Re: Enterprise guide formatting data: removing spaces, populating 0 where blank exists;

PeterClemmensen — Thu, 19 Sep 2019 05:52:11 GMT

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;