DATA Step, Macro, Functions and more

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

Accepted Solution Solved
Reply
Contributor
Posts: 38
Accepted Solution

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

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.

 


Accepted Solutions
Solution
‎01-09-2018 09:03 PM
Super User
Posts: 13,084

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

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.

 

View solution in original post


All Replies
PROC Star
Posts: 1,357

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

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

Solution
‎01-09-2018 09:03 PM
Super User
Posts: 13,084

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

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.

 

Super User
Posts: 22,875

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 144 views
  • 0 likes
  • 4 in conversation