Home
Macro Language Elements
The section contains detailed specifications for all 1010data Macro Language elements.
Data Transformation
Data transformation operations use functions and expressions to functionally alter tabular data. These operations take 0, 1, or 2 tables as input and produce a single table as a result.
<stats:>
The <stats:> package provides more advanced statistics operations.
<stats:bin_column>
Computes bin locations and bin counts/density.

Macro Language Elements
The section contains detailed specifications for all 1010data Macro Language elements.
- Data Transformation
  Data transformation operations use functions and expressions to functionally alter tabular data. These operations take 0, 1, or 2 tables as input and produce a single table as a result.
  - <amend>
    Update a specified value, or column of values, either by entering a new value or by using an expression. The expression can be applied to the column the value is in or to another column.
  - <base>
    <base> is the concrete macro operation that represents the action of opening the initial table.
  - <col>
    <col> changes the display attributes of a column in a table. It does not change the name of a column, but it does change the heading, as an example.
  - <colord>
    <colord> tells the system which columns to display and in what order.
  - <cols>
    Modifies the metadata of multiple columns at once, based on a query result or formatted tabular input.
  - <columns>
    <columns> is a special operation that retrieves column information from a table.
  - <directory>
    <directory> returns a table that provides information about the child objects of a particular folder. These include any tables, folders, and queries that have been saved to that folder.
  - <find>
    Efficiently finds (without selecting) the first n rows, between the specified row numbers, where the specified Boolean value expression is true.
  - <ignore>
    <ignore> encases code in a Macro Language query that should not be executed by the system.
  - <link>
    Link a foreign table to a base table or worksheet. Both tables must share a column on which to link.
  - <materialize>
    Creates a new physical table.
  - <merge>
    Merge a table to another table or worksheet.
  - <meta>
    <meta> allows settings to be made at the level of an individual query (and saved along with the query).
  - <note>
    <note> may be used to place a comment in the Macro Language. The contents of the element is any standard text.
  - <sel>
    Select the rows relevant to your analysis.
  - <sort>
    Changes the order in which rows appear in a table by sorting according to the values in a column.
  - <stats:>
    The <stats:> package provides more advanced statistics operations.
    - <stats:bin_column>
      Computes bin locations and bin counts/density.
    - <stats:bin_numeric_2d>
      Computes 2-dimensional binning.
    - <stats:boxplot>
      Computes the lo, first quartile, median, 3rd quartile, and hi values for a text or numeric column.
  - <table>
    <table> is a special operation that creates a temporary table within the scope of a query.
  - <tabu>
    <tabu> defines a tabulation or cross-tabulation.
  - <transpose>
    <transpose> results in a table in which the rows from the original table are its columns and the columns from the original table are its rows.
  - <willbe>
    Define a new computed column in an existing worksheet with a value expression.
- Blocks
  Blocks allow users to reuse sections of Macro Language code and to parameterize values in that code for greater flexibility and power.
- Application Development

<stats:bin_column>

Computes bin locations and bin counts/density.

Description

<stats:boxplot> bins the data in COL and returns a row for each non-empty bin showing its lower edge and the number of values counted in it.

(Available as of version 21.00)

Syntax

<stats:bin_column breaks="[BREAKS]" column="[COL]" remove_na="1|0" cnt_name="[CNT_NAME]" nbins="[NUM BINS]" 
                cnt_as_text="0|1" sort="up|down"  min="[MINIMUM]" max="[MAXIMUM]" scale="linear|log10" density="0|1" binbybrks="0|1"/>

Attributes

breaks: Perform binning for each break.
column: Perform binning for COL.
remove_na: Convenience attribute to select out NAs before binning; default is 1.
cnt_name: Set name of the counr result; defaults to count.
nbins: Number of bins; defaults to 20. Ignored if COL is of type text or cnt_as_text is 1.
cnt_as_text: If COL is numeric and cnt_as_text="1", bins are computed as text type; defaults to 0.
sort: Sort all breaks in increasing (up) or decreasing (down) order; defaults to up.
min: Select minimum value; may be helpful for highly skewed data. Ignored if binbybrks is 1. This is the floor of the lowest bin, and any values less than this will not be counted.
max: Select maximum value; may be helpful for highly skewed data. Ignored if binbybrks is 1. Note that this is floor of the highest bin, and unlike min, does not exclude any values from being counted. Any value larger than this simply winds up in the top bin.
scale: Compute binning in linear or log10 scale; defaults to linear.
density: Compute density for each bin; defaults to 0.
binbybrks: If 1, the determination of the bin locations is performed separately for each break. If 0, all breaks share the same bin locations. Default is 0.