No, but if your infomaps are created used SAS code, that is, with PROC INFOMAPS, then of course you can dynamically build the code to create the Infomap. So the code will read the dictionary table looking for changes in the data and then add these new columns to the PROC INFOMAPS statement. I believe you can use the APPEND statment to add new columns to the Infomap.
... View more
The easiest way is to add the stored process to an Information Map. The information map can be added to the EGuide project. When the Infomap runs, your stored process containing the query will run and return the results in a dataset to Eguide. Tasks can then be linked to this dataset.
... View more
Stored Processes are the way to go. They can be run on the web via the Stored Process application or run for all the SAS clients - Eguide, WRS, Addin Microsoft Office. Very flexible. SAS programming skills plus a basic knowledge of HTML is all you need. There are tons of SAS Global Forum papers and the SAS documentation is also very thorough.
... View more
If the prompt value is not being entered by the user, why cant you let the stored process retrieve the case_code from a dataset or text file? oops just saw that this question is ages old...
... View more
weird. to totally rule out a possible problem with your credentials. log in with your credentials to a colleagues DI. just curious, when you are logging in, what is happening on the Metadata server? is there a pike in cpu? anything unusual? also you may want to check the logs of the metadata server to see if there is something strange going on. What do technical support have to say?
... View more
It could be a memory issue on the client side(especially with Di studio) but I am assuming you have closed the app and restarted. so other colleagues have no problems? Try getting a collegue to log into your client and see what happens.
... View more
how are you executing your job code? This conditional execution of jobs would typically be handled in your scheduling software. Please send some more details, perhaps this is solvable in some other way.
... View more
Could there we something going on with your metadata server? if both eguide and di are performing poorly in one environment the common element is the metadata server.
... View more
Resa, one possible solution would be to 'suppress' the STPBEGIN and STPEND macros in the Preprocess block of the DI Job. In the Preprocess block you could define two empty macros, for example %MACRO STPBEGIN; %MEND STPBEGIN. This way the macros will still be called however no function will be performed. Might work. Not tested. Cheers, Richard
... View more
What do you mean by "manually"? Are you using DI Studio? If so, right clicking on the table and selecting "open" will create an empty table for you. Or you can run your jobs which during the load step will create the required physical table.
... View more
With careful use of the %macro and %mend statements in the Precode and Postcode blocks of a transformation. It is perfectly possible to determine an execution order of the transformations and influence the entire control flow of an ETL job. Richard
... View more
