Category: SAS

How to generate the month name from a numeric date value

Task: I have a SAS date and wanted to create a variable with the month name.

Here is how to do it……

Using MONNAMEw. format which is simple and easy.  MONNAMEw. format is available in SAS 9.X versions.

/*Use MONNAMEw. format*/

data …

ERROR: The MS Excel table (worksheetname) has been opened for OUTPUT.

I happend to stumbleupon a post from SAS support blog regarding the ERROR message in the LOG file when trying to output a SAS dataset in the form of Excel sheet.

Direct link:

ERROR: The MS Excel table (worksheetname) has been opened for OU…

ERROR: The MS Excel table (worksheetname) has been opened for OUTPUT.

I happend to stumbleupon a post from SAS support blog regarding the ERROR message in the LOG file when trying to output a SAS dataset in the form of Excel sheet.

Direct link:

ERROR: The MS Excel table (worksheetname) has been opened for OU…

ERROR: The MS Excel table (worksheetname) has been opened for OUTPUT.

I happend to stumbleupon a post from SAS support blog regarding the ERROR message in the LOG file when trying to output a SAS dataset in the form of Excel sheet.

Direct link:

ERROR: The MS Excel table (worksheetname) has been opened for OU…

Example 8.40: Side-by-side histograms

It’s often useful to compare histograms for some key variable, stratified by levels of some other variable. There are several ways to display something like this. The simplest may be to plot the two histograms in separate panels.SASIn SAS, the most d…

Example 8.40: Side-by-side histograms

It’s often useful to compare histograms for some key variable, stratified by levels of some other variable. There are several ways to display something like this. The simplest may be to plot the two histograms in separate panels.SASIn SAS, the most d…

Example 8.40: Side-by-side histograms

It’s often useful to compare histograms for some key variable, stratified by levels of some other variable. There are several ways to display something like this. The simplest may be to plot the two histograms in separate panels.SASIn SAS, the most d…

Using PROC IML to deploy EWMA model for market risk

Exponentially weighted moving average (EWMA) model, which is a straight-forward moving average method in market risk, could memorize the finite market movements and address the relationship among multiple asset prices. Comparing with other multivariat…