Thank you very much.   Yes I am using it through a company. I will suggest that SAS should be upgraded.     Thank you so much for you time and help. DJ ... View more

hi @WeiChen      I am using SAS 9.4 and it looks like its an old version because I tried the table* functions before but they didn't work giving me lots of error messages.     thanks for your reply anyway. DJ     ... View more

Thanks for your help @IanWakeling      BTW I only wanted you to run the program to see how the table is constructed because I felt I didn't explain the situation correctly. I am not expecting you to waste you time checking my work.    In terms of the calculations everything is correct. The only thing I was trying to improve is the look of the final table however there is no harm of checking it using PROC GLM.    Thank you very much. DJ ... View more

Hi @Rick_SAS    Thanks for your reply.     Its giving me the following errors   ERROR: Invocation of unresolved module TABLECREATE.   ERROR: Invocation of unresolved module TABLEADDVAR.   ERROR: Invocation of unresolved module TABLESETVARFORMAT.   ERROR: Invocation of unresolved module TABLEPRINT.   does that mean I am using an old version??       AS for the program, obviously I wasn't expecting you to use your own time to check my own work.. I only wanted you to run it to be able to see the output of the table because I wasn't able to upload a picture of the output here.      your help is greatly appreciated. Thanks a lot, DJ ... View more

I have attached the program and 2 different sets of data with it.   It would be great if you check it.   Any suggestion would be greatly appreciated.   Thanks, DJ ... View more

I ended up doing the following:   COL = {"DF", "SS", "MS", "Fratio", "pvalue"}; ANOVA = DF || SS || MS || Fratio || Pvalue; print ANOVA [rowname = factors colname =Col label="Factoraial ANOVA" format=10.03];   I defined the columns names first. I have used || to concatenate the columns and saved it as ANOVA. Finally in the print stage I have inserted the factor as rowname and specified the the format.    Even though I don't need every single column to be formatted in the format I used but I wasn't able to figure out how to use the method in the article you suggested.         ... View more

Hi    I am a bit confused. I have been trying to use the TablePrint Subroutine however I couldn't because I have my data in separate columns!!   I have read the article few times but I couldn't figure out how to get my data in the right format before I print it in table using the function you suggested.   Basically, I have the following columns which I need to print in a table together:   factors (character) DF (degrees of freedom)(numeric) SS (sum of squares)(numeric) MS (mean square)(numeric) F-ratio(numeric) p_value(numeric)   Can you please guide me.   Thanks DJ   ... View more

Hi @Rick_SAS    thank you for you reply.   It does work however I wanted to attach other columns to the matrix of o's and 1's and I want to sort them depending on the changes applied to the matrix of 0's and 1's!!   Thanks DJ ... View more

I have been given the task of finding the ANOVA table for a factorial design with 2 levels for each factor. I know that using PROC IML for this purpose is not convenient at all however it is not my choice.   I have been given a number of data sets with different number of factors in each data set the least is two and maximum is 4.   I can easily do the calculations for the data with one block only, however when the number of blocks exceeds 1 it gets quite complicated.   But now with the help I got in the community from such nice and helpful people like you I am almost done with program.     My main issue now is to construct the ANOVA table!! because I have used yates's method to do the calculations I had to put my main factors and interactions between the factors in a specific order: 1 A B AB C AC BC ABC and so on. For the ANOVA table I need them to be in the following order:   A B C AB AC BC ABC   Thats why I asked whether there is a possibility to change the order using the same code.  it seems impossible to do that usiing the same code Do you have any other suggestions?     Thanks, DJ ... View more

hi @PaigeMiller    Great, that works. Thanks a lot mate.   regards, DJ ... View more

Hi @PaigeMiller,     Ignore the fact that I am using a loop I can change that. In fact I did change it to the following:   if b > 1 then TB = data[+,]; print TB;   I am adding the elements of each column only if the number of columns, b, is greater than 1. The IF statement I used works however when the number of columns = 1, its giving me an error message as I have asked the program to print TB however haven't told the program what to do if b < 1. So it doesn't know what to print for TB.   ERROR: Matrix TB has not been set to a value.   obviously, if I take the last line off (print TB;) the error disappears.     I hope you understand my problem now. Thanks, DJ ... View more

hi @PaigeMiller    thanks for your reply.   I was trying to add the values of each column in a matrix if the number of columns, b, is greater than one.    What I did is I specified an array TB = j(b,1,0);   then I added my IF statement  if b > 1 then do i = 1 to b; . . . end; print TB;   because I initially sat the array entries to 0's when b is not equal to 1 it prints the value of 0 for TB but I want it to print nothing. I want it to ignore the calculations if b is greater than 1.   thanks, DJ ... View more