Group data for location

Hello,

I have sales data column for 3 indepedent stores, A, B and C, in 3 seperate tables

I want to merge table A and B and test if there is difference between this group and store C

So, store A + B against C

tableA
tableB
tableC
% Concatenate columns vertically
x = [A;B;C]; 
% the tables do not have equal rows, 
% therefore must concatenate them into a single column and use a grouping variable

% How should I change next line to make group A+B and single group C
group = [1 + zeros(size(A)); 2 + zeros(size(B)); 3 + zeros(size(C))];

% How should I change next line to make group A+B and single group C?

Thank you

Answer 1

[Walter Roberson]

group = [ones(size(A,1) + size(B,1),1); 2*ones(size(C,1),1)];

[Sarah Yun]

Hello

Is it possible to group by year?

I want to make two groups

First group for years 2000 and 2010

Second group for 2010 to 2015

Can this code do this?

Thank you.

[Walter Roberson]

group = (x.Year < 2010) + 1;

However you need to resolve the question of whether year 2010 is first group or second group.

Here, x represents the [A;B;C] combined table you made. x.Year assumes that there is a variable in the table named Year; if not then use an appropriate expression to extract the year from what you do have.