I assume you've already read the documentation: http://support.sas.com/documentation/cdl/en/imlug/63541/HTML/default/viewer.htm#imlug_langref_sect207.htm This includes references to paper, articles, and books. For a general understanding of numerical optimization, read Fletcher, R. (1987), Practical Methods of Optimization, Second Edition, Chichester, UK: John Wiley & Sons. or Gill, E. P., Murray, W., and Wright, M. H. (1981), Practical Optimization, New York: Academic Press. ... View more

Hi: Usually, if you are talking about an -existing- Excel workbook and you want to add a 3rd (new) sheet to an existing workbook, you would use either PROC EXPORT or the SAS Libname engine for Excel methods. (or you could use DDE methods to write to a new sheet in an existing workbook) If you are talking about creating a new workbook, using ODS methods, then you would either: 1) use ODS TAGSETS.EXCELXP and create your output using TAGSETS.EXCELXP suboptions to explicitly names the sheets (in this scenario, you would actually create Sheet1, Sheet2 and Sheet3 in the same SAS program). or 2) use ODS TAGSETS.MSOFFICE2K_X and create separate HTML files that you will then link together using MSOFFICE2K_X suboptions It really depends on what method you are using (or plan to use) to get your dataset from SAS to Excel. With the Export/Libname/DDE methods, you would use your SAS dataset directly to get the dataset (without titles, footnotes, any colors, fonts or formatting) into Excel. With ODS methods, you would typically use PROC PRINT or PROC REPORT to "list" your dataset's rows and columns in an Excel sheet - -with this method you could have titles, footnotes, colors and fonts in the output. cynthia ... View more

thanks alot ... View more

I'll remind everyone that this text editor treats LeftBracket-i-RightBracket as "begin italicize." To work around this, use a different index variable (such as x ) or put a space between the brackets (such as x[ i ]). ... View more

the rest of code2: con c1: sum {i in ISET}(col1**2 *lambda/(lambda+k)**2)<=10; con c2: sum {i in ISET}(col2**2 *lambda/(lambda+k)**2)<=10; con c3: sum {i in ISET}(col3**2 *lambda/(lambda+k)**2)<=10; con c4: (max_lamb+k)/(min_lamb+k)<= max_lamb/min_lamb; solve with nlpc / tech =qne; print k ; ... View more

You can use the RANDGEN call, which includes optional arguments for the mean and Std Dev. You first need to allocate a vector to store the data: proc iml; n=10; E = j(n,1); do i = 1 to 50; call randgen(E, "Normal", 0, 4); end; You can also get all 50 variables at once. Each column of the following matrix contains a sample from N(0, 4). E = j(n,50); call randgen(E, "Normal", 0, 4); For comments on generating random vectors efficiently, see http://blogs.sas.com/iml/index.php?/archives/9-Efficient-Sampling.html For a description of how to generate 50 variables that each have a different distribution, see http://blogs.sas.com/iml/index.php?/archives/117-How-to-Sample-from-Independent-Normal-Distributions.html ... View more

Turn off the notes output by adding the statement: option nonotes; before the proc iml statement. ... View more

Generating correlated MV data is a huge topic.  I discuss the best techniques (and provide SAS code to implement them) in Chapters 8, 9, and 16 of my book Simulating Data with SAS. ... View more

You didn't give the error message, so I don't know which of the errors you might be referring to. I see a few: (1) SAS/IML indexes vectors from 1, so the expression optn=j(0,11,.) is incorrect. (2) IML uses local variables in modules, so the variables estvar,col1,col2,col3, etc, are undefined within the modules. Maybe you intended to use a GLOBAL clause? ... View more