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.
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.
are you honestly asking how to write a case when expression?
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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.