Running the equivalent of a miner project in SAS code

Ullsokk — Mon, 20 Aug 2018 08:26:53 GMT

I am working on a system for building and maintaining 20-something predictive models. Thus far, we have built models in Miner, and the scores are updated daily. However, we now want to look at how to rig this system so that we can easilly re-run the models on newer data. This could be done maually, by updating the data sources, rerunning the models, and saving the new scorecodes. A pretty tedious process with several possibilities for manual errors. So I am considering running the models in sas code (using SAS studio\Enterprise Guide). Almost all the winning models are HP Forests, so I am pretty confident we can use the same model parameters for all models. It seems a lot faster to me to convert the miner project to sas code.

I am thinking running a macro loop through all the models, and have the program update every scorecode. This leaves me with a couple of questions.

Can I obtain the same output from EG/studio as Miner, as in a proc hp4\scorecode, and thus bypass all the manual work?

Are there any major problems to this approach?

Re: Running the equivalent of a miner project in SAS code

SASKiwi — Mon, 20 Aug 2018 09:04:47 GMT

If you are using an EM HP Forest, then to use the score code generated by the model you must use the HP4SCORE procedure. This procedure is only available in SAS Enterprise Miner. You could run this from EG connecting to a SAS server where EM is installed, but it definitely is not available in Base SAS.

https://documentation.sas.com/?docsetId=emref&docsetTarget=p1uhmtoprigyvkn147i1tw9e2ax0.htm&docsetVersion=14.3&locale=en

If you are going to run this regularly I would recommend running this as a batch job from a server-based scheduler.

topic Re: Running the equivalent of a miner project in SAS code in SAS Programming

Running the equivalent of a miner project in SAS code

Re: Running the equivalent of a miner project in SAS code