title: Range of values in set statement in Hive
body: <p>Is it possible to enter a range of values in the set statement in Hive:</p>
  
  <p>eg:
  PROC FORMAT;</p>
  
  <p>VALUE $ABCD</p>
  
  <p>'3000',</p>
  
  <p>'3001',</p>
  
  <p>'8816' - '8820',</p>
  
  <p>'1517' - '1599' = 'Y'</p>
  
  <p>OTHER = 'N';</p>
  
  <p>I need this format statement in SAS to be converted and I have entered the values in set statement of Hive so I can use the 'ABCD' value in a case statement later. I am unable to find a way out to write out the range of values.</p>
  
  <p>I cannot just list them out since they are not necessarily whole numbers.</p>