Move column value to another column

[cho16]

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:

Provider Number	Type	Licence	PRVNPI	Liceno	NPIID
12345	PCP	12234	12879
56789	OBGYN	98009	90870
98707	DENTAL			67890	87965
98076	VISION			54326	27354
87653	BCP	23456	56437
98657	PPCP	67898	09646

Need:

Provider Number	Type	Licence	PRVNPI	Liceno	NPIID
12345	PCP	12234	12879	12234	12879
56789	OBGYN	98009	90870	98009	90870
98707	DENTAL			67890	87965
98076	VISION			54326	27354
87653	BCP	23456	56437	23456	56437
98657	PPCP	67898	09646	67898	09646

[PaigeMiller · Accepted solution]

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