The SAS Output Delivery System and reporting techniques

SAS and MS Excel, selling my team on using SAS to populate Excel tables

Reply
Contributor
Posts: 20

SAS and MS Excel, selling my team on using SAS to populate Excel tables

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?

thanks


Super User
Posts: 5,254

Re: SAS and MS Excel, selling my team on using SAS to populate Excel tables

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?

Data never sleeps
Contributor
Posts: 20

Re: SAS and MS Excel, selling my team on using SAS to populate Excel tables

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'

thanks

Super User
Posts: 17,737

Re: SAS and MS Excel, selling my team on using SAS to populate Excel tables

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.

Super User
Posts: 17,737

Re: SAS and MS Excel, selling my team on using SAS to populate Excel tables

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.

Ask a Question
Discussion stats
  • 4 replies
  • 235 views
  • 0 likes
  • 3 in conversation