You can use SET BY together with first.CustId to keep track on one customers records (so you don't compare dates between different customers). You can use RETAIN statement or the LAG() function to hold/retrieve values between observations. The INTNX function lets you move your date monthly (among a lot of other valid intervals), which let you compare the dates between to observations. /Linus ... View more

I am certain that there are many ways to do this. On way I would try is first to split up your Possessions column so you will have each possession in separate columns, then transpose that table, so that you will have just one possession per row. After doing that, just do an inner join to the Objects table. /Linus ... View more

A search on "maximize likelihood function" got me over 200 hits on support.sas.com. It seems that you can do this in a variety of procedures/SAS products (OR, ETS, STAT...). So, first I guess you have to find out what kind of proc/product is best suited for you, by reading the documentation. /Linus ... View more

The best way to solve these kind of problems is to contact SAS tech support. /Linus ... View more

I'm not aware of any option to do this. But, when I do "Save project as...", chose different folder and save, then, the next time I open EG and open a project from Local computer, I find myself in the new folder. /Linus ... View more

All the information you need is in the replies to your previous post. If you think it's too complicated, I guess you have to write PROC PRINT DATA=xxx,RUN; ten times... /Linus ... View more

Is there a particular reason for you to use DBLOAD? The most obvious and common way to load Oracle from SAS would be using standard table populating techniques through an Oracle Libname. I.e. PROC APPEND, SQL INSERT INTO etc. /Linus ... View more

Are you sure that SAS/ACCESS was properly installed in SAS9? I think this issue is best solved by SAS tech support. Regards, Linus ... View more

Yes, you should be able t use DBMS views, as well as DBMS tables. And yes, your SAS code should work. SAS syntax are not dependent (in most cases) of what kind of data that you are accessing (SAS tables, SAS views, DBMS tables, DBMS views, Excel libname etc). /Linus ... View more

But if your tables don't have the same lay-out, you may wish to print them independently (but in the same program). You can use call execute from a data step that reads SASHELP.VMEMBER for instance. /Linus ... View more

With this extra info it's easier to answer the first question. No, you can't use SAS/CONNECT unless you have a SAS session at there server end. Bit for accessing an Oracle DB on the remote host, SAS/ACCESS to Oracle will be sufficient, at least to access that data in particular. To be able to assist with the design of your whole environment, I think you need direct assistance from a senior person, i.e. from SAS or an independent consultancy. Regards, Linus ... View more

If you intend to use Time Series Forecasting system, here is good starting point I believe. http://support.sas.com/documentation/cdl/en/etsug/60372/HTML/default/tfintro_toc.htm The key-word search for "Time Series Forecasting system" gives me approximate 600 hits, you must be able find the information needed there. Then you might consider posting in the SAS Forecasting forum were you have a better chance that a Forecasting person can help you out. /Linus ... View more

I believe SAS tech support is a better choice for solving these kind of issues. Regards, Linus ... View more

What value do you have for the DBMS option? When I use DLM ocr CSV, my data won't be in quotation marks. /Linus ... View more

I'm absolutely no forecast guy, but I believe that functionality in SAS/ETS is needed for forecasting purposes. Search information in the on-line doc, samples and papers etc on support sas.com. /Linus Message was edited by: Linus H ... View more