public override string[] ExportData()
{
DataTable dtNew = DataTable.CopyForExport();
//Get the response, treatment and covariate columns by removing all other columns from the new datatable
foreach (string columnName in dtNew.GetVariableNames())
{
if (Response != columnName && !Treatments.Contains(columnName) && (OtherDesignFactors == null || !OtherDesignFactors.Contains(columnName)) && RepeatedFactor != columnName && Subject != columnName && (Covariates == null || !Covariates.Contains(columnName)))
{
dtNew.Columns.Remove(columnName);
}
}
//if the response is blank then remove that row
dtNew.RemoveBlankRow(Response);
//Need to create a new column for "between" as we have to combine any interaction effects into one column
dtNew.CreateCombinedEffectColumn(Treatments, "between");
//Need to create a new column for "betweenwithin" as we have to combine any interaction effects into one column
List <string> treatmentsAndRepeatedFactors = new List <string>(Treatments);
if (RepeatedFactor != null)
{
treatmentsAndRepeatedFactors.Add(RepeatedFactor); //add in time to the factors
}
dtNew.CreateCombinedEffectColumn(treatmentsAndRepeatedFactors, "betweenwithin");
//If an interaction effect is selected then we need to combine values into single column
if (!String.IsNullOrEmpty(SelectedEffect))
{
//create a new column and add it to the table
DataColumn mainEffect = new DataColumn("mainEffect");
dtNew.Columns.Add(mainEffect);
if (SelectedEffect.Contains(" * ")) //then it is an interaction effect so we need to combine values from different columns
{
char[] splitChar = { '*' };
string[] effects = SelectedEffect.Split(splitChar, StringSplitOptions.RemoveEmptyEntries); //get the effect names that make up the interaction effect
foreach (DataRow r in dtNew.Rows) //go through each row...
{
StringBuilder combinedEffectValue = new StringBuilder();
foreach (string s in effects) //combine the values from each column into one string
{
combinedEffectValue.Append(MAIN_EFFECT_SEPERATOR + r[s.Trim()]);
}
r["mainEffect"] = combinedEffectValue.ToString().Trim(); //copy the new value to the new column
}
}
else //just copy the column selected in the dropdown
{
foreach (DataRow r in dtNew.Rows)
{
r["mainEffect"] = r[SelectedEffect].ToString();
}
}
}
//Now do transformations...
dtNew.TransformColumn(Response, ResponseTransformation);
if (Covariates != null)
{
foreach (string covariate in Covariates)
{
dtNew.TransformColumn(covariate, CovariateTransformation);
}
}
//Finally, as numeric categorical variables get misinterpreted by r, we need to go through
//each column and put them in quotes...
foreach (string treat in Treatments)
{
if (dtNew.CheckIsNumeric(treat))
{
foreach (DataRow row in dtNew.Rows)
{
row[treat] = "'" + row[treat] + "'";
}
}
}
if (OtherDesignFactors != null)
{
foreach (string odf in OtherDesignFactors)
{
if (dtNew.CheckIsNumeric(odf))
{
foreach (DataRow row in dtNew.Rows)
{
row[odf] = "'" + row[odf] + "'";
}
}
}
}
string[] csvArray = dtNew.GetCSVArray();
//fix any columns with illegal chars here (at the end)
ArgumentFormatter argFormatter = new ArgumentFormatter();
csvArray[0] = argFormatter.ConvertIllegalCharacters(csvArray[0]);
return(csvArray);
}
public override string[] ExportData()
{
DataTable dtNew = DataTable.CopyForExport();
//Get the response, treatment and covariate columns by removing all other columns from the new datatable
foreach (string columnName in dtNew.GetVariableNames())
{
if (Response != columnName && !Treatments.Contains(columnName) && (OtherDesignFactors == null || !OtherDesignFactors.Contains(columnName)) && (Covariates == null || !Covariates.Contains(columnName)) && RandomFactor1 != columnName && RandomFactor2 != columnName && RandomFactor3 != columnName && RandomFactor4 != columnName)
{
dtNew.Columns.Remove(columnName);
}
}
//if the response is blank then remove that row
dtNew.RemoveBlankRow(Response);
//Now do transformations...
dtNew.TransformColumn(Response, ResponseTransformation);
if (Covariates != null)
{
foreach (string covariate in Covariates)
{
dtNew.TransformColumn(covariate, CovariateTransformation);
}
}
//Finally, as numeric categorical variables get misinterpreted by r, we need to go through
//each column and put them in quotes...
foreach (string treat in Treatments)
{
if (dtNew.CheckIsNumeric(treat))
{
foreach (DataRow row in dtNew.Rows)
{
row[treat] = "'" + row[treat] + "'";
}
}
}
if (OtherDesignFactors != null)
{
foreach (string odf in OtherDesignFactors)
{
if (dtNew.CheckIsNumeric(odf))
{
foreach (DataRow row in dtNew.Rows)
{
row[odf] = "'" + row[odf] + "'";
}
}
}
}
string[] csvArray = dtNew.GetCSVArray();
//fix any columns with illegal chars here (at the end)
ArgumentFormatter argFormatter = new ArgumentFormatter();
csvArray[0] = argFormatter.ConvertIllegalCharacters(csvArray[0]);
return(csvArray);
}
