Date:         Mon, 22 Jan 2001 22:39:33 -0000
Reply-To:     sashole@bellsouth.net
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Paul Dorfman <paul_dorfman@HOTMAIL.COM>
Subject:      Re: Can I bring a flat file or a SAS dataset into a Proc SQL
Comments: To: David_Fickbohm@FFIC.COM
Content-Type: text/plain; format=flowed

David,

Please do not mind some counter-interrogation:

1) What SAS version do you use?
2) What database do you use?
3) In the database, is the key (claim number) indexed?
4) How many distinct keys are there in the flat file?
5) What are the type and length of the key?

Answering these questions may *considerably* help someone willing to help
you.

Kind regards,
====================
Paul M. Dorfman
Jacksonville, Fl
====================

>From: David Fickbohm <David_Fickbohm@FFIC.COM>
>Reply-To: David_Fickbohm@FFIC.COM
>To: SAS-L@LISTSERV.UGA.EDU
>Subject: Can I bring a flat file or a SAS dataset into a Proc SQL
>Date: Mon, 22 Jan 2001 17:09:12 -0500
>
>People:
>Does anyone know if it is possible to bring a flat file or a SAS dataset
>into a
>Proc SQL ?   I have a long list of claim numbers which I want to have the
>SQL
>statement check for in a database.    It would be cleaner to bring in a
>dataset
>with an include or something like that if it is possible.
>Thanks
>Dave

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com