Your LIBREF must be no more than 8 characters - sqldatabase. Shorten it to just SQLDATA and see how you get on. ... View more

wow, Thank you so much ... View more

Thank you so much. ... View more

Thank you so very mcuh. It is a big help. ... View more

Here's a debugging tip: Try to reproduce your error on a standard SASHELP data set such as Sashelp.Class or Sashelp.Cars.  Often this will enable you to figure out what is going on because the sample data is (a) familiar and (2) simple. Furthermore, even if you can't figure it out yourself, you'll be able to post an example that others can actually run, which will make it easier for them to debug. For this example, I saw that the error says "type mismatch," which usually means comparing a numeric quantity with a character quantity.  Since I don't have your data, I don't know what types they are, but I was able to reproduce the problem with Sashelp.Class: proc iml; c = "USA"; /* character value */ use sashelp.cars; read all var{mpg_city} into X where(mpg_city^= c); I suspect that  iCom is numeric whereas FV_Section is character, or vice versa. ... View more

Thank you. ... View more

Try PROC CONTENTS or PROC PRINT. Maybe the data is corrupted? ... View more

Thank you all, it was very helpful. ... View more

Missed the %end statement. Sorry. ... View more

You want to use the REPEAT function, as discussed in the Getting Started chapter of my book. Several examples are here: http://blogs.sas.com/content/iml/2012/06/27/create-an-id-vector-for-repeated-measurements/ For the first two columns, you should read about the very useful Define2DGrid function, which wraps up some of the REPEAT and SHAPE functionality: http://blogs.sas.com/content/iml/2011/01/21/how-to-create-a-grid-of-values/ You can use that function to generate the indices for the first two columns: ij = Define2DGrid(1, 3, 3, 1, 3, 3); i = ij[,1];  j = ij[,2]; rname={a b c}; cname = {i j k}; c1 = rname ; c2 = cname; ... View more

There are two parts to the statement, firstly it makes a copy of columns 2 to the last column of Y, then the [,+] operation is applied to this intermediate matrix which has the effect of adding up the rows.  So Y is replaced by a column vector of its row sums where the first column is excluded from the summation. ... View more

Hi, Check out the user= system option. It allows you to specify that datasets with one-level names be written to a permanent directoy instead of work, e.g.: 297  options user="d:\junk"; 298  data x; x=1;run; NOTE: The data set USER.X has 1 observations and 1 variables. --Q. ... View more

Thank you very much. ... View more