Click on File > Print Reports > Books > Ahnfantel (mis-spelled, but I closed it and don't want to open it again. Chose "Print to file" and give it a reasoable name, like "Temp.txt". After it runs, open it with Notepad.
In Roots Magic you can use the custom report feature to print name, birth date/place, marriage date/place and death date/place. Then "print" to a text file, import it into Excel and work with it that way. * FTM may have a similar feature; RM and FTM are sort of the Ford and Chevy of Windows genealogy programs.
* That is, if you have a data base sof Pennsylvania Marriages, use Excel to filter just those people whose marriage place contains "Pennsylvania", and look them up; or use Excel to filter just people whose birth date is blank, and so forth.