LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (September 2003, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Wed, 24 Sep 2003 08:33:16 -0400
Reply-To:   Howard Schreier <Howard_Schreier@ITA.DOC.GOV>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Howard Schreier <Howard_Schreier@ITA.DOC.GOV>
Subject:   Re: sql question numeric data in text field

The INPUT function can do the type conversion.

But that's assuming that you are using SAS native SQL. The bit about "before it is returned to SAS" suggests that maybe the problem involves pass-through SQL. In that case it depends on the features of the DBMS in question.

Also, it's not clear whether "check the value range" means (1) determine the range (by finding min and max, then subtracting) or (2) test individual values against some pre-specified range.

On Tue, 23 Sep 2003 16:00:46 -0600, William Kossack <kossackw@NJC.ORG> wrote:

>I don't know why they do it but I have a database where many of the >numeric values are stored as text. > >I'd like to write an sql query to check the value range of a field >before it is returned to SAS. Is there an easy way?

Back to: Top of message | Previous page | Main SAS-L page