DATA Step, Macro, Functions and more

Move column value to another column

Accepted Solution Solved
Reply
Contributor
Posts: 39
Accepted Solution

Move column value to another column

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


Accepted Solutions
Solution
‎06-11-2018 12:00 PM
Respected Advisor
Posts: 3,029

Re: Move column value to another column

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

View solution in original post


All Replies
Solution
‎06-11-2018 12:00 PM
Respected Advisor
Posts: 3,029

Re: Move column value to another column

data want;
    set have;
    if not missing(license) then liceno=license;
    if not missing(prvnpi) then npiid=prvnpi;
run;
--
Paige Miller
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 91 views
  • 0 likes
  • 2 in conversation