Introduce a binary variable y[i] that is 1 if x[i] > 0: var x{dates} >=0 init 0 <= 100; con c1: sum{i in dates} x[i] <=100; var y{dates} binary; con c2: sum{i in dates} y[i] <= 3; con c3 {i in dates}: x[i] <= x[i].ub * y[i]; ... View more

Looks like you missed: ods tagsets.excelxp close; RUN; ... View more

Can you share how can we use tagsets.tableeditor in stored process? ... View more

Read David and Peter's paper carefully--and it will help you be able to explain why the predictive model you came up with using STEPWISE performed so badly when presented with new data. In big data, you would be as wise to ask a five year old to pick out important variables based on how cool the name sounded as to use STEPWISE methods.  Between bias of the estimators and poor control of multiple testing you have a recipe for a poor predictive model.  Clustering and classification trees will do much better. Steve Denham ... View more

Hi at this point my recommendation is to work with Tech Support at support.sas.com  There are some coding changes we are going through for this statement so we want to make sure you get the right guidance and support. They will be able to guide you through usage.  That way we can log your usage (no pun intended!) and work with you and your specific needs. ... View more

Hi Mr. Allison:     I appreciate your website of graph demos so much! Although your reply is so professinal ,but this problem has always existed. How to draw a bar chart with 2 bars, representing target and actual sales on each province in map graph, and use graduant color as background color of each province area, representing individual completion rate, also label drawing on each province area, that's really a business need. ... View more

Yes, the deletes as logical. If you wish to save space, use the REUSE= data set option (only valid with COMPRESS=YES for some reason...?). Be aware that the table can be fragmented and less efficient for querying. ... View more

The output location of graphs for SGPLOT or SGRENDER will normally depends on the ODS destination.  For SAS 9.3 in DMS mode, HTML is the default output, and the graphs will go to the temp work folder.  Output to LISTING destination will go to the users folder where you start your program (usually "C:\Users\<userid>").  You can change this behavior. Some destinations like HTML have a PATH option and the images will go to the folder specified in the PATH option.  GPATH can be specified for some destinations such as HTML and LISTING.  Graphs will be written to this folder. ... View more

If you have SAS/IML 12.1 (released with SAS 9.3M2), use the SAMPLE function. ... View more

Hello - Kenneth B. Kahn, University of Tennessee, shares some ideas in this paper: http://mktg.uni-svishtov.bg/ivm/resources/AnExploratoryInvestigationofNewProductForecastingPractices.pdf He has published a book of the very topic and some more recent research papers: VCU - School of Business Person Detail Thanks, Udo ... View more

Hello - There are numerous types of forecasting models that a skilled analyst can use. For automatic forecasting of large numbers of time series, only the most robust models should be used. The candidate models that are used in SAS Forecast Server are considered the most robust in the forecasting literature and these models have proven their effectiveness over time. For more details please have a look at: "Large-Scale Automatic Forecasting Using Inputs and Calendar Events" available here: http://www.sas.com/reg/wp/corp/3478 When using SAS Forecast Studio you will have access to a stored process which also runs a X12 ARIMA model - you can extend these existing stored processes with your own forecasting model at any point in time. When using HPF code instead of SAS Forecast Studio you can also extend the model library with any type of model you have in mind. Please refer to my paper: Extending SAS ® High-Performance Forecasting Using User-Defined Models and External Forecasts Thanks, Udo ... View more

Hi. You have to understand that no variable are created inside the datastep at runtime. Datastep is processed in two distinct phases, compile and runtime. It's at compile time that the layout(s) of the destination dataset(s) are defined, not at runtime. The interpreter will scan the code and allocate every variable referenced in the code (on a memory area known as Program Data Vector, or PDV, that will output entirely or partially to the destination dataset(s)), sometimes doing some assumptions about type and length of new variables that aren't what you expected, hence the use of LENGHT statement to guide SAS interpreter to the right assumptions. So when the code runs, everything is pretty well defined in terms of variables, lengths and types. In you're case the SAS interpreter has allocated a new variable (and defaulted to numeric size 😎 before the run time phase because it has seen the reference to it at compiler time. Hope the explanation is clear. Cheers from Portugal. Daniel Santos @ www.cgd.pt ... View more