Date:         Fri, 7 Apr 2006 17:54:25 -0700
Reply-To:     Don <dmorgan@ROCKETMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Don <dmorgan@ROCKETMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: Advice on controlling SAS from inside excel.
Comments: To: sas-l@uga.edu
In-Reply-To:  <1144446931.106796.165870@v46g2000cwv.googlegroups.com>
Content-Type: text/plain; charset="iso-8859-1"

There are cases where I have sent complete sql insert routines over to
SAS for inserting info into tables.
To assemble the code properly I will assign a constant in the vb code
like q=chr(34). This allows forcing the quote where needed.
Then as the code is concatenated together in the VB I will place the q
before and after text values (to be inserted)
so that the sql syntax is correct and performs correctly.