Date: Mon, 22 Jan 2001 22:39:33 -0000
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
Content-Type: text/plain; format=flowed
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
Paul M. Dorfman
>From: David Fickbohm <David_Fickbohm@FFIC.COM>
>Subject: Can I bring a flat file or a SAS dataset into a Proc SQL
>Date: Mon, 22 Jan 2001 17:09:12 -0500
>Does anyone know if it is possible to bring a flat file or a SAS dataset
>Proc SQL ? I have a long list of claim numbers which I want to have the
>statement check for in a database. It would be cleaner to bring in a
>with an include or something like that if it is possible.
Get your FREE download of MSN Explorer at http://explorer.msn.com