title: How to find the length of a numerical variable using PROC SQL
body: <p>I have a dataset with a column of phone numbers. I want to filter this dataset using PROC SQL <code>WHERE</code> the length of the numbers is <strong>at least</strong> 7 digits.</p>
  
  <p>In normal SQL I can just apply a length function around a number and it works, however in SAS it won't let me apply it to a numerical column.</p>
  
  <p>My first instinct is to convert the column to a character and then find the length of that but I can only seem to state a size when I use the <code>put</code> function.
  However I dont even know the biggest size of my numbers as I can't calculate length!</p>
  
  <p>How do i find the length of a numerical value in SAS using PROC SQL?</p>