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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.