https://communities.sas.com/t5/SAS-Programming/Comparing-Two-strings/m-p/237882#M43647 <P>Did you find the answer here:&nbsp;</P> <P>&nbsp;</P> <P><A href="https://communities.sas.com/t5/SAS-Procedures/Compare-two-columns-first-alphabetically/m-p/237473" target="_self">https://communities.sas.com/t5/SAS-Procedures/Compare-two-columns-first-alphabetically/m-p/237473</A>&nbsp;?</P> <P>&nbsp;</P> Fri, 04 Dec 2015 19:27:21 GMT hbi 2015-12-04T19:27:21Z https://communities.sas.com/t5/SAS-Programming/Comparing-Two-strings/m-p/237471#M43530 <P>Data set = mydata</P> <P>&nbsp;</P> <P>I need to compare column1 and column2 and create a column3 that gives me which comes first&nbsp;alphabetically. Example:</P> <P>&nbsp;</P> <P>Column1 = San Francisco</P> <P>Column2 = San Diago</P> <P>&nbsp;</P> <P>Column3 would = San Diago becaue San Diago comes before San Francisco alphabetically. How can I dio this?</P> Wed, 02 Dec 2015 21:16:33 GMT https://communities.sas.com/t5/SAS-Programming/Comparing-Two-strings/m-p/237471#M43530 Mattress58 2015-12-02T21:16:33Z https://communities.sas.com/t5/SAS-Programming/Comparing-Two-strings/m-p/237882#M43647 <P>Did you find the answer here:&nbsp;</P> <P>&nbsp;</P> <P><A href="https://communities.sas.com/t5/SAS-Procedures/Compare-two-columns-first-alphabetically/m-p/237473" target="_self">https://communities.sas.com/t5/SAS-Procedures/Compare-two-columns-first-alphabetically/m-p/237473</A>&nbsp;?</P> <P>&nbsp;</P> Fri, 04 Dec 2015 19:27:21 GMT https://communities.sas.com/t5/SAS-Programming/Comparing-Two-strings/m-p/237882#M43647 hbi 2015-12-04T19:27:21Z https://communities.sas.com/t5/SAS-Programming/Comparing-Two-strings/m-p/237930#M43652 You can view your previous questions by going to the top right corner, clicking on your icon and looking at your profile. Sat, 05 Dec 2015 02:08:42 GMT https://communities.sas.com/t5/SAS-Programming/Comparing-Two-strings/m-p/237930#M43652 Reeza 2015-12-05T02:08:42Z