concat

Question

Bivariate(
	Y( :Name( "Av_01_Age")),
	X( :Name( "Av T2_Age"))
);

rev = colstoredvalue(smary,"Source_Table",1);
bal = colstoredvalue(smary,"Source_Table",2);

How do i concat the values in rev and bal to x & y respectively?

txnelson · Accepted Answer

I am assuming that in your data table referenced as "smary" you have a column called column called "Source_Table".  Furthermore, row 1 contains the name of a column in your data table that you want to use as your X variable, and row 2 for the same column contains the name of the column you want to use for the Y variable.  Your data table would look somethin like

Given the above, here is the code to run the columns Height and Weight using Bivariate

names default to here(1);
smary=current data table();

rev = colstoredvalue(smary,:Source_Table,1);
bal = colstoredvalue(smary,:Source_Table,2);

bivariate(
	Y( column( bal) ),
	X( column( rev ) )
);

I guess I should have used the names AV_01_Age and AV T2_Age instead of height and weight.

If this is not what you are asking for, please provide more specifics and possibly sample data.

Byron_JMP · Accepted Answer

Just a quick note @skyzvoir0001 in your tables, the third column is character. (its aligned to the left). And all the other columns are numeric (aligned to the right).   For each table, you should set the columns that you intend to concat or stack to the same data and modeling types.   Especially if you intend to do a regression of the columns in the next step. If one column is supposed to be numeric and its character, then you'll get ANOVA rather than Bivariate reports.

This is how I work with this problem:

tables = {dtcon, dtrec, dtdea}; //list of the tables I need to format

For( ii = 1, ii <= N Items( tables ), ii++,          // this outside loop is for each table
	For( i = 3, i <= N Cols( tables[ii] ), i++,      // this inside loop is for each col in each table
                                                     // i=3 because I want every column after the 3rd col to be formatted.
			Column( tables[ii], i ) << Set Data Type( "Numeric" );
			Column( tables[ii], i ) << Set Modeling Type( "Continuous" );
	)
);