Thanks to Tom to remember me taht the call execute will be executed after the datastep close. I fogot this. Instead to use this I prefer use this %macro condition_1;      sas code ... %mend; %macro condition_2;      sas code ... %mend; filename x temp lrecl=1024; data _null_;      file x;      length flow $2000;           if index("&flow",'FIRST CONDITION ') gt 0 then do;           put '%condifiton_1;';      End;      else do;           if index("&flow",'KPI_MO_REPORT') gt 0 then do;                put '%condittion_2;';           End;           else do;                put '%put call other macro programs if need ;';           end;      end; run; %inc x;; filename x; to debug it is more easy. ... View more

If you are creating stored process server sessions, the other option is to take advantage of the SAVE_ convention for saving macro variables from one request to the next one. This only works if you are using sessions. Basically what the server does is at the end of the request, it saves all the macro variables whose name begin with SAVE_ (not case-sensitive) and then when a new request reconnects to the session, it loads the macro variables back so they are available. This is a nice way to save state without having to embed values in the URL as name/value pairs. ... View more

Hi, Chris H has a nice blog post on strategies for eliminating clear-text passwords from SAS code: http://blogs.sas.com/content/sasdummy/2010/11/23/five-strategies-to-eliminate-passwords-from-your-sas-programs/ HTH, --Q. ... View more

Dear LE MOLAP is default format of OLAP used by SAS. If I understand well the process of SAS : The most difference is define by the Storage. The MOLAP stored all information on the server (physical). From a Star Schema or not, you build the definition of the Cube and create it, refresh modifiy etc .... The ROLAP is the most of time used with RDBMS, the data are inside the RDBMS, all request on the cube SAS transform the MDX query into SQL RDBMS. Look at this document, it is very good : http://support.sas.com/resources/papers/proceedings09/103-2009.pdf ... View more

Dear Quentin, As Admistrator of SAS BI plateform I can say, your post is a good job to provide right way for developpers. It depends how your administrator configures your Logical Stored Process Server  (Stored process or Worksapce server). If some options are omit or activated your solution could not work. For example if the nosyntaxcheck is not used, the reference to all External files will be lost. By default it is not the case for plateform SAS 9 TS2MX but this option must be activated in SAS 9.1.3 by the administrator or in your defintion of STP. For the moment I could say how is configure by default the logical STP server inSAS9.3 ( in 2-3 month perhaps). Best regards. ... View more

Bonjour, je ne sais si tu as eu ta réponse. Mais il ne faut surtout pas utiliser un "user unrestricted" pour le faire. Si le server de base de données et le schéma ont été défini, tu vas définir ta library Oracle avec le wizard et tu selectionne le user oracle par default. et pour ceux a qui tu veux donner accès tu ajoutes tous les utilisateurs au compte de l'utilisateur oracle. ... View more