Snipplr - webonomic http://snipplr.com/users/webonomic/tags/sql Recent snippets posted on Snipplr.com en-us Mon, 13 Oct 2008 20:51:35 GMT (SAS) Use Regular Expressions in Proc SQL http://snipplr.com/view/8774/use-regular-expressions-in-proc-sql/ You can use regular expressions within SQL. This can be quite powerful in selecting data that matches certain conditions. The following example shows a simple regular expression which selects only quarterly periods from a table containing years, quarters & months.

]]> Thu, 02 Oct 2008 13:16:09 GMT http://snipplr.com/view/8774/use-regular-expressions-in-proc-sql/ (SAS) Match Merge using Proc SQL http://snipplr.com/view/6448/match-merge-using-proc-sql/

]]> Sat, 24 May 2008 18:44:21 GMT http://snipplr.com/view/6448/match-merge-using-proc-sql/ (SAS) Using Proc SQL to summarize tables into groupings http://snipplr.com/view/6109/using-proc-sql-to-summarize-tables-into-groupings/ Using Proc SQL summarize the table sashelp.shoes grouping on

]]> Sat, 03 May 2008 15:19:18 GMT http://snipplr.com/view/6109/using-proc-sql-to-summarize-tables-into-groupings/ (SAS) Logical Expressions In SQL http://snipplr.com/view/5647/logical-expressions-in-sql/

]]> Tue, 01 Apr 2008 13:39:05 GMT http://snipplr.com/view/5647/logical-expressions-in-sql/