enhance the SAS DATA step language to allow execution of individual SQL statements from within and under the control of data step code
Interesting idea. Any example of what this would look like?A spin-off would be that if tests understand the like operator.
There have been no examples provided at this time.
I have added the #1 suggestion from 2009 to the 2012 ballot per your request. It was the one about adding line and column numbers to the log for macro code so that it is similar to a pure DATA Step.
I can't find it. Can you pls point me to it?
One can execute PROC SQL statements from DATA step using the technique in my SGF 2012 paper titled "Executing a PROC from a DATA Step", here:
While not a built-in function, it is a way to execute SQL from DATA step.
DS2 is a new SAS proprietary programming language that is appropriate for both advanced data manipulation and data modeling applications. ... the DS2 SET statement has been enhanced to accept ANSI SQL:1999. This allows SQL preprocessing of input tables which effectively combines the power of the two languages.
Does the idea discussed suggest the functionality similar to the SET statement with embedded SQL like in DS2?
I'm presenting a 3 hour SAS Global Forum 2013 pre-conference workshop titled "What will DS2 do for You", based on DS2 in SAS 9.4. DS2 allows execution of static SQL statements using the SQLEXEC() function, and execution of dynamic SQL statements (DS2 variables can be bound to statement parameters) using the pre-defined SQLSTMT package. I think you're going to like it . As soon as I get the presentation finished (YIKES!! What day is this already?!?), I'll be blogging a bit about DS2 on the SAS Training Post. Stay tuned - good things are coming!
Sas9.4 brings the function DOSUBL() which will enable this type of facility.
Paper presented by Rick Langston might be in the SAS Global Forum 2013 online procedings or elsewhere on the support.sas.com site. paper title was
Submitting SAS(r) code on the side
and when you're feeling brave you might try it (unsupported - so at your own risk) in SAS9.2 or 3 by requesting a download from your local customer support office.
So i down-vote on this idea.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.