Date:         Tue, 14 Jan 2003 15:36:42 +0100
Reply-To:     Peter Crawford <peter.crawford@DB.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Peter Crawford <peter.crawford@DB.COM>
Subject:      Re: Related Tables - One to Many
Comments: To: Sara Montgomery <sam4@POST.QUEENSU.CA>
Content-type: text/plain; charset=iso-8859-1

Hi Sara

Apply proq freq to a database view of the join.
To proc freq, that view should be as good as a sas table.

(I assumed the database could provide such a join view)
(of course, sas could perform the join, but the rdbms _should_ be faster)

Much depends on the structure of your database
and the things you want to count

If more advice is needed, we would more information.

Good Luck
Peter Crawford




Datum:         14/01/2003 15:14
An:            SAS-L@LISTSERV.UGA.EDU




Antwort an:    Sara Montgomery <sam4@POST.QUEENSU.CA>

Betreff:       Related Tables - One to Many
Nachrichtentext:

Can Proc Freq deal with tables that are related and have one-to-many
relationships?

Should the tables be merged (with merge-by) before, or can I use my database
to join them into a flat file before?

What is the best way to deal with this situation.

Thanks.





--

Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.

This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.