thank you very much.   I am going to use for the output of the ANOVA table only. For the calculations I will be using the numerical version.     Thanks, DJ ... View more

thanks for your reply. I will just use Ian's.   thanks, DJ ... View more

Thanks alot.   This is exactly what I wanted.   thanks again, DJ ... View more

Hi Rick,   I just want to know if its possible to edit the following code to have the matrix as a character matrix instead of numeric.   proc iml; start AllZeroOneComb(n); if n=1 then return ( {0,1} ); cmd = "m = expandgrid("; do i = 1 to n-1; cmd = cmd + "0:1, "; end; cmd = cmd + "0:1);"; *print cmd; CALL EXECUTE(cmd); return (m); finish; do n = 1 to 3; m = AllZeroOneComb(n); print m; end;   For example for n=2 I should get: "1" "A" "B" "A B"   Thanks, DJ ... View more

Nice one mate. That was very useful. Now my data matrices are looking so much better.     Thanks you very much, DJ ... View more

Thank you very much.   I managed to read all the variables into a matrix however I had to read the numerical  _NUM_ and character _CHAR_  variables separately even though I tried using _ALL_ to print all variable into one matrix but its not working. Are you aware of any reasons that can cause such a problem?     Also, is it possible to read the headings of the columns from excel as well? ... View more

Thanks for your reply.   I had hope that using a different method to import data will make some calculations easier to tackle. Right now, first I have to import the data from excel then read and assign each column to an array separately. Is there a way to put the whole data set in a matrix at once? ... View more

Is it read and used in a similar way as data from an excel file. Is there any advantages of using the SAS data set? ... View more

I tried to run your code but its giving the following error messages:       746 proc iml; NOTE: IML Ready 747 748 n = 5; 749 L = ListCreate(n); ERROR: Invocation of unresolved module LISTCREATE. statement : ASSIGN at line 749 column 1 750 L$1 = {0, 1}; - 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 751 do i = 1 to n - 1; 752 L$(i+1) = ( L$1 @ j(2**i, 1) ) || ( {1,1} @ L$i ); - 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 753 end; ERROR: END does not occur within DO group at line=753 col=1. 754 755 do i = 1 to n; 756 print (L$i); - 22 76 ERROR 22-322: Syntax error, expecting one of the following: #, ##, &, (, (|, ), *, **, +, -, /, //, :, <, <=, <>, =, >, ><, >=, @, [, ^=, `, |, ||. ERROR 76-322: Syntax error, statement will be ignored. 757 end; ERROR: END does not occur within DO group at line=757 col=1 ... View more

Unfortunately my task is to write it in SAS/IML. Otherwise I would have used the FACTEX procedure for sure. ... View more

Yes now its in the order I wanted. Sorry again I didn't understand the job of every step in this code because I am fairly new to SAS.   I appreciate your help, DJ ... View more

Is it possible to put this within a do loop?       In my case I have different data sets with different number of factors and I need the program to work for all of them.  The number of factors are calculated using a do loop, I want to put the "expandgrid" function within the loop so it prints the matrix of 0's and 1's depending on the number of factors. Is it possible? ... View more

Thanks ... View more