get_excel_range

Converts a column number into the according letter to form a cell reference
like it is used in 'Excel' (e.g "A1"). Also can compute a range from cell to
cell (e.g. "A1:BY22").

The main goal is to make descriptive evaluations easier to create bigger and more complex outputs in less time with less code. Introducing format containers with multilabels <https://documentation.sas.com/doc/en/pgmsascdc/v_067/proc/p06ciqes4eaqo6n0zyqtz9p21nfb.htm>, a more powerful summarise which is capable to output every possible combination of the provided grouping variables in one go <https://documentation.sas.com/doc/en/pgmsascdc/v_067/proc/p0jvbbqkt0gs2cn1lo4zndbqs1pe.htm>, tabulation functions which can create any table in different styles <https://documentation.sas.com/doc/en/pgmsascdc/v_067/proc/n1ql5xnu0k3kdtn11gwa5hc7u435.htm> and other more readable functions. The code is optimized to work fast even with datasets of over a million observations.

Tim Siebenmorgen

Powerful 'SAS' Inspired Concepts for more Efficient Bigger
Outputs

get_excel_range function

<dl><dt>row</dt>
<dd>Single row number.</dd>
<dt>column</dt>
<dd>Single column number.</dd>
<dt>from_row</dt>
<dd>Range start row.</dd>
<dt>from_column</dt>
<dd>Range start column.</dd>
<dt>to_row</dt>
<dd>Range end row.</dd>
<dt>to_column</dt>
<dd>Range end column.</dd></dl>

Arguments

Converts Numbers into 'Excel' Ranges — get_excel_range

<dl>

<dt>row</dt>
<dd>Single row number.</dd>


<dt>column</dt>
<dd>Single column number.</dd>


<dt>from_row</dt>
<dd>Range start row.</dd>


<dt>from_column</dt>
<dd>Range start column.</dd>


<dt>to_row</dt>
<dd>Range end row.</dd>


<dt>to_column</dt>
<dd>Range end column.</dd>

</dl>

get_excel_range: Converts Numbers into 'Excel' Ranges

Description

Usage

Value

Arguments

Examples