Jim, Thanks for the response. Myron and Jim From: 'Jim Belisle' via RBASE-L <rbase-l@googlegroups.com> Sent: November 16, 2021 7:25 AM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - Comparing R:Base Tables If you want to browse the info in table1 you could use BROWSE * FROM table1 WHERE ‘fieldname’ NOT IN (SELECT ‘fieldname’ FROM table2) That should give you what you want. James Belisle Making Information Systems People Friendly Since 1990
From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> <rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> > On Behalf Of myron.fineg...@gmail.com <mailto:myron.fineg...@gmail.com> Sent: Tuesday, November 16, 2021 8:14 AM To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> Subject: RE: [RBASE-L] - Comparing R:Base Tables CAUTION:This is an EXTERNAL EMAIL, STOP! and think before clicking on any links or opening attachments. 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 <mailto:rbase-l@googlegroups.com> <rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com%3e> > On Behalf Of javier.valen...@vtgonline.com <mailto:javier.valen...@vtgonline.com> Sent: November 9, 2021 10:48 AM To: rbase-l@googlegroups.com <mailto: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 <mailto:rbase-l@googlegroups.com> <rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com%3e> > On Behalf Of James Burroughs Sent: Saturday, November 6, 2021 8:29 PM To: rbase-l@googlegroups.com <mailto: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 <mailto: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 <mailto: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 <mailto: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. -- 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 <mailto:rbase-l+unsubscr...@googlegroups.com> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/SA0PR02MB743447FD9D797CF8602FC8DEA0999%40SA0PR02MB7434.namprd02.prod.outlook.com <https://groups.google.com/d/msgid/rbase-l/SA0PR02MB743447FD9D797CF8602FC8DEA0999%40SA0PR02MB7434.namprd02.prod.outlook.com?utm_medium=email&utm_source=footer> . -- 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/03cf01d7db34%247a9beb60%246fd3c220%24%40gmail.com.
