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>
>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?