MDDB

[deleted_user]

Hi folks,
I'm new to SAS!!

Is it possile to create an MDDB?
Actually I'using this SAS code:

proc mddb data=sashelp.prdsale out=sasuser.mddb;
class prodtype product country region division;
class year quarter month / descending;
hierarchy country region division / name = 'Geographic Hierarchy';
hierarchy year quarter month / name = time display=YES;
var actual / n sum nmiss;
var predict / n sum nmiss uss min max;
run;


to create one and I receive the following error message:

"proc mddb data=sashelp.prdsale out=sasuser.mddb;
ERROR: Procedure MDDB not found"

Thanks a lot!

[Cynthia_sas]

Hi,
This Tech Support note:
http://support.sas.com/techsup/unotes/SN/018/018789.html
says
"The following error indicates that the product or solution which supplies this SAS Procedure is not installed as part of the SAS Server.

ERROR: Procedure XXXXX not found.

You can verify which products are licensed at your site by submitting
the following in a code window:

proc setinit noalias;
run;

Please contact your SAS Sales Representative to inquire about pricing and availability of SAS Software."

If you think you do have the right software licensed, then your next step is to make sure it is installed on the correct server. Your Sales Rep could help you find out which products need to be licensed on which server.
cynthia

[deleted_user]

I'm running an official licence on stand alone pc.
But I'm using EGuide 2.0, while this error msg cites 3.0 version.

Could somebody from SAS support clarify?
Of course I can provide all my licence details.

Thanks.
Dom

[Cynthia_sas]

Your best bet is to contact Tech Support directly on this issue, because they are really the best ones to investigate the details of your particular installation.

This is how you contact them:
http://support.sas.com/ctx/supportform/index.jsp

cynthia