04-05-2013 09:55 AM
We currently are a MS shop and use SQL Server 2008 as our Data source.
Currently, we report with MS Excel and populate the sheets from Stored Procedures in SQL Server.
I'd like to use SAS to do most of the heavy lifting for this and use SAS to preform automated audits on the data that we currently mannually do in Excel where there's room for errors.
I working on a Doc right now to present to the team that i've created from some of the SAS marleting material and other SUGI docs and links.
I'd like to dress it up a little with some examples, but i currenlty don't have SAS installed on my PC.
Does anyone have some samples they'd like to share? SAS code and Excel picture?
04-05-2013 10:45 AM
Your requirements are quite vague, most of the projects I've been involved could fit into this.
Can you be more specific about "heavy lifting" and "automated audits", so we can help you with relevant information?
04-05-2013 11:10 AM
Step1: ETL-- running SAS (either Pass through, or with Libname Engine) to access and run MS SQL queries
Step2: ETL Run analysis on the data with SAS to insure quality and counts. ie zip codes are conforming to the requirements.
Step3 : ETL Load Excel Sheets from the data pulled from SQL Server. Simply population data with names and addresses and simple rows and columns.
Step4: Clean up any Excel formating with Excel tools
I've done similiar to this before, but don't currently have SAS installed to be able to do a 'Show'
04-05-2013 11:18 AM
Talk to a SAS Sales Rep, they'll provide you a copy for a short time to help out. Or sign up for the web based one, but you'll only be able to Step 2 with that.
To be honest, Step 1/2 can easily be managed within a Server environment.
Step3 and Step4 are where SAS is extremely useful.
04-05-2013 11:05 AM
Try googling papers on lexjansen.com and see if some papers have pictures and examples.
If you post more detailed examples you might get some more help.