data_preparation.sql_in File Reference

SQL functions for dummy coding categorical variables. More...

Functions
void	create_indicator_variables (text source_table, text out_table, text categorical_cols, boolean keep_null, text distributed_by)
	Create new table containing dummy coded variables for categorical variables. More...
void	create_indicator_variables (text source_table, text out_table, text categorical_cols, boolean keep_null)
	Create new table containing dummy coded variables for categorical variables. More...
void	create_indicator_variables (text source_table, text out_table, text categorical_cols)
varchar	create_indicator_variables (varchar message)
varchar	create_indicator_variables ()

Detailed Description

Date

June 2014

See also

Calculates dummy-coded indicator variables for categorical variables

Function Documentation

void create_indicator_variables	(	text	source_table,
		text	out_table,
		text	categorical_cols,
		boolean	keep_null,
		text	distributed_by
	)

Parameters

source_table	Name of table containing categorical variable
out_table	Name of table to output dummy variables
categorical_cols	Comma-separated list of column names to dummy code
keep_null	Boolean to determine the behavior for rows with NULL value
distributed_by	Comma-separated list of column names to use for distribution of output

Returns

Void

void create_indicator_variables	(	text	source_table,
		text	out_table,
		text	categorical_cols,
		boolean	keep_null
	)

Parameters

source_table	Name of table containing categorical variable
out_table	Name of table to output dummy variables
categorical_cols	Comma-separated list of column names to dummy code
keep_null	Boolean to determine the behavior for rows with NULL value

Returns

Void

void create_indicator_variables	(	text	source_table,
		text	out_table,
		text	categorical_cols
	)

varchar create_indicator_variables

(

varchar

message

)

varchar create_indicator_variables

(

)