BookmarkSubscribeRSS Feed
Alexjaco1
Calcite | Level 5

I would like to replace all missing values with another cells value for example...

 

 

Data Have

 

OBS Var1Var2
11015
211.
312.

 

Data Want

OBS Var1Var2
11015
21111
31212

 

1 REPLY 1
r_behata
Barite | Level 11
data have;
input Var1 Var2;
cards;
10 15
11 .
12 .
run;

data want;
set have;
 var2=coalesce(var2,var1);
run;