replicate values from column A_EXP_DT to other new_dt

[Rixile106]

Good day expects.

i nedd to replicate values from column A_EXP_DT to new_dt.

data VIEW;

set TEST;

if A_EXP_DT = '99999999' then new_dt = '99991231';


RUN;

Spoiler

Spoiler

Expected outcome:

[EyalGonen]

I think this is what you want:

data VIEW;
set TEST;
new_dt = A_EXP_DT;
if A_EXP_DT = '99999999' then new_dt = '99991231';
RUN;

[PeterClemmensen]

How about

data VIEW;

   set TEST;

   new_dt = A_EXP_DT;
   if A_EXP_DT = '99999999' then new_dt = '99991231';

RUN;

[Rixile106]

exactly what i want .thank you  a lot

[Venky3110]

This may help
data VIEW;
set TEST;
A_EXP_DT =new_dt ;
if A_EXP_DT = '99999999' then new_dt = '99991231';
RUN;

[Peter_C]

It is what COALESCE functions do.
As this column seems to hold what looks like a date but as a character string, the particular function might be
COALESCEC()