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

[cho16]

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.

ptype	Sunday_Dir	Sunday_PO	Monday_Dir	Monday_PO
FQHC	09:00AM-05:00PM	00:00PM-00:00PM 00:00PM-00:00PM 00:00PM-00:00PM	09:00AM-05:00PM	00:00PM-00:00PM 00:00PM-00:00PM 00:00PM-00:00PM
LAB	09:00AM-06:00PM	00:00PM-00:00PM 00:00PM-00:00PM 00:00PM-00:00PM	09:00AM-05:00PM	00:00PM-00:00PM 00:00PM-00:00PM 00:00PM-00:00PM
CHC	09:00AM-07:00PM	00:00PM-00:00PM 00:00PM-00:00PM 00:00PM-00:00PM	09:00AM-07:00PM	00:00PM-00:00PM 00:00PM-00:00PM 00:00PM-00:00PM
PERS	09:00AM-05:00PM	00:00PM-00:00PM 00:00PM-00:00PM 00:00PM-00:00PM	09:00AM-05:00PM	00:00PM-00:00PM 00:00PM-00:00PM 00:00PM-00:00PM

Need Data as below:

ptype	Sunday_Dir	Sunday_PO	Monday_Dir	Monday_PO
FQHC	09:00AM-05:00PM	09:00AM-05:00PM	09:00AM-05:00PM	09:00AM-05:00PM
LAB	09:00AM-06:00PM	09:00AM-06:00PM	09:00AM-05:00PM	09:00AM-05:00PM
CHC	09:00AM-07:00PM	09:00AM-07:00PM	09:00AM-07:00PM	09:00AM-07:00PM
PERS	09:00AM-05:00PM	00:00PM-00:00PM 00:00PM-00:00PM 00:00PM-00:00PM	09:00AM-05:00PM	00:00PM-00:00PM 00:00PM-00:00PM 00:00PM-00:00PM

Thanks in advance.

[novinosrin]

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

[ballardw · Accepted solution]

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]

http://video.sas.com/detail/videos/how-to-tutorials/video/4573016759001/performing-conditional-logic...