Move column value to another column

cho16 — Mon, 11 Jun 2018 15:39:24 GMT

Hi,

I want to move the column values from one to another.

I tried the below step and it doesn't work out.

data want;

set have;

LICENSE= liceno;

PRVNPI=npiid;

RUN;

Have:

Need:

Re: Move column value to another column

PaigeMiller — Mon, 11 Jun 2018 15:43:39 GMT

data want;
    set have;
    if not missing(license) then liceno=license;
    if not missing(prvnpi) then npiid=prvnpi;
run;