Solved: Re: Move the values from one colum into another column by proc sql

cho16 · Posted 01-09-2018 05:29 PM

Hi ,

I want to replace the one column values into another column for selected PTYPE values.

For PTYPE FQHC,LAB Ii want to move the values from Sunday_Dir to Sunday_PO and Monday_Dir to Monday_PO.

Need Data as below:

Thanks in advance.

ballardw · Posted 01-09-2018 05:38 PM

It looks like this may work for the shown example:

data want;
   set have;
   if ptype in ('FQHC' 'LAB' 'CHC') then do;
      Sunday_PO = Sunday_Dir;
      Monday_PO = Monday_Dir;
   end;
run;

though did not explicitly state that ptye=CHC should have the assignment as well that is what your output example shows.

novinosrin · Posted 01-09-2018 05:34 PM

are you honestly asking how to write a case when expression?

ballardw · Posted 01-09-2018 05:38 PM

It looks like this may work for the shown example:

data want;
   set have;
   if ptype in ('FQHC' 'LAB' 'CHC') then do;
      Sunday_PO = Sunday_Dir;
      Monday_PO = Monday_Dir;
   end;
run;

though did not explicitly state that ptye=CHC should have the assignment as well that is what your output example shows.

Reeza · Posted 01-09-2018 05:44 PM

Move the values from one colum into another column by proc sql