The database has two tables (for this example). Table 1 - has a unique identifier for each house in the community. There are 17,000 roof tops in the community. So, 17,000 rows. These do not change, it is a fixed structure. Table 2 - uses the same unique identifier. This table contains the property owners. There are approximately 32,000 rows of data. So, there can one or many rows of data for each house - the individual owners.
We would like to compare table 1 to table 2 for a roof top house (table 1) that does not have any owners (table 2). Meaning, are we missing any data? Once we get the concept we can apply it other situations. Myron and Jim Sheriff's Posse of Sun City West -----Original Message----- From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf Of javier.valen...@vtgonline.com Sent: November 9, 2021 10:48 AM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - Comparing R:Base Tables Jim, You have to be more specific in regards of what you want compared such as number of records, identical records, size of records and so on. I am sure if you provide more details a feasible solution will be found. I will guess that few if any of our member are familiar with SAS; the last time I used SAS was 25 years ago when I was working on multivariate regressions. Javier, Javier Valencia, PE 913-915-3137 -----Original Message----- From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf Of James Burroughs Sent: Saturday, November 6, 2021 8:29 PM To: rbase-l@googlegroups.com Subject: [RBASE-L] - Comparing R:Base Tables Does anyone know of an R:Base utility to compare two tables (something along the lines of "proc compare" in SAS)? Thanks, Jim -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/edf72567-0ee2-c71c-8db8-93769f5edb6d%40cox.net. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAAG1gU%2BA71stIig71BAFnx9iihQAAEAAAAF42Vq%2BBnPBIqeH3ImE/uOgBAAAAAA%3D%3D%40vtgonline.com. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/019601d7daf4%244433a670%24cc9af350%24%40gmail.com.