Hi ,
If any part of the Name column that contains Pediatric it should be updated as Pediatric care center in the Participat column.
Id Name Participat
1 PM Pediatrics aaa
2 PM Pediatrics of Bayside bbb
3 Pediatrics oF selden ccc
4 Pediatrics ddd
5 Urgent care Ny eee
Want:
Id Name Participat
1 PM Pediatrics Pediatric care center
2 PM Pediatrics of Bayside Pediatric care center
3 Pediatrics oF selden Pediatric care center
4 Pediatrics Pediatric care center
5 Urgent care Ny eee
Thanks in advance
if index(name,'Pediatric') then Participat='Pediatric care center';
if index(name,'Pediatric') then Participat='Pediatric care center';
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.