Date:         Wed, 24 Sep 2003 12:32:09 -0600
Reply-To:     William Kossack <kossackw@NJC.ORG>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         William Kossack <kossackw@NJC.ORG>
Organization: Posted via Supernews, http://www.supernews.com
Subject:      Re: sql question numeric data in text field
Content-Type: text/plain; charset=us-ascii

I finally had to handle it inside SAS

William Kossack wrote:

> this did not work
>
> the database I'm working with is access
>
> "Choate, Paul@DDS" wrote:
>
> > William - Is this what you're after?
> >
> > proc sql;
> >     select
> >         max(name) as max_name,
> >         min(name) as min_name
> >         from sashelp.class;
> >  quit;
> >
> > max_name  min_name
> >  William   Alfred
> >
> > Paul Choate
> > DDS Data Extraction
> > (916) 654-2160
> >
> > -----Original Message-----
> > From: William Kossack [mailto:kossackw@NJC.ORG]
> > Sent: Tuesday, September 23, 2003 3:01 PM
> > To: SAS-L@LISTSERV.UGA.EDU
> > Subject: sql question numeric data in text field
> >
> > 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?