Date: Fri, 7 Jan 2000 19:21:42 GMT
Reply-To: "John M. Wildenthal" <jmwildenthal@MY-DEJA.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "John M. Wildenthal" <jmwildenthal@MY-DEJA.COM>
Organization: Deja.com - Before you buy.
Subject: Re: challenging problem
In article <firstname.lastname@example.org>,
Gijs Noordhoek <email@example.com> wrote:
> Here's a challenge for all SAS expert out there:
> I'm merging two datasets containing new data, provided by two
> companies. There's a partial overlap in the two datasets, and when
> overlap occurs, several checks have to be done to be able to choose
> figures from one of the datasets as the actual data.
> One possible check is to see whether the values compare with the
> obtained by a lineair forecast from past data.
> The problem is: I cannot create a forecast from within the datastep.
> First of all because I cannot pass datastep variables to a macro from
> within the datastep (because macro variables are set after the 'run'
> command has passed), second of all because you cannot nest datasteps
> run a proc forecast within a datastep.
> Creating all possible forecasts in advance is impossible: I would have
> to create at least 10000 forecasts for each month in the database,
> containing up to 10 years. Quite a waste of processing time when you
> imaging that I will probably only need a dozen of them.
> What I would like to be able to do, is to run an independent SAS
> program that I pass a few parameters to. Just as a *function* works in
> any ordinary programming language.
> Does anyone know if this is somehow possible and if not, if there's an
> alternative way of solving this problem?
Why not make a run through the two, grabbing the relevant data about
the observations with overlap for which you need forecasts, make the
forecasts, then remerge with the forecasts?
Sent via Deja.com http://www.deja.com/
Before you buy.