https://communities.sas.com/t5/SAS-Enterprise-Guide/Extracting-Characters/m-p/429778#M27720 <PRE><CODE class=" language-sas">data h; input var $15.; datalines; JIM325612 SARAH651291 ; data want; set h; want=compress(var,,'d'); run;</CODE></PRE> Mon, 22 Jan 2018 21:05:07 GMT novinosrin 2018-01-22T21:05:07Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Extracting-Characters/m-p/429772#M27718 <P>Trying to extract only characters from a column, i.e.</P><P>&nbsp;</P><P>JIM325612</P><P>SARAH651291</P><P>&nbsp;</P><P>Each has 6 digits behind them but the amount of characters vary. How do I just pull the characters using 'SUBSTR' or something similar?</P> Mon, 22 Jan 2018 20:58:09 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Extracting-Characters/m-p/429772#M27718 Tihannah 2018-01-22T20:58:09Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Extracting-Characters/m-p/429776#M27719 <PRE><CODE class=" language-sas">want=compress(your_variable,,'d');</CODE></PRE> Mon, 22 Jan 2018 21:02:06 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Extracting-Characters/m-p/429776#M27719 novinosrin 2018-01-22T21:02:06Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Extracting-Characters/m-p/429778#M27720 <PRE><CODE class=" language-sas">data h; input var $15.; datalines; JIM325612 SARAH651291 ; data want; set h; want=compress(var,,'d'); run;</CODE></PRE> Mon, 22 Jan 2018 21:05:07 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Extracting-Characters/m-p/429778#M27720 novinosrin 2018-01-22T21:05:07Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Extracting-Characters/m-p/429779#M27721 <P>Thank you so much! Worked perfect!</P> Mon, 22 Jan 2018 21:07:14 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Extracting-Characters/m-p/429779#M27721 Tihannah 2018-01-22T21:07:14Z