as a brody indicates, you need Appleworks v6 to run in Snow Leopard and Appleworks v6 requires Rosetta to be installed into Snow Leopard.
Rosetta is an optional install when you first installed Snow Leopard, but even if you did not originally install it, the first time you attempt to run a PowerPC application, it will direct you to a download of Rosetta from Apple's servers on the internet.
FWIW: I recently created a Snow Leopard partition on my 2011 Mac Mini, and I forgot to optionally install both Rosetta and QuickTime 7, which I always like to install in Snow Leopard. When I attempted to run a PowerPC app, it offered me the Rosetta download, which I accepted and now my PowerPC apps run fine.
But in answer to your original question, yes, you can use the Snow Leopard Install DVD to also install Rosetta after the fact (and QuickTime 7, too!)
If you have an earlier version of Appleworks 6 and you can get it to install, you can download the Appleworks v6.2.9 updater from Apple and update to the latest version available, here:
https://support.apple.com/kb/DL617?locale=en_US