D0 is constant. Order of Magnitude is 10^2 ... View more

I want Demand to be integer. So D0*(1-cdf(p)) should be integer  ... View more

Thanks for your reply.  Solving the approximate problem in fallback solution for me. Problem involves maximizing the revenue (Demand*Price) where Price is variable and D=D0*(1-cdf(price)). I can make demand function linear but since revenue is Demand*Price therefore objective function would still be quadratic.  Do you know how efficient and accurate is PROC OPTLSO ? Is it recommended to solve a big optimization problem with PROC OPTLSO ?  ... View more

Ideally I don't want to have any upper bound on x. Lower bound is x>0. Also my whole optimization has non linear constraints and objective function but I can simple approximated version with linear constraints  ... View more

Hi Cynthia, Thanks for your reply. Information provided by you is helpful but I think I didn't explain my doubt properly. What I want is to implement a button in Excel which could open pre-generated reports(pdf, html, rtf-anything would work for me) from SAS defined library. I know that PDF file can not be open using excel as browser. I don't care whether these reports gets opened in excel or their particular browser (e.g Adobe reader for pdf, Word for rtf etc). I just want that on clicking this button should open reports which are located in predefined sas library in any browser (let say chrome for html or adobe reader for pdf). That is why I was trying to use 'x' statement to open a pdf file from SAS. ... View more

You are right about it. Basically x "\\network\temp\your_file.pdf" this code would also works in Windows as it just asks the windows to open the pdf file location at the path(through shell). But since I have to link this code to Excel and Excel doesn't allow me to use "x" commands. That is why I was asking a alternative to "x" statement. ... View more

Thanks for your reply. I really don't know much about AMO. I just started using it recently. But if leave excel out of the picture then just consider the case where I want to open a PDF report using SAS code. Is is possible somehow ? In simple words what I am trying to ask is: Is there any alternative of following statement in SAS ? x "path/report.pdf" ... View more

Well to my best knowledge I think that I can't use VBA to access SAS Library of Metadata server ... View more

Yes data changes are required in real time. So loading data at the start of optmodel won't going to work. ... View more