https://communities.sas.com/t5/SAS-Programming/Move-the-values-from-one-colum-into-another-column-by-proc-sql/m-p/426267#M105015 <P>It looks like this may work for the shown example:</P> <PRE>data want; set have; if ptype in ('FQHC' 'LAB' 'CHC') then do; Sunday_PO = Sunday_Dir; Monday_PO = Monday_Dir; end; run;</PRE> <P>though did not explicitly state that ptye=CHC should have the assignment as well that is what your output example shows.</P> <P>&nbsp;</P> Tue, 09 Jan 2018 22:38:09 GMT ballardw 2018-01-09T22:38:09Z https://communities.sas.com/t5/SAS-Programming/Move-the-values-from-one-colum-into-another-column-by-proc-sql/m-p/426262#M105011 <P>Hi ,</P><P>&nbsp;</P><P>I want to replace the one column values into another column for selected PTYPE values.</P><P>&nbsp;</P><P>For PTYPE FQHC,LAB Ii want to move the values from Sunday_Dir to Sunday_PO&nbsp; and Monday_Dir to Monday_PO.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><P>ptype</P></TD><TD><P>Sunday_Dir</P></TD><TD><P>Sunday_PO</P></TD><TD><P>Monday_Dir</P></TD><TD><P>Monday_PO</P></TD></TR><TR><TD><P>FQHC</P></TD><TD><P>09:00AM-05:00PM</P></TD><TD><P>00:00PM-00:00PM 00:00PM-00:00PM 00:00PM-00:00PM</P></TD><TD><P>09:00AM-05:00PM</P></TD><TD><P>00:00PM-00:00PM 00:00PM-00:00PM 00:00PM-00:00PM</P></TD></TR><TR><TD><P>LAB</P></TD><TD><P>09:00AM-06:00PM</P></TD><TD><P>00:00PM-00:00PM 00:00PM-00:00PM 00:00PM-00:00PM</P></TD><TD><P>09:00AM-05:00PM</P></TD><TD><P>00:00PM-00:00PM 00:00PM-00:00PM 00:00PM-00:00PM</P></TD></TR><TR><TD><P>CHC</P></TD><TD><P>09:00AM-07:00PM</P></TD><TD><P>00:00PM-00:00PM 00:00PM-00:00PM 00:00PM-00:00PM</P></TD><TD><P>09:00AM-07:00PM</P></TD><TD><P>00:00PM-00:00PM 00:00PM-00:00PM 00:00PM-00:00PM</P></TD></TR><TR><TD><P>PERS</P></TD><TD><P>09:00AM-05:00PM</P></TD><TD><P>00:00PM-00:00PM 00:00PM-00:00PM 00:00PM-00:00PM</P></TD><TD><P>09:00AM-05:00PM</P></TD><TD><P>00:00PM-00:00PM 00:00PM-00:00PM 00:00PM-00:00PM</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P><U>Need Data as below:</U></P><P><U>&nbsp;</U></P><TABLE><TBODY><TR><TD><P>ptype</P></TD><TD><P>Sunday_Dir</P></TD><TD><P>Sunday_PO</P></TD><TD><P>Monday_Dir</P></TD><TD><P>Monday_PO</P></TD></TR><TR><TD><P>FQHC</P></TD><TD><P>09:00AM-05:00PM</P></TD><TD><P>09:00AM-05:00PM</P></TD><TD><P>09:00AM-05:00PM</P></TD><TD><P>09:00AM-05:00PM</P></TD></TR><TR><TD><P>LAB</P></TD><TD><P>09:00AM-06:00PM</P></TD><TD><P>09:00AM-06:00PM</P></TD><TD><P>09:00AM-05:00PM</P></TD><TD><P>09:00AM-05:00PM</P></TD></TR><TR><TD><P>CHC</P></TD><TD><P>09:00AM-07:00PM</P></TD><TD><P>09:00AM-07:00PM</P></TD><TD><P>09:00AM-07:00PM</P></TD><TD><P>09:00AM-07:00PM</P></TD></TR><TR><TD><P>PERS</P></TD><TD><P>09:00AM-05:00PM</P></TD><TD><P>00:00PM-00:00PM 00:00PM-00:00PM 00:00PM-00:00PM</P></TD><TD><P>09:00AM-05:00PM</P></TD><TD><P>00:00PM-00:00PM 00:00PM-00:00PM 00:00PM-00:00PM</P></TD></TR></TBODY></TABLE><P><U>&nbsp;</U></P><P>Thanks in advance.</P><P>&nbsp;</P> Tue, 09 Jan 2018 22:29:21 GMT https://communities.sas.com/t5/SAS-Programming/Move-the-values-from-one-colum-into-another-column-by-proc-sql/m-p/426262#M105011 cho16 2018-01-09T22:29:21Z https://communities.sas.com/t5/SAS-Programming/Move-the-values-from-one-colum-into-another-column-by-proc-sql/m-p/426265#M105013 <P>are you honestly asking how to write a case when expression?</P> Tue, 09 Jan 2018 22:34:06 GMT https://communities.sas.com/t5/SAS-Programming/Move-the-values-from-one-colum-into-another-column-by-proc-sql/m-p/426265#M105013 novinosrin 2018-01-09T22:34:06Z https://communities.sas.com/t5/SAS-Programming/Move-the-values-from-one-colum-into-another-column-by-proc-sql/m-p/426267#M105015 <P>It looks like this may work for the shown example:</P> <PRE>data want; set have; if ptype in ('FQHC' 'LAB' 'CHC') then do; Sunday_PO = Sunday_Dir; Monday_PO = Monday_Dir; end; run;</PRE> <P>though did not explicitly state that ptye=CHC should have the assignment as well that is what your output example shows.</P> <P>&nbsp;</P> Tue, 09 Jan 2018 22:38:09 GMT https://communities.sas.com/t5/SAS-Programming/Move-the-values-from-one-colum-into-another-column-by-proc-sql/m-p/426267#M105015 ballardw 2018-01-09T22:38:09Z https://communities.sas.com/t5/SAS-Programming/Move-the-values-from-one-colum-into-another-column-by-proc-sql/m-p/426270#M105018 <P><A href="http://video.sas.com/detail/videos/how-to-tutorials/video/4573016759001/performing-conditional-logic-in-sas?autoStart=true" target="_blank">http://video.sas.com/detail/videos/how-to-tutorials/video/4573016759001/performing-conditional-logic-in-sas?autoStart=true</A></P> Tue, 09 Jan 2018 22:44:30 GMT https://communities.sas.com/t5/SAS-Programming/Move-the-values-from-one-colum-into-another-column-by-proc-sql/m-p/426270#M105018 Reeza 2018-01-09T22:44:30Z