Posts Tagged ‘ vba ’

SAS and VBA (1) : cross tabulation and bar chart

September 27, 2012
By
SAS and VBA (1) : cross tabulation and bar chart

No other tools can challenge Excel’s stance in the data analysis world. I didn’t spot many computers that are not installed with it, and I assume that everybody who faces a computer during work has to use it sometime. With the power of VBA, it is a...
Read more »

Tags:
Posted in SAS | Comments Off

Transform a SAS data set to an Excel pivot table by VBA

May 10, 2012
By
Transform a SAS data set to an Excel pivot table by VBA

Pivot Table in Excel is the popular data report format, which is similar to an OLAP cube that aggregates data at any dimensions. To create a pivot table for a table with lots of columns, it usually takes 100+ drags and clicks to get job done, which is...
Read more »

Tags:
Posted in SAS | Comments Off

An easy solution for Multi-Sheet EXCEL reporting

September 29, 2011
By
An easy solution for Multi-Sheet EXCEL reporting

Currently the only way to output SAS datasets as a multi-sheet EXCEL workbook for reporting is to use ExcelXP ODS tagset. I like this method a lot, because it can generate stylish multiple EXCEL sheets and is highly customizable. However, in practice i...
Read more »

Tags:
Posted in SAS | Comments Off

An easy solution for Multi-Sheet EXCEL reporting

September 29, 2011
By
An easy solution for Multi-Sheet EXCEL reporting

Currently the only way to output SAS datasets as a multi-sheet EXCEL workbook for reporting is to use ExcelXP ODS tagset. I like this method a lot, because it can generate stylish multiple EXCEL sheets and is highly customizable. However, in practice i...
Read more »

Tags:
Posted in SAS | Comments Off

An easy solution for Multi-Sheet EXCEL reporting

September 29, 2011
By
An easy solution for Multi-Sheet EXCEL reporting

Currently the only way to output SAS datasets as a multi-sheet EXCEL workbook for reporting is to use ExcelXP ODS tagset. I like this method a lot, because it can generate stylish multiple EXCEL sheets and is highly customizable. However, in practice i...
Read more »

Tags:
Posted in SAS | Comments Off

A scorecard for default risk with sparkline

May 31, 2011
By
A scorecard for default risk with sparkline

In the 1st chapter of their must-read credit risk modeling book, Gunter and Peter used the ratios of working capital(WC), retained earnings(RE), earnings before interest and taxes(EBIT), sales(S) and market value of equity(ME) over either total liab...
Read more »

Tags: , ,
Posted in SAS | Comments Off

Proc Fcmp(1): from VBA to SAS

October 29, 2010
By
Proc Fcmp(1): from VBA to SAS

Why use SAS in finance: SAS is a distinguished software package in statistics with more than 40-year development history. Starting from as a scripting tool to do ANOVA for agricultural experimental design in North Carolina, SAS has been heavily built o...
Read more »

Tags: ,
Posted in SAS | Comments Off

Proc-x is looking for sponsors!

Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: [email protected]

Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.

SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.