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 (January 2001, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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
Comments: To: David_Fickbohm@FFIC.COM
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 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

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