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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.