Thank you @Tom    This solved my problem.   %let varname=FONTE&mon01. ; .... &varname = tranwrd(&varname,'D','1'); ... View more

data example; infile datalines missover; input id $ var1 $ var2 $ var3 $ var4 $ var5 $ var6 $ var7 $ var8 $ var9 $ var10 $ var11 $ var12 $; cards; A 1 2 3 . . . . . 1 1 1 3 B 3 3 2 1 3 2 1 . . . . . C . . . . 1 2 3 1 2 3 2 . D 3 . 1 . 3 . 1 . 3 . 1 . F 1 3 . . 1 3 . . 1 3 . . E 3 2 1 . . . . . 1 1 1 3 G 3 3 2 1 3 2 1 . . . . . H . . . . . 1 2 3 1 2 3 2 I 3 . 1 . 3 . 1 . 3 . 1 . J A E . . A E . . A E . . ; data want; set example; array x{*} $ var:; do i = 1 to dim(x); if missing(x{i}) then do; first=vname(x{i});leave; end; end; do i = dim(x) to 1 by -1; if missing(x{i}) then do; last=vname(x{i});leave; end; end; drop i; run; ... View more

Yes. You are right. Just correct it . ... View more

Thank you very much @Patrick It worked. ... View more

Thank you @FreelanceReinh    Both solutions are useful.   The second is best for us now. ... View more

Don't just use the length of $20 from my sample but chose a length which matches your source variables. If the length is too short then you will truncate the string, if it's too long then you're wasting space. You can run below script. Then look-up in the report what lengths your two source variables have and use the bigger of the two values in the length statement for your new variable. proc contents data=DEM_MES.MERGEEFATURADMRSS202001; run;quit; ... View more

Thank you @Reeza! ... View more