https://communities.sas.com/t5/SAS-Procedures/Splitting-a-numeric-variable/m-p/47704#M12837 Use the PUT function to convert the number into a formatted string and then you can use the SUBSTR function to pull out the piece.<BR /> <BR /> Doc Muhlbaier<BR /> Duke Mon, 11 Apr 2011 15:30:19 GMT Doc_Duke 2011-04-11T15:30:19Z https://communities.sas.com/t5/SAS-Procedures/Splitting-a-numeric-variable/m-p/47703#M12836 Hi, <BR /> <BR /> I have a simple question. If I have a numeric variable of a certain length, how can I select only certain digits of this variable into a new variable in a PROC SQL step? I am looking for a function similar to SUBSTRN for strings that would let me select, say, the left-hand 3 digits of a nine-digit number, or the digits 4 through 6 of this number.....<BR /> <BR /> Many thanks, <BR /> R. Mon, 11 Apr 2011 14:58:45 GMT https://communities.sas.com/t5/SAS-Procedures/Splitting-a-numeric-variable/m-p/47703#M12836 rdwest 2011-04-11T14:58:45Z https://communities.sas.com/t5/SAS-Procedures/Splitting-a-numeric-variable/m-p/47704#M12837 Use the PUT function to convert the number into a formatted string and then you can use the SUBSTR function to pull out the piece.<BR /> <BR /> Doc Muhlbaier<BR /> Duke Mon, 11 Apr 2011 15:30:19 GMT https://communities.sas.com/t5/SAS-Procedures/Splitting-a-numeric-variable/m-p/47704#M12837 Doc_Duke 2011-04-11T15:30:19Z