topic Re: replicate values from column A_EXP_DT to other new_dt in SAS Programming

replicate values from column A_EXP_DT to other new_dt

Rixile106 — Tue, 16 Nov 2021 11:37:58 GMT

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;

Expected outcome:

Re: replicate values from column A_EXP_DT to other new_dt

EyalGonen — Tue, 16 Nov 2021 11:45:02 GMT

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;

Re: replicate values from column A_EXP_DT to other new_dt

PeterClemmensen — Tue, 16 Nov 2021 11:46:46 GMT

How about

data VIEW;

   set TEST;

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

RUN;

Re: replicate values from column A_EXP_DT to other new_dt

Rixile106 — Tue, 16 Nov 2021 11:54:17 GMT

exactly what i want .thank you a lot

Re: replicate values from column A_EXP_DT to other new_dt

Venky3110 — Tue, 16 Nov 2021 12:07:26 GMT

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

Re: replicate values from column A_EXP_DT to other new_dt

Peter_C — Thu, 18 Nov 2021 11:45:47 GMT

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()