SAS help JR field

Job ID: 34519744

Budget: $10 – $30 USD

I have a dataset and field last name. The names come like this. Here is an example

SMITH JR
VAN ALLEN SR
CLARK JR.

Need coding advice in SAS or SQL within SAS how I can update this field last name.
Related categories: SQL SAS