An Idea Exchange for SAS software and services

Comments
by PROC Star
on ‎05-13-2012 11:26 PM

Interesting idea. Any example of what this would look like?
A spin-off would be that if tests understand the like operator.

by SAS Employee Redwolf
on ‎05-17-2012 11:31 AM

There have been no examples provided at this time.

by SAS Employee Redwolf
on ‎05-17-2012 11:39 AM

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.

by PROC Star
on ‎05-17-2012 08:26 PM

I can't find it. Can you pls point me to it?

by SAS Employee JasonS_SAS
on ‎05-21-2012 11:14 AM

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:

  http://support.sas.com/resources/papers/proceedings12/227-2012.pdf

While not a built-in function, it is a way to execute SQL from DATA step.

by New Contributor Roman
on ‎07-02-2012 03:19 PM

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.

http://support.sas.com/documentation/solutions/ds2/

Does the idea discussed suggest the functionality similar to the SET statement with embedded SQL like in DS2?

by SAS Employee SASJedi
on ‎03-01-2013 05:00 PM

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 Smiley Happy.  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!

by Valued Guide
on ‎05-01-2013 07:43 PM

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

p.s.

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.

Idea Statuses
Top Liked Authors