You've got a lot of pieces to learn to accomplish this task.
First off, you'll need the SAS/Access for relational tables manual, both the general chapters and the Teradata specific ones.
Then you will probably need to know about parts of the DATA step to generate the message. That's in the base manuals. You should also look at some of the books by users on the SAS website (Cody's and Aster's come to mind).
If by "text message" you mean the SMS messages used by Cell phones, you will need to send those with the e-mail interface (That it done with the FILENAME, see
http://support.sas.com/kb/19/767.html ).
Doc Muhlbaier
Duke