Comparing Two strings

[Mattress58]

Data set = mydata

I need to compare column1 and column2 and create a column3 that gives me which comes first alphabetically. Example:

Column1 = San Francisco

Column2 = San Diago

Column3 would = San Diago becaue San Diago comes before San Francisco alphabetically. How can I dio this?

[hbi]

Did you find the answer here: 

https://communities.sas.com/t5/SAS-Procedures/Compare-two-columns-first-alphabetically/m-p/237473 ?

[Reeza]

You can view your previous questions by going to the top right corner, clicking on your icon and looking at your profile.