Subscribe to DSC Newsletter

All Blog Posts Tagged 'stored' (4)

Code Examples of cross database relational computing in Java

Program development for data process often involves cross-database relational operations. The following example will illustrate Java’s method of handling these operations. sales table is in db2 database, employee table is in mysql database. The task is to join sales with employee through sellerid of sales table and eid of employee table, and filter out the data insales and employeethat…

Continue

Added by Jessica May on September 9, 2014 at 1:03am — No Comments

SAS Prompt Framework: SAS Shared Prompts are Scrumpdillyicious for a Stored Process!

When I was growing up, a big treat on a summer afternoon was to get a Dairy Queen ice cream cone dipped in chocolate. Dairy Queen advertised their treats as scrumpdillyicious, which they were to a seven year old!  If you are not aware, SAS ships some shared prompts that you can use with your stored process … and you guessed it … I think they are scrumpdillyicious!

Locating the Shared Prompts

SAS…

Continue

Added by Tricia Aanderud on November 12, 2012 at 6:00am — No Comments

SAS Code: Show the Values of All Macro Variables in Your SAS Session

SAS Business Intelligence applications use global macro variables to store information about the environment as well as prompt values entered by a user. When developing a Stored Process it is often helpful to review the values of these macro variables. A simple %PUT statement, %PUT _GLOBAL_ ; , will write a listing of the values of all global macro variables to the log, but the formatting leaves a lot to be desired. This post describes a simple utility macro,…

Continue

Added by Tricia Aanderud on October 12, 2012 at 6:29am — No Comments

SAS Stored Processes: 3 Tips to Improve Your Prompts

Here’s some usability tricks that I have learned with my SAS Stored Processes to make them more robust and harder to break.  Really the out-of-the box prompts provide a lot of functionality that really helps. That’s right – let’s build a better mousetrap!…

Continue

Added by Tricia Aanderud on May 16, 2012 at 6:01am — No Comments

Monthly Archives

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

On Data Science Central

© 2020   AnalyticBridge.com is a subsidiary and dedicated channel of Data Science Central LLC   Powered by

Badges  |  Report an Issue  |  Privacy Policy  |  Terms of Service